Oracle 1Z0-052 Actual Tests : Oracle Database 11g: Administration I

Why wait for shipping when your exam date is already set? The moment your payment clears, Actual4test emails your 1Z0-052 practice material, and you can start working through the 285 Oracle Database 11g: Administration I questions within a minute.

Oracle 1Z0-052 Exam Overview:

Oracle 1Z0-052 Exam Syllabus Topics:

Oracle Database 11g: Administration I: Your Questions, Answered

Oracle Database 11g: Administration I Sample Questions:

Question 1

View the Exhibit and examine the initialization parameter settings.

Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)

A. SORT_AREA_SIZE
B. DB_16K_CACHE_SIZE
C. DB_KEEP_CACHE_SIZE
D. JAVA_POOL_SIZE
E. LOG_BUFFER
F. STREAMS_POOL_SIZE

Question 2

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 can share the OS group assigned to their OSDBA and OSOPER privileged groups
C. Both products must be installed by the same OS user
D. Both products must be installed by using the same ORACLE_BASE
E. Both products must be of the same version
F. Each product must be installed in a different ORACLE_HOME

Question 3

Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)

A. Diagnose and repair a data file corruption offline.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair failures on a standby database.
D. Recover from failures in the RAC environment.

Question 4

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

A. It can change the server mode from dedicated to shared and vice versa for an existing database.
B. It can register a database with Cloud Control and configure Database Control for the same database.
C. It can create new database templates only from existing templates or databases.
D. It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.

Question 5

You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (
startdate DATE,
enddate DATE,
class CHAR(20)
) ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

A. The rows are visible to all current sessions after the transaction in committed
B. The rows stay in the table only until the next transaction starts on the table
C. The rows stay available for subsequent sessions after the transaction is committed
D. The rows stay in the table only until session termination

Solutions: