Free 1Z0-062 Exam Dumps

Question 56

Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)

A. All data definition language (DDL) statements are written to the control file
B. Some DDL statements are written to an XML file in the ADR home
C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
D. Some data definition language (DDL) statements are written to the control file
E. Some DDL statements are written to a text file in the ADR home
F. The Alert Log still contains some DDL statements

Correct Answer:DE

Question 57

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
1Z0-062 dumps exhibit
What are three possible causes for the latch-related wait events?

A. The size of the shared pool is too small.
B. Cursors are not being shared.
C. A large number COMMITS are being performed.
D. There are frequent logons and logoffs.
E. The buffers are being read into the buffer cache, but some other session is changing the buffer

Correct Answer:ABD

Question 58

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)

A. inactive online redo log file group
B. a data file belonging to the default temporary tablespace
C. a data file belonging to the SYSAUX tablespace
D. server parameter le (SPFILE)
E. active online redo log le group
F. all the control flies

Correct Answer:AEF

Question 59

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?

A. It must be made up of a database name and a domain name.
B. It must be made up of the value in ORACLE_SID and HOSTNAME.
C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

Correct Answer:A
Using the DBCA to Create a Database (continued)
3. Database Identification: Enter the Global Database Name in The form database_name.domain_name, and the system identifier (SID). The SID defaults lo the database name and uniquely identifies the instance associated with the database.
4. Management Options: Use this page to set up your database so that it can be managed with Oracle Enterprise Manager. Select the default: "Configure the Database with Enterprise Manager." Optionally, this page allows you to configure alert notifications and daily disk backup area settings.
Note: Yon must configure the listener before you can configure Enterprise Manager (as shown earlier).

Question 60

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

A. Taking the MASTERTBS tablespace offline
B. Dropping the relationship between the tables
C. Adding the MASTERTBS tablespace to the recovery set
D. Putting the MASTERTBS tablespace in read-only mode

Correct Answer:BC
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV99978
If constraints for the tables in tablespace tbs1 are contained in the tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.