최신Oracle Database 11g: Administration I - 1Z1-052무료샘플문제

A. The command only displays the advice and the RMAN script required for recovery

B. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

C. The command performs the recovery and closes the failure

D. The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)

A. Add a data file to the temporary tablespace associated with the user HR.

B. Add a data file to the SMD tablespace.

C. Resize the data file associated with the SMD tablespace to make it larger.

D. Alter the data file associated with the SMD tablespace to grow automatically.

E. Change the segment space management for the SMD tablespace to automatic.

A. granting SELECT privilege to SMITH on V_$SESSION

B. granting SELECT privilege to SMITH on V$SESSION

C. granting SELECT privilege to SMITH on V$FIXED_TABLES

D. asking the user SMITH to run the catalog.sql script

E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

A. Optimizer statistics are collected automatically.

B. Only timed operating system (OS) statistics and plan execution statistics are collected.

C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

D. Snapshots cannot be collected manually by using the
DBMS_WORKLOAD_REPOSITORY package.

E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

A. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

B. Creating a table returns "ORA-00955: name is already used by an existing object."

C. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

D. Inserting a value in a table returns "ORA-01722: invalid number."

E. Running a query on a table returns "ORA-600: Internal Error."

A. They can be queried only by SYS even when the database is open

B. They contain information that is not available in data dictionary views

C. Some of them display data that is useful for SQL statement tuning

D. Read consistency is not guaranteed for these views

E. They display selected data from data dictionary base tables

A. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

B. Dropping a tablespace in your database

C. Re-creating the control files

D. Renaming the control files

E. Dropping a user in your database

A. temp files

B. data files

C. audit logs

D. control files

E. archived redo logs

F. RMAN backups

G. redo logs

H. audit files

A. The execution fails because SGA_TARGET and PGA_AGGREGATE_TARGET are
already configured

B. The execution is successful but does not enable automatic memory management because the MEMORY_MAX_TARGET parameter must be configured to a value greater than MEMORY_TARGET

C. The execution is successful and automatic memory management is enabled

D. The execution fails because the MEMORY_MAX_TARGET parameter must be
configured to 400M before configuring the MEMORY_TARGET parameter

A. Undo tablespace has only one datafile

B. Undotablespace has a datafile which is reused in cyclic manner

C. Undo tablespace is a temporary tablespace

A. not null constraint on the DATE_OF_BIRTH column

B. unique key constraint on the STUDENT_ID column

C. primary key constraint on the COURSE_ID column

D. check constraint on the COURSE_ID column

E. check constraint on the DATE_OF_BIRTH column

F. foreign key constraint on the COURSE_ID column