Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 251:

  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
  B. Add LISTENER2 and its SID_LIST details separately under the name LISTENER2 in LISTENER.ORA

• Question 252:

  Examine the following steps performed on a database instance:

  1.

  The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION

  2.

  The SKD user creates a table

  3.

  The SKD user grants the CREATE TABLE system privilege to the HR user

  4.

  The HR user creates a table

  5.

  The DBA revokes the CREATE TABLE system privilege from SKD Which statement is true after step 5 is performed?

  A. The table created by SKD is not accessible and SKD cannot create new tables
  B. The tables created by SKD and HR remain, but both cannot create new tables
  C. The table created by HR remains and HR still has the CREATE TABLE system privilege
  D. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users
  C. The table created by HR remains and HR still has the CREATE TABLE system privilege

• Question 253:

  Which statement is true regarding undo tablespace?

  A. Undo tablespace is a temporary tablespace.
  B. Only one undo tablespace can exist in a database.
  C. Undo tablespace can consist of only one data file that is reused in a cyclic fashion.
  D. Multiple undo tablespace can exist in a database but only one can be active at a time.
  D. Multiple undo tablespace can exist in a database but only one can be active at a time.

• Question 254:

  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
  D. a cron job
  E. expdp
  F. Enterprise Manager Database Control

• Question 255:

  Which three are true about UNDO data? (Choose three.)

  A. It is used during online backups to guarantee their consistency
  B. It is used to roll back failed transactions
  C. It is used to recover dropped tables by using FLASHBACK TABLE ... TO BEFORE DROP
  D. It is used to rewind a database by using FLASHBACK DATABASE
  E. It is used to provide read consistency
  F. It is used to enable ROLLBACK statements to roll back uncommitted updates
  D. It is used to rewind a database by using FLASHBACK DATABASE
  E. It is used to provide read consistency
  F. It is used to enable ROLLBACK statements to roll back uncommitted updates

• Question 256:

  Which statements listed below describe the data dictionary views?

  1.

  These are stored in the SYSTEM tablespace

  2.

  These are the based on the virtual tables

  3.

  These are owned by the SYS user

  4.

  These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE

  5.

  The V$FIXED_TABLE view can be queried to list the names of these views

  A. 1 and 3
  B. 2,3 and 5
  C. 1,2, and 5
  D. 2,3,4 and 5
  A. 1 and 3

• Question 257:

  In a database, EXAMPLE is the default tablespace and DEFERRED_SEGMENT_CREATION is FALSE.

  Examine these commands executed by SYS:

  

  What will be the outcome and why?

  A. U1.TAB1 will be created B. It will fail because U1 has no quota on EXAMPLE
  C. It will fail because U1 has no default tablespace
  D. It will fail because U1 does not have the CREATE TABLE privilege
  E. It will fail because U1 does not have the CREATE SESSION privilege
  D. It will fail because U1 does not have the CREATE TABLE privilege

• Question 258:

  Examine these facts about a database:

  The database default tablespace is USERS DEFERRED_SEGMENT_CREATION IS TRUE The default tablespace of USER1 is tbs1 USER1 has only these privileges: CREATE SESSION CREATE TABLE UNLIMITED quota on tbs1

  Examine these commands executed by USER1:

  

  What will be the outcome of the INSERT operation and why?

  A. A row will be inserted into EMP and an index entry will be inserted into a virtual column of EMP because USER1 has no quota on USERS
  B. It will fail because an indexed column cannot have NULL values
  C. It will fail because USER1 has no quota on USERS D. A row will be inserted into EMP but no index entry will be made into EMP_IDX
  E. A row will be inserted into EMP and an index entry will be made into EMP_IDX
  E. A row will be inserted into EMP and an index entry will be made into EMP_IDX

• Question 259:

  Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

  A. Data Files
  B. Control Files
  C. Parameter Files
  D. Online Redo Log Files
  E. Server Parameter File
  B. Control Files
  E. Server Parameter File

• Question 260:

  Examine the values for the following initialization parameters:

  FAST_START_MTTR_TARGET=0

  LOG_CHECKPOINT_INTERVAL=0

  Which two will be the implications of these values in your database? (Choose two.)

  A. The SGA advisor will be disabled
  B. The MTTR advisor will be disabled
  C. Automatic checkpoint tuning will be disabled
  D. Checkpoint information will not be written to the alert log file
  B. The MTTR advisor will be disabled
  C. Automatic checkpoint tuning will be disabled