1Z0-052 Exam Questions

The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

Examine the command: SQL>ALTER USR skd ACCOUNT LOCK; Which two statements are true after the command is executed? (Choose two.)

For which database operation would you need the database to be in the MOUNT state?

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window cl...

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?

You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=N Which statement describes the purpose of the...

Which two statements are true regarding the MRKT tablespace? (Choose two.) SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING 3...

View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants...

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...

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...

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

Which three statements are correct about temporary tables? (Choose three.)

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

Which two statements are true regarding a tablespace? (Choose two.)

Which two statements are true regarding Oracle Data Pump? (Choose two.)

Identify the two situations in which the alert log file is updated with details. (Choose two.)

Which two statements are true about alerts? (Choose two.)

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...

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements...

View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT...

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;...

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types woul...

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno...

Examine the following 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 use...

View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident?

What can you achieve by implementing reverse key index?

What is the effect of this command? SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;

You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP * ERROR at line 1: ORA...

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 th...

View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, you executed the following comm...

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements...

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 d...

What is the effect of this command? SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;

User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans; While the drop table operation is in progress; user B executes the following co...

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape: Which two statements are true about differential inc...

Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are p...

You are managing an Oracle Database 11g database with the following backup strategy: 1. On Sunday, an incremental level 0 tape backup is performed 2. Monday through Saturday, a cum...

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that perfor...

Which two operations can be performed on an external table? (Choose two.)

Which two statements are true regarding listeners? (Choose two.)

You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two stateme...

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. C...

A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the d...

Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)

You want to create a role to meet these requirements: 1. The role is to be protected from unauthorized usage. 2. The password of the role is not to be embedded in the application s...

View the Exhibit and identify the component marked with a question mark.

Note the following points describing various utilities in Oracle Database 11g: 1. It enables the transfer of data from one database to another 2. It provides a complete solution fo...

Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users. What could be the rea...