1Z0-052 Exam Questions

You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error: ORA-01555: snapshot too old...

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true? (Choose two.)

You created a new user in your database but missed assigning a default tablespace to that user. The user created a table without specifying the tablespace name. In which tablespace...

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tabl...

You want the size of the tablespace to increase when it is full. Which option would you use?

Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?

View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute the following c...

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which...

On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.)

Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement regarding the status of the datab...

In which two cases would you perform only consistent backup? (Choose two.)

You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value?

You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your d...

You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE .. command. You have...

You need to rename a data file of a tablespace. How would you perform this?

When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed: TZ set to America/New_york OC4J Configuration issue. /u01/ap...

User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lea...

While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention. What sh...

One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member's status?

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use...

Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?

You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement...

Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listene...

Your database is in the MOUNT state and you execute the following command to open it: ALTER DATABASE OPEN; What two actions are performed as a result of this command? (Choose two.)

In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?

View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of the emp table, and the constraint is not deferred. Which two statemen...

You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be spread across two data files. A bit...

You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?

You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shut...

One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it?

You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?; Which three values can be specifi...

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo lo...

Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the c...

You find today's performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today's p...

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriti...

You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the following error message: LSNRCTL> s...

The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in _____.

Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments t...

In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the...

You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, and dropped a couple of tablesp...

You are using the following command to clear the log file group: ALTER DATABASE CLEAR LOGFILE GROUP 2; In which case would the command be successful?

Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halt...

You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USER user01 IDENTIFIED BY oracle...

Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is s...