1Z0-052 Online Practice Questions and Answers

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

A. A role can be created only by a user with the SYSDBA privilege.

B. A role can be granted only multiple system privileges not multiple object privileges.

C. A role can be granted to another role.

D. A role can be password-protected.

E. Only one default role can be granted to a user.

Which statement is true regarding undo tablespace?

A. Undo tablespace is a temporary tablespace.

B. Only one undo tablespace can exist in a database.

C. Undo tablespace can consist of only one data file that is reused in a cyclic fashion.

D. Multiple undo tablespace can exist in a database but only one can be active at a time.

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the

profile.

Some user sessions are currently connected to the database instance and are using the APP_USER

profile.

This command is used to drop the profile:

SQL> DROP PROFILE app_user;

Which statement describes the result?

A. The command produces an error.

B. The profile is dropped and current user sessions use the DEFAULT profile immediately.

C. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.

Which two are true about AWR snapshots? (Choose two.)

A. They are always created automatically.

B. They can be modified by using DMLs.

C. They are not generated if STATISTICS_LEVEL is set to TYPICAL.

D. They are stored in the SYSAUX tablespace.

E. They can be retained forever.

Examine this LISTENER.ORA file:

How should you configure and start an additional listener LISTENER2 that listens for the same SID?

A. Create another configuration file called LISTENER2.ORA with only LISTENER2 details in it

B. Add LISTENER2 and its SID_LIST details separately under the name LISTENER2 in LISTENER.ORA

C. Add relevant details in DESCRIPTION under the existing LISTENER with a different port number in LISTENER.ORA

D. Add relevant details in SID_LIST_LISTENER under the existing LISTENER in LISTENER.ORA

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?

A. FULL

B. SCHEMAS

C. TRANSFORM

D. REMAP_SCHEMA

E. REMAP_TABLESPACE

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

A. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

C. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

D. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

E. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

Note the following points describing various utilities in Oracle Database 11g:

1.

It enables the high-speed transfer of data from one database to another

2.

It provides a complete solution for the backup, restoration and recovery needs of the entire database

3.

It enables the loading of data from an external file into table of an Oracle Database

4.

It provides a tape backup management for the Oracle ecosystem Which point describes Oracle Secure Backup?

A. 1

B. 2

C. 3

D. 4

E. 1,2 and 4

F. 1,2,3, and 4

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 source code or stored in a table. Which method would you use to restrict enabling of such roles?

A. Create the role with external authentication.

B. Create the role as a secure application role.

C. Create the role as a password-protected role.

D. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.

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 database server: $ impdp system/manager directory = DB_DATA

dumpfile = schemas.dat schemas = hr flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"

The command fails displaying the following error:

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA- 27037: unable

to obtain file status

What would you do to overcome the error?

A. Add the user, SYSTEM, to the schemas option.

B. Add the network_link = devdb.us.oracle.com option.

C. Change the dumpfile option to [email protected].

D. Replace the schemas option with the network_link = devdb.us.oracle.com

E. Replace the dumpfile option with the network_link = devdb.us.oracle.com