1Z0-052 Exam Questions

You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database: 1. SGA is allocated. 2. Control file i...

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After...

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

View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true about the output of the command?

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention g...

You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be th...

Which is the correct description of a pinned buffer in the database buffer cache?

In which situation would you use static database registration for a listener?

While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentatio...

See the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

To make audit information more productive, the DBA executes the following command before starting an audit operations: SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; Wh...

database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB databa...

Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored...

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance...

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capac...

Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET...

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps...

You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Databas...

Examine the following output: SQL> SELECT index_name,status FROM dba_indexes WHERE status='UNUSABLE'; INDEX_NAME STATUS --------------- --------------- EIND UNUSABLE Which two stat...

In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that re...

You have executed this command to change the size of the database buffer cache: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you execu...

Identify two situations in which the block header grows in a data block. (Choose two.)

You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also pr...

View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is o...

You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer (OUI) shows the message that says one of the product-specific prerequisite...

Which two statements about the background process of the database writer are true? (Choose two.)

The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single pro...

Which two statements are true regarding a PL/SQL package body? (Choose two.)

In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users: 1. The user account m...

Observe the information in the columns: 1. The SGA a. Text and parsed forms of all SQL statements 2. The cursor state b. Run-time memory values for the SQL statement, such as rows...

You are using Enterprise Manager to schedule backups for your database. Which type of script would be generated by the backup scheduler?

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

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

You have a large amount of historical data in a flat file. Some analysts in your organization need to query this data in the file. The file is too large to load the data in it into...

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?

View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The SL_REP user executes this command t...

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disab...

The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource...

Examine the following statement that is used to modify the primary key constraint on the SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE; Which three stat...

You execute the following command to change the status of the SALES tablespace: SQL> ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command? (Choose al...

Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)

You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode. Which two options do you have for performing us...

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing aler...

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE jo...

Which three statements are true about logical structures of the Oracle database? (Choose three.)

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode. Which two statements are true in this scenario? (Choose two.)