Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 151:

  Observe the structure of the table employees: The table contains 8475 records.

  

  One of the employees wants to know the names of all employees of the company. For this, he fires the following query:

  SELECT * FROM EMPLOYEES ORDER BY emp_fname;

  Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.

  Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?

  A. Rollback segment
  B. Temporary segment
  C. Data segment
  D. Index segment
  B. Temporary segment

• Question 152:

  Following is the list of locations in random order where oranfstab can be placed.

  1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab

  What is the sequence in which Direct NFS will search the locations?

  A. 1, 2, 3
  B. 3, 2, 1
  C. 2, 3, 1
  D. 1, 3, 2
  C. 2, 3, 1

• Question 153:

  Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?

  A. shutdown restore datafile 4; recover datafile 4; alter database open;
  B. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;
  C. Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;
  D. Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4; Sql alter database datafile 4 online;
  E. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;
  E. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;

• Question 154:

  Which of the following describes how a distributed resumable transaction behaves?

  A. The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.
  B. The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.
  C. The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction.
  D. None of the above.
  C. The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction.

• Question 155:

  View the Exhibit-1 to observe the maintenance window property. View the Exhibit-2 to examine the output of the query.

  Which two statements describe the conclusions? (Choose two.)

  EM-window (exhibit):

  

  sql-dba_autotask_client (exhibit):

  

  A. RESOURCE_PERCENTAGE should be increased.
  B. The repeat time for the window should be decreased.
  C. RESOURCE_PERCENTAGE should be decreased.
  D. The window duration should be increased.
  A. RESOURCE_PERCENTAGE should be increased.
  D. The window duration should be increased.

• Question 156:

  A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?

  A. Initiate an incomplete recovery operation using RMAN.
  B. Copy the table from a development database.
  C. Advise the user to rekey the data.
  D. Perform a Flashback Drop operation.
  E. Perform a Flashback Recovery operation.
  D. Perform a Flashback Drop operation.

• Question 157:

  You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?

  a.

  restore controlfile until time '09/30/2008:18:00:00';

  b.

  restore database until time '09/30/2008:18:00:00';

  c.

  restore spfile until time '09/30/2008:18:00:00';

  d.

  recover database until time '09/30/2008:18:00:00';

  e.

  alter database open resetlogs;

  f.

  alter database open;

  A. b, d, e
  B. b, d, f
  C. c, a, b, d, e
  D. c, a, b, d, f
  E. a, b, d, e
  A. b, d, e

• Question 158:

  Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)

  A. set SHARED_POOL_SIZE to zero
  B. set STATISTICS_LEVEL to BASIC
  C. set SGA_TARGET to a non-zero value
  D. set DB_CACHE_SIZE to a non-zero value
  E. set STATISTICS_LEVEL to TYPICAL or ALL
  A. set SHARED_POOL_SIZE to zero
  C. set SGA_TARGET to a non-zero value

• Question 159:

  What information does the report schema command not provide? (Choose all that apply.)

  A. Size of the datafiles
  B. Size of the tempfiles
  C. Date of last backup for datafiles and tempfiles
  D. Filenames for each datafile
  E. Checkpoint SCN associated with the last RMAN backup
  C. Date of last backup for datafiles and tempfiles
  E. Checkpoint SCN associated with the last RMAN backup

• Question 160:

  Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

  A. Undo retention guarantee for the database must be configured.
  B. Supplemental log must be enabled for the primary key.
  C. Supplemental log must be enabled.
  D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.
  B. Supplemental log must be enabled for the primary key.
  C. Supplemental log must be enabled.
  D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.