Oracle Oracle Database 1Z0-052 Questions & Answers

• Question 271:

  Which two can be exported by a non-administrative account by using Data Pump? (Choose two.)

  A. database

  B. tables

  C. tablespaces

  D. directory objects

  E. schemas

  Correct Answer: BE

• Question 272:

  You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:

  1.

  SGA is allocated.

  2.

  Control file is read.

  3.

  Redo log files are read.

  4.

  Instance recovery is started.

  5.

  Background processes are started.

  6.

  Data file headers are checked for consistency.

  7.

  Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?

  A. 7, 1, 5, 2, 3, 6, 4

  B. 1, 2, 3, 7, 5, 6, 4

  C. 7, 1, 4, 5, 2, 3, 6

  D. 1, 7, 5, 4, 2, 3, 6

  Correct Answer: A

• Question 273:

  You want to install an Oracle 11g database and deploy it on ASM. Your plan is to install both Oracle database and Grid Infrastructure.

  Which two are true in this scenario? (Choose two.)

  A. Grid Infrastructure must be installed first

  B. Both products must be installed by the same OS user

  C. Each product must be installed in a different ORACLE_HOME

  D. Both products must be installed by using the same ORACLE_BASE

  E. Both products must be of the same version

  F. Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups

  Correct Answer: CF

• Question 274:

  Which two are true about external tables? (Choose two.)

  A. They can be stored in Oracle Automatic Storage Management File System (Oracle ACFS)

  B. They can always be updated using SQL

  C. They have extents

  D. They support the ORACLE_DATAPUMP access driver.

  E. They support all DML operations.

  Correct Answer: BD

• Question 275:

  Which is true about the Database Configuration Assistant (DBCA)?

  A. It can register a database with Cloud Control and configure Database Control for the same database.

  B. It can change the server mode from dedicated to shared and vice versa for an existing database.

  C. It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.

  D. It can create new database templates only from existing templates or databases.

  Correct Answer: D

• Question 276:

  Which three are true about dynamic performance views? (Choose three.)

  A. Read consistency is not guaranteed for these views

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

  C. They display selected data from data dictionary base tables

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

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

  Correct Answer: ADE

• Question 277:

  Which two are true about FAST_START_MTTR_TARGET? (Choose two.)

  A. It is overridden by LOG_CHECKPOINT_INTERVAL

  B. If it is set to 0, the MTTR Advisor is disabled

  C. A higher value increases the I/O overhead

  D. It is applicable only when the database is in ARCHIVELOG mode

  E. A lower value increases the time taken to perform instance recovery

  Correct Answer: AC

• Question 278:

  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

  Correct Answer: E

• Question 279:

  Which two are true about the Data Recovery Advisor? (Choose two.)

  A. It can be used when a database IS MOUNTED

  B. It can be used when a database IS OPEN

  C. It can be used only with databases that are running in ARCHIVELOG mode

  D. It can repair only databases for which RMAN backups exist

  E. It can be used to take RMAN backups

  F. It can be used to validate RMAN backups

  Correct Answer: DF

• Question 280:

  Which two are true about data dictionary views? (Choose two.)

  A. DBA prefixed views are accessible when a database is in mount state

  B. A user can query the DBA prefixed with DBA or ALL or USER

  C. All data dictionary views are prefixed with DBA or ALL or USER

  D. A user may not necessarily be the owner of all objects that can be viewed by using the ALL prefixed views

  E. ALL or USER prefixed views display output that are subsets of the output from the DBA prefixed data views

  Correct Answer: CD