Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 221:

  You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME,

  DATE_OF_BIRTH, and COURSE_ID.

  The following constraints have to be enforced on this table:

  1) Each student must be uniquely identifiable by the STUDENT_ID.

  2) STUDENT_ID column should not be left blank.

  3) The student should not be less than 15 years of age.

  4) The student can only take a course that is specified in the COURSE table in the database.

  Which three constrains must be explicitly enforced on this table? (Choose three.)

  A. check constraint on the COURSE_ID column

  B. foreign key constraint on the COURSE_ID column

  C. check constraint on the DATE_OF_BIRTH column

  D. unique key constraint on the STUDENT_ID column

  E. not null constraint on the DATE_OF_BIRTH column

  F. primary key constraint on the COURSE_ID column

  Correct Answer: BCF

• Question 222:

  Examine these SQL statements and their output:

  

  Which two are true? (Choose two.)

  A. Transactions will wait until free space becomes available in the UNDO tablespace when they have failed to allocate space

  B. Inactive UNDO will be retained for at least 15 minutes

  C. Active UNDO will be retained as long as needed by the transactions

  D. Expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace

  E. The UNDO tablespace will grow automatically if there is not enough space to retain active UNDO

  Correct Answer: AC

• Question 223:

  Which two are true about the Inventory directory? (Choose two.)

  A. It should be created before installing Oracle software for the first time on a server

  B. It is shared by all Oracle software installations on a single server

  C. It is required only for Oracle Grid Infrastructure and Oracle Database software installations

  D. It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server

  E. It can be created only if the ORACLE_BASE environment variable is set

  Correct Answer: BD

• Question 224:

  Your database is using Automatic Memory Management.

  Which two SGA components must be managed manually? (Choose two)

  A. keep buffer pool

  B. shared pool

  C. redo log buffer

  D. default buffer cache

  E. large pool

  Correct Answer: AC

• Question 225:

  Examine these components: Execution plan for a non-embedded SQL statement Local, global, and package variables for a session Execution plan for a SQL statement contained in a PL/SQL program unit Results of executed queries and query fragments PL/SQL function result sets

  Which of these are stored in the shared SQL area?

  A. 1, 2, 4, and 5

  B. 1, 2, and 3

  C. 1 and 4

  D. 1 and 3

  Correct Answer: D

• Question 226:

  Which three can be used to schedule automated backups of the database? (Choose three.)

  A. DBMS_SCHEDULER

  B. RMAN

  C. DBMS_BACKUP_RESTORE

  D. a cron job

  E. expdp

  F. Enterprise Manager Database Control

  Correct Answer: DEF

• Question 227:

  Where is an expdp operation tracked?

  A. dump files

  B. log files

  C. control file

  D. Automatic Diagnostic Repository (ADR)

  E. master table (MT)

  Correct Answer: C

• Question 228:

  Your database instance is running. db01 is a net service name. You issue a connection request using the

  following command:

  SQL> CONNECT scott/tiger@db01

  Which component receives the request and establishes the appropriate connection?

  A. listener

  B. user process

  C. service name

  D. server process

  Correct Answer: A

• Question 229:

  Examine this LISTENER.ORA file:

  

  How should you configure and start an additional listener LISTENER2 that listens for the same SID?

  A. Create another configuration file called LISTENER2.ORA with only LISTENER2 details in it

  B. Add LISTENER2 and its SID_LIST details separately under the name LISTENER2 in LISTENER.ORA

  C. Add relevant details in DESCRIPTION under the existing LISTENER with a different port number in LISTENER.ORA

  D. Add relevant details in SID_LIST_LISTENER under the existing LISTENER in LISTENER.ORA

  Correct Answer: B

• Question 230:

  Which structure can span multiple data files?

  A. a bigfile tablespace

  B. an extent

  C. a temporary tablespace

  D. a permanent tablespace

  E. a segment

  Correct Answer: E