Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 181:

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

  Correct Answer: ACE

• Question 182:

  Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

  A. Shared SQL Area will be allocated in the shared pool

  B. Shared SQL Area will be allocated when a session starts

  C. Shared SQL Area will be allocated in the large pool always

  D. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always

  E. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool

  F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

  Correct Answer: AF

• Question 183:

  Examine the command that is used to create a table:

  SQL> CREATE TABLE orders (

  oid NUMBER(6) PRIMARY KEY,

  odate DATE,

  ccode NUMBER (6),

  oamt NUMBER(10,2)

  ) TABLESPACE users;

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

  Correct Answer: BD

• Question 184:

  After performing a clean shut down of the database instance for maintenance, you mount the database

  and then execute a command to open the database:

  SQL> ALTER DATABASE OPEN;

  Which two statements are true? (Choose two.)

  A. The online redo log files and online data files are opened

  B. All the online data files headers are checked for consistency

  C. Instance recovery is performed before opening the database

  D. The path and existence of all the log file members are checked

  Correct Answer: AB

• Question 185:

  View the Exhibit and examine the privileges granted to the MGR_ROLE role.

  The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator

  (DBA) grants MGR_ROLE to the user SKD by executing the command:

  SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;

  Which statement is true about the user SKD after he/she is granted this role? Exhibit:

  

  A. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it

  B. The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor

  C. The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION

  D. The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them

  Correct Answer: A

• Question 186:

  SQL> CREATE BIGFILE TABLESPACE MRKT

  2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING

  3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

  Tablespace created.

  SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;

  Database altered.

  Which two statements are true regarding the MRKT tablespace? (Choose two.)

  A. No more data files can be added to the tablespace.

  B. Segment space is managed by free lists in the tablespace.

  C. A user created without being assigned a default tablespace uses this tablespace.

  D. The tablespace can be dropped with the current setting with segments present in it.

  Correct Answer: AC

• Question 187:

  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

  Correct Answer: D

• Question 188:

  You executed the following command to create a password file in the database server:

  $ orapwd file = orapworcl entries = 5 ignorecase=N

  Which statement describes the purpose of the above password file?

  A. It records usernames and passwords of users when granted the DBA role

  B. It contains usernames and passwords of users for whom auditing is enabled

  C. It is used by Oracle to authenticate users for remote database administrator

  D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

  Correct Answer: C

• Question 189:

  Examine the command:

  SQL>ALTER USR skd ACCOUNT LOCK;

  Which two statements are true after the command is executed? (Choose two.)

  A. The SKD user cannot log in to the database instance

  B. The objects owned by the SKD user are not accessible to any user

  C. The other users can access the objects owned by the SKD user, on which they have access

  D. The password for the SKD user expires and the user is forced to change the password at the next log in

  Correct Answer: AC

• Question 190:

  For which database operation would you need the database to be in the MOUNT state?

  A. Renaming the control files

  B. Re-creating the control files

  C. Dropping a user in your database

  D. Dropping a tablespace in your database

  E. Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

  Correct Answer: E