Online Access Free 1Z0-053 Practice Test

You issued the following commands to configure setting in RMAN;
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then you issued the following command to take the backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of the above command?

• A.It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
• B.The backup will terminate because the FORMAT clause was not configured for the channel
• C.It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
• D.It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)

• A.Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
• B.When a resumable statement is suspended, the transaction that contains the statement is also suspended.
• C.A resumable statement can only be suspended and resumed once during the execution of the statement.
• D.You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
• E.A resumable statement is suspended only if an out of space error occurs.

Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

• A.It translates tasks into jobs for execution by the scheduler.
• B.It is spawned by the MMON background process at the start of the maintenance window.
• C.It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
• D.It determines the list of jobs that must be created for each maintenance window.
• E.It creates jobs without considering the priorities associated with them.

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

A user named Arren is executing this query:
select table_name, operation, undo_sql
from flashback_transaction_query t, (select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123) e where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.
Which of the following SQL statements will correct this problem?

• A.GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;
• B.GRANT FLASHBACK TO ARREN;
• C.GRANT SELECT_ANY_TRANSACTION TO ARREN;
• D.GRANT SELECT ANY VIEW TO ARREN;
• E.GRANT SELECT ANY TRANSACTION TO ARREN;