The Secret of Oracle 1z0-034 vce

Exambible offers free demo for 1z0-034 exam. "Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP", also known as 1z0-034 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1z0-034 exam, will help you answer those questions. The 1z0-034 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1z0-034 exams and revised by experts!


2020 Oracle Official New Released 1z0-034 ♥♥
https://www.certifytools.com/1z0-034-exam.html


Q1. You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. 

From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this? 

A. The EVEN parameter was not set. 

B. The SQL_TRACE parameter is set to FALSE. 

C. Enterprise Manager is not used. 

D. The STATISTICS_LEVEL parameter is set to BASIC. 

E. The TIMED_STATISTICS parameter is set to FALSE. 

Answer:

Q2. In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. 

Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task? 

A. using only the RMAN SWITCH command to set the new location for the data file 

B. placing the database in the MOUNT state for the restore and recovery operations. 

C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command. 

D. configuring two channels: one for the restore operation and the other for the recovery operation 

Answer:

Q3. Which four resources can directives be specified by using the Oracle Resource Manager? 

A. CPU usage 

B. degree of parallelism 

C. number of open cursors 

D. number of sorts performed 

E. idle time for blocking sessions 

F. number of I/Os requests 

Answer: A,B,E,F 

Q4. The EMP table exists in your schema. You want to execute the following query: SELECT ename, sal 

FROM emp 

AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE) 

WHERE ename = 'ALLEN' 

What are the minimum requirements for the statement to execute successfully? (Choose all that apply) 

A. ARCHIVELOG mode must be enabled 

B. Row Movement must be enabled for the table 

C. FLASHBACK must be set to ON for the database 

D. The UNDO_MANAGEMENT parameter must be set to AUTO 

E. The UNDO_RETENTION parameter must be set appropriately 

Answer: D,E 

Q5. In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. 

Which method must you use to recover the lost data? 

A. Complete Recovery with online redo log 

B. Complete Recovery with archived redo log 

C. Tablespace Point-in-Time Recovery (TSPITR) 

D. Incomplete Recovery with system change number (SCN) 

Answer:

Q6. Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables. 

1. CREATE TABLE employee_ext 

2. (employee_id, first_name, department_name) 

3. ORGANIZATION EXTERNAL 

4. ( 

5. TYPE ORACLE_LOADER 

6. DEFAULT DIRECTORY ext_dir 

7. LOCATION ('emp1.dmp') 

8. ) 

9. PARALLEL 

10. AS 

11. SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name 

12. FROM employees e, departments d; 

Which line of the command would cause an error? 

A. line 2, because the column names have been specified 

B. line 7, because file name must have a .dat extension 

C. line 3, because ORGANIZATION EXTERNAL has been specified 

D. line 9, because the PARALLEL option cannot be specified with one file name 

E. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table 

F. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement 

Answer: F External tables are created using the SQL CREATE TABLE...ORGANIZATION EXTERNAL statement. When you create an external table, you specify the followingattributes: 

1. TYPE - specifies the type of external table. The two available types are the ORACLE_LOADER type and the ORACLE_DATAPUMP type. Each type of external table is supported by its own access driver. 

* The ORACLE_LOADER access driver is the default. It can perform only data loads, and the data must comefrom text datafiles. Loads from external tables to internal tables are done by reading from the external tables' text-only datafiles . 

* The ORACLE_DATAPUMP access driver can perform both loads and unloads. The data must come from binary dump files. Loads to internal tables from external tables are done by fetching from the binary dump files. Unloads from internal tables to external tables are done by populating the external tables' binary dump files. 

2. DEFAULT DIRECTORY - specifies the default location of files that are read or written by external tables. The location is specified with a directory object, not a directory path. 

3. ACCESS PARAMETERS - describe the external data source and implements the type of external table that was specified. Each type of external table has its own access driver that provides access parameters unique to that type of external table. 

4. LOCATION - specifies the location of the external data. The location is specified as a list of directory objects and filenames. If the directory object is not specified, then the default directory object is used as the file location. 

REF.: Oracle(r) Database 10g Utilities, 12-2 

Q7. Examine the following command that is used to duplicate a database on the same host: 

RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; } 

Which two statements describe the effect after the database is duplicated successfully? (Choose two) 

A. The data files of the read-only tablespaces in the target database are not duplicated 

B. The read-only tablespaces in the target database are still defined in new the database 

C. The read-only tablespaces in the target database are changed to online after duplication 

D. The data files of the read-only tablespaces in the target database get duplicated 

E. The read-only tablespaces in the target database are not defined in the new database 

Answer: A,B 

Q8. The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in the undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations. 

How would you achieve this? 

A. Implement a profile for the users. 

B. Implement external roles for the users. 

C. Set the threshold for the undo tablespace. 

D. Implement a Database Resource Manager plan. 

Answer:

Q9. Which three file types are managed by Data Pump jobs? 

A. out files 

B. log files 

C. alert files 

D. SQL files 

E. error files 

F. dump files 

Answer: B,D,F 

Q10. Your database is in NOARCHIVELOG mode. 

One of the two data files belonging to the SYSTEM tablespace is corrupt. 

You discover that all online redo logs have been overwritten since the last backup. 

Which method would you use to recover the data file using RMAN? 

A. Shut down the instance if not already shut down, restart in MOUNT state, restore both data files belonging to the SYSTEM tablespace from the last backup, and restart the instance. 

B. Shut down the instance if not already shut down, restart in mount state, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance. 

C. Shut down the instance if not already shut down, restart in mount state, restore all data files for the entire database from the last backup, and restart the instance. 

D. Shut down the instance if not already shut down, restart In MOUNT state, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance. 

E. Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data files for the entire database from the last backup, and restart the instance. 

Answer:

Reference: http://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmrecov.htm (restoring the server parameter file)