Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 131:

  A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

  A. Set REMOTE_OS_ROLES to FALSE

  B. Set OS_ROLES parameter to FALSE

  C. Set the REMOTE_OS_AUTHENT parameter to FALSE

  D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE

  Correct Answer: C

• Question 132:

  You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:

  1.

  SGA is allocated.

  2.

  Control file is read.

  3.

  Redo log files are opened.

  4.

  Instance recovery is started.

  5.

  Background processes are started.

  6.

  Data file headers are checked for consistency.

  7.

  Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?

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

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

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

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

  Correct Answer: A

• Question 133:

  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.

  Correct Answer: ACE

• Question 134:

  You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted? (Choose two.)

  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

  B. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

  C. The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.

  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively.

  Correct Answer: AD

• Question 135:

  Which two statements are true regarding listeners? (Choose two.)

  A. Listeners use only the TCP/IP protocol.

  B. Multiple listener processes can run simultaneously on a host.

  C. Multiple database instances can be registered with a single listener.

  D. The listener-related errors can be traced only at the administrative level.

  E. Only one database instance can be registered with a single listener at any time.

  Correct Answer: BC

• Question 136:

  Which two operations can be performed on an external table? (Choose two.)

  A. Create a view on the table

  B. Create an index on the table

  C. Create a synonym on the table

  D. Add a virtual column to the table

  E. Update the table using the UPDATE statement

  F. Delete rows in the table using the DELETE command

  Correct Answer: AC

• Question 137:

  View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:

  ORA-01555: snapshot too old What could be the reason for this error?

  Exhibit:

  

  A. The query is unable to get a read-consistent image.

  B. There is not enough space in Flash Recovery Area.

  C. There is not enough free space in the flashback archive.

  D. The query is unable to place data blocks in undo tablespace.

  Correct Answer: A

• Question 138:

  You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.

  Which data types would you use for the new column?

  A. CLOB

  B. BLOB

  C. BFILE

  D. LONG RAW

  Correct Answer: C

• Question 139:

  You are managing an Oracle Database 11g database with the following backup strategy:

  1.

  On Sunday, an incremental level 0 tape backup is performed

  2.

  Monday through Saturday, a cumulative incremental level 1 tape backup is performed Which two statements are true regarding the backups performed? (Choose two.)

  A. The backup performed in step 1 backs up all blocks that have ever been in use in the database

  B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup

  C. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup

  D. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1

  Correct Answer: AB

• Question 140:

  In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

  A. When the data file of the undo tablespace is autoextensible

  B. When there are more than one undo tablespace available in the database

  C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

  D. When the undo tablespace is autoextensible and retention guarantee is not enabled

  Correct Answer: C