Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 61:

  Some non-DBA users in your database have been granted ANY TABLE system privileges and they are able to access data dictionary base tables. You decide to restrict their access to data dictionary objects. Which method would you adopt to achieve this objective?

  A. Revoke the RESOURCE role from the users.

  B. Set the value of the OS_ROLES parameter to TRUE.

  C. Use Database Resource Manager to restrict user access to objects.

  D. Grant ANY TABLE system privileges again without ADMIN OPTION.

  E. Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE.

  Correct Answer: E

• Question 62:

  User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the

  following error after the INSERT statement is issued and few rows are inserted:

  INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)

  *

  ERROR at line 1:

  ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS

  Identify two actions either of which will help you resolve this problem. (Choose two.)

  A. Grant the RESOURCE role to SCOTT.

  B. Add data files to the USERS tablespace.

  C. Grant the CREATE ANY TABLE privilege to SCOTT.

  D. Increase the space for SCOTT on the USERS tablespace.

  E. Increase the size of the data file associated with the USERS tablespace.

  Correct Answer: BE

• Question 63:

  You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.

  What must this name be made up of?

  A. It must be made up of a database name and a domain name.

  B. It must be made up of the value in ORACLE_SID and HOSTNAME.

  C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

  D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

  Correct Answer: A

• Question 64:

  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.

  Correct Answer: BD

• Question 65:

  View the Exhibit and examine the output of the query.

  

  What do you infer from this?

  A. The SGA_TARGET is a static parameter.

  B. The instance is started, but the database is not yet open.

  C. The server parameter file (SPFILE) was used to start the instance.

  D. The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.

  Correct Answer: C

• Question 66:

  You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.

  Which three statements are true about these backups? (Choose three.)

  A. The backups would be consistent.

  B. The backups would be inconsistent.

  C. The backups would be possible only if the database is running in ARCHIVELOG mode.

  D. The backups would be possible only if the database is running in NOARCHIVELOG mode.

  E. The backups need to be restored and the database has to be recovered in case of a media failure.

  Correct Answer: BCE

• Question 67:

  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.

  Correct Answer: B

• Question 68:

  Which two statements are true regarding B-tree index? (Choose two.)

  A. The leaf blocks in the index are doubly linked.

  B. The leaf node stores a bitmap for each key value.

  C. The rows with NULL value in key columns also have entries in the index.

  D. The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.

  Correct Answer: AD

• Question 69:

  Given below is a list of scenarios:

  1.

  A user terminates his session abnormally.

  2.

  The connection between the server and the client application terminates because of a network failure.

  3.

  A schema is accidentally dropped.

  4.

  The tablespace is accidentally dropped from the database.

  5.

  The hard disk gets corrupted and the data files in the disk are lost.

  6.

  The database instance abnormally shuts down because of power failure. Which scenarios require DBA intervention to perform recovery?

  A. 1, 3, and 6

  B. 4, 5, and 6

  C. 3, 4, and 5

  D. 1, 2, and 6

  Correct Answer: C

• Question 70:

  You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?

  A. Use the external table population.

  B. Use the Oracle Data Pump export and import utility.

  C. Use the conventional path data load of the SQL*Loader utility.

  D. Use the INSERT INTO...SELECT command to load the data.

  Correct Answer: C