Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 241:

  You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value. Which is true?

  A. The change occurs immediately in memory for dynamic parameters but it is not persistent after instance restart
  B. It can be used only if an spfile is used
  C. The change occurs immediately in memory for static parameters but it is not persistent after instance restart
  D. It can be used only if a pfile is used
  A. The change occurs immediately in memory for dynamic parameters but it is not persistent after instance restart

• Question 242:

  Which two types of information can be found in the alert log? (Choose two.)

  A. instance recovery details
  B. values of all initialization parameters whenever an instance is restarted
  C. a record of all DDL statements performed by non-DBA users
  D. critical errors encountered by background processes
  E. a record of all actions performed by SYS and SYSTEM
  D. critical errors encountered by background processes
  E. a record of all actions performed by SYS and SYSTEM

• Question 243:

  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.
  C. A role can be granted to another role.
  D. A role can be password-protected.

• Question 244:

  In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:

  1.

  The user account must be locked after four unsuccessful login attempts.

  2.

  The user must be prompted to change the password at regular intervals.

  3.

  The user may not have more than three simultaneous sessions.

  4.

  The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above?

  A. By assigning profiles for the users
  B. By implementing Fine-Grained Auditing (FGA)
  C. By granting a secure application role to the users
  D. By implementing the Database Resource Manager plan
  A. By assigning profiles for the users

• Question 245:

  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.
  B. A NOT NULL constraint is created on the OID column.
  D. The ORDERS table and a unique index are created in the USERS tablespace.

• Question 246:

  Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:

  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;

  What affect would this command have on the database?

  A. The extents in the undo tablespace retain data until the next full database backup
  B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
  C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down
  D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten
  B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes

• Question 247:

  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.
  A. The query is unable to get a read-consistent image.

• Question 248:

  What can you achieve by implementing reverse key index?

  A. Reverse the bytes of each column indexed including the row ID
  B. Store a bitmap for each key value instead of a list of row IDs in the leaf node
  C. Prevent contention on the highest leaf block when using sequences to generate keys
  D. Remove repeated key values from the index to fit more index entries in a given amount of disk space
  C. Prevent contention on the highest leaf block when using sequences to generate keys

• Question 249:

  You executed this command to create a temporary table:

  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (

  startdate DATE,

  enddate DATE,

  class CHAR(20)

  ) ON COMMIT PRESERVE ROWS;

  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

  A. The rows stay in the table only until session termination
  B. The rows stay in the table only until the next transaction starts on the table
  C. The rows are visible to all current sessions after the transaction in committed
  D. The rows stay available for subsequent sessions after the transaction is committed
  A. The rows stay in the table only until session termination

• Question 250:

  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
  D. 1 and 3