1Z0-052 Online Practice Questions and Answers

Which two can be exported by a non-administrative account by using Data Pump? (Choose two.)

A. database

B. tables

C. tablespaces

D. directory objects

E. schemas

Which two are true about roles? (Choose two.)

A. A secure application role can be set only by its associated PL/SQL package.

B. A role can be granted a combination of system and object privileges and other roles.

C. Roles are owned by SYSTEM.

D. The CONNECT role is granted automatically to a user when it is created.

E. The RESOURCE role is granted the CREATE SESSION privilege.

Which is true about enabling AUTOEXTEND for data files?

A. It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablespace have autoextend enabled.

B. It can be enabled only for data files in non-OMF tablespaces.

C. It can be enabled only for data files only in smallfile tablespaces.

D. It can be enabled only for data files only in biglfile tablespaces.

E. It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.

Examine these components: Execution plan for a non-embedded SQL statement Local, global, and package variables for a session Execution plan for a SQL statement contained in a PL/SQL program unit Results of executed queries and query fragments PL/SQL function result sets

Which of these are stored in the shared SQL area?

A. 1, 2, 4, and 5

B. 1, 2, and 3

C. 1 and 4

D. 1 and 3

See the Exhibit:

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

A. A bitmap is used to record free extents

B. Free extents information is managed within the tablespace

C. Free extents information is managed in the SYSAUX tablespace

D. The data dictionary tables are updated when extents are allocated or deallocated

Examine the following command that is used to create a table:

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 tablepsace and a unique index is created on the OID column in the SYSTEM tablespace

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A. Lock statistics for the tables.

B. Change STALE_PERCENT to zero for the tables.

C. Set the TIMED_STATISTICS parameter to TRUE.

D. Set the STATISTICS_LEVEL parameter to BASIC.

E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

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 only 8 KB.

Which configuration could have enabled the block selection of 16 KB?

A. Choosing the extent allocation type to uniform

B. Choosing the Segment Space Management option to manual

C. Setting autoextension on for the data file mentioned for the tablespace

D. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

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?

A. Multiplex all database files.

B. Configure the Flash Recovery Area.

C. Configure the database instance for ARCHIVELOG mode.

D. Configure the FAST_START_MTTR_TARGET initialization parameter.

In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.

What action would you take to achieve this task?

A. Apply fine-grained auditing.

B. Implement value-based auditing.

C. Impose standard database auditing to audit object privileges.

D. Impose standard database auditing to audit SQL statements.

View the Exhibit and examine the output.

Which two statements are true regarding the LISTENER2 listener? (Choose two.)

A. The ORCL instance is registered dynamically with the listener.

B. The ORCL instance is registered statically in the listener.ora file.

C. The number of current client connections handled by the service handler is two.

D. The total number of client connections handled so far by the service handler is two.

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

On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock.

Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)

A. The session is terminated after receiving the error and JIM can continue with his transaction.

B. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

C. The session is rolled back after receiving the error and JIM can continue with his transaction.

D. SCOTT has to reexecute the last command in the transaction after he commits the transaction.

You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.)

A. Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.

B. Use Database Resource Manager to automatically log out sessions that block others and are idle

C. Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.

D. Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.

Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)

A. when the tablespace is online

B. when the tablespace has segments with data in it

C. when the tablespace is a default permanent tablespace for the database

D. when the tablespace contains a table that is currently being used by transactions

E. when the tablespace contains undo data that is needed to rollback an uncommitted transaction

Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)

A. Undo tablespace

B. USERS tablespace

C. SYSAUX tablespace

D. SYSTEM tablespace

E. Temporary tablespace