1Z0-052 Online Practice Questions and Answers

Your DB_RECOVERY_FILE_DEST_SIZE is 8G.

Currently, 5G of the space is used of which 4G consists of obsolete backups.

You execute this command:

SQL> ALTER SYSTEM SET db_recovery_fle_dest_size=2G;

What is the outcome?

A. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backups.

B. It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.

C. It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameter.

D. It fails because the new size is less than 5G.

E. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups.

You executed the following command to create a tablespace called SALES_DATA:

SQL> CREATE TABLESPACE sales_data

DATAFILE SIZE 100M

SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES_DATA tablespace? (Choose two)

A. The database automatically determines the extent-sizing policy for the tablespace.

B. The segments are automatically shrunk when the contents are removed from them.

C. The allocation of extents within the tablespace is managed through the dictionary tables.

D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

E. The space utilization description of the data blocks in segments is managed through free lists.

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 database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

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

A. Indexes and views can be created on temporary tables.

B. Both the data and the structure of temporary tables can be exported.

C. Temporary tables are always created in a user's temporary tablespace.

D. The data inserted into a temporary table in a session is available to other sessions.

E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?

A. The DML operations re-create the bitmap index blocks

B. The bitmap index is rebuilt automatically after a DML operation

C. The smallest amount of a bitmap that can be locked is a bitmap segment

D. Additional time is taken to remove NULL values from the bitmap index after a DML operation

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 in the new location. Given below are the steps to accomplish the task in random order:

1) Shut down the instance.

2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.

3) Execute the ALTER DATABASE FLASHBACK OFF command.

4) Start up the instance and mount the database.

5) Execute the ALTER DATABASE FLASHBACK ON command.

6) Open the database.

Select the correct order in which these tasks need to be performed.

A. 2, 1, 4, 3, 5, 6

B. 1, 4, 3, 2, 6, 5

C. 1, 4, 2, 6, 3, 5

D. 3, 2, 1, 4, 5, 6

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 must be locked after four unsuccessful login attempts.

2.

The user must be prompted to change the password at regular intervals.

3.

The user may not have more than three simultaneous sessions.

4.

The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above?

A. By assigning profiles for the users

B. By implementing Fine-Grained Auditing (FGA)

C. By granting a secure application role to the users

D. By implementing the Database Resource Manager plan

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

What are the two effects of this command? (Choose two.)

A. It fails if any existing row violates the constraint.

B. It does not validate the existing data in the table.

C. It enables the constraint to be enforced at the end of each transaction.

D. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

Which of these is true about undo tablespace?

A. Undo tablespace is a temporary tablespace

B. Undo tablespace has only one datafile

C. Undotablespace has a datafile which is reused in cyclic manner

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a

session and executes commands as follows:

SQL> INSERT INTO cust VALUES(101, 'JACK');

1 row created.

SQL> INSERT INTO cust VALUES(102, 'SMITH');

1 row created.

As a DBA, you execute the following command from another session:

ALTER TABLESPACE sales READ ONLY;

Which statement is true regarding the effect of this command on the transaction in Scott's session?

A. The command fails as a transaction is still pending.

B. The transaction in Scott's session is rolled back and the tablespace becomes readonly.

C. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.