[2018 Update] OCA Database 11g 1Z0-052 exam questions

In fact, you will pass your Oracle exam on your first try after using one of our OCA Database 11g 1Z0-052 exam questions. Certqueen engineers are providing latest OCA Database 11g 1Z0-052 exam questions as well as quality study for the Oracle 1Z0-052 guides examination. It would be effective to the 1Z0-052 candidates if they get Certqueen OCA Database 11g 1Z0-052 exam questions. The Oracle 1Z0-052 certificates give you possibility to work in any country of the world because they are acknowledged in all countries equally.


Share some 11g 1Z0-052 exam questions and answers below.
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
A. Failure when no standby database is configured
B. Failure because a data file is renamed accidentally
C. Failure that requires no archive logs to be applied for recovery
D. Failure due to loss of connectivity-for example, an unplugged disk cable
Answer: BD

Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
C.The snapshots collected by the AWR are accessible through data dictionary views.
D.The snapshots collected by the AWR are used by self-tuning components in the database.
Answer: CD

You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database.
Which option of IMPDP would you use to accomplish this task?
A. FULL
B. SCHEMAS
C. TRANSFORM
D. REMAP_SCHEMA
E. REMAP_TABLESPACE
Answer: D

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.
Which constraints will remain enabled by default during this operation? (Choose all that apply.)
A. CHECK
B. UNIQUE
C. NOT NULL
D. PRIMARY KEY
E. FOREIGN KEY
Answer: BCD

After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:
SQL> ALTER DATABASE OPEN;
Which two statements are true? (Choose two.)
A. The online redo log files and online data files are opened
B. All the online data files headers are checked for consistency
C. Instance recovery is performed before opening the database
D. The path and existence of all the log file members are checked
Answer: AB

Examine the command that is used to create a table:
SQL> CREATE TABLE orders ( oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamt NUMBER(10,2) ) TABLESPACE users;
Which two statements are true about the effect of the above command? (Choose two.)
A. A CHECK constraint is created on the OID column.
B. A NOT NULL constraint is created on the OID column.
C. The ORDERS table is the only object created in the USERS tablespace.
D. The ORDERS table and a unique index are created in the USERS tablespace.
E. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.
Answer: BD

Identify the two situations in which the alert log file is updated with details. (Choose two.)
A. Running a query on a table returns “ORA-600: Internal Error”
B. Inserting a value in a table returns “ORA-01722: Invalid Number”
C. Creating a table returns “ORA-00955: name is already used by an existing object’
D. Inserting a value in a table returns “ORA-00001: unique constraint (SYS.PK_TECHP) violated.”
E. Rebuilding an index using ALTER INDEX … REBUILD fails with an error “ORA-01578: ORACLE data block corrupted (file # 14, block @ 50).”
F. Rebuilding an index using ALTER INDEX …. REBUILD fails with an error “ORA-01578: ORACLE data block corrupted (file #14, block #50).”
Answer: AE

Note the following functionalities of various background processes:
1: Record the checkpoint information in data file headers.
2: Perform recovery at instance startup.
3: Cleanup unused temporary segments.
4: Free the resources used by a user process when it fails.
5: Dynamically register database services with listeners.
6: Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process?
A.Archiver Process (ARCn): 1, 2, 5
B.System Monitor Process (SMON): 1, 4, 5
C.Process Monitor Process (PMON): 4, 5, 6
D.Database Writer Process (DBWn): 1, 3, 4
Answer: C

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 stay in the table only until session termination
B. The rows stay in the table only until the next transaction starts on the table
C. The rows are visible to all current sessions after the transaction in committed
D. The rows stay available for subsequent sessions after the transaction is committed
Answer: A

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
A.Shared SQL Area will be allocated in the shared pool.
B.Shared SQL Area will be allocated when a session starts.
C.Shared SQL Area will be allocated in the large pool always.
D.Private SQL Area will be allocated in the Program Global Area (PGA) always.
E.Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F.The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
Answer: AF

Through this pleasant way you have better opportunity to learn more about IT technologies. We have a group of experts who are working to keep our Oracle 1Z0-052 Exam up to date and current. You will always get latest and the most comprehensive training materials at 1Z0-052! Certqueen OCA Database 11g 1Z0-052 exam questions is guaranteed to be 100% braindump free. We value the quality of training you receive through the OCA Database 11g 1Z0-052 exam questions and will never support 1Z0-052 braindumps, or any 1Z0-052 brain dump site.