Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 171:

  While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 m. on September 6, 2008.

  Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?

  

  A. B. C. D. E.
  C

• Question 172:

  Users are connected to a database instance that is using Automatic Storage Management (ASM). The DBA executes the command as follows to shut down the ASM instance:

  SQL> SHUTDOWN IMMEDIATE;

  What happens to the database instance?

  A. It shuts down long with the ASM instance.
  B. It is aborted and the ASM instance shuts down normally.
  C. It stays open and SHUTDOWN command for the ASM instance fails.
  D. It shuts down only after all pending transactions are completed and the ASM instance waits for this before shutting down.
  C. It stays open and SHUTDOWN command for the ASM instance fails.

• Question 173:

  Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.

  Which two actions will permit the TSPITR to work? (Choose two.)

  A. Taking the MASTERTBS tablespace offline
  B. Dropping the relationship between the tables
  C. Adding the MASTERTBS tablespace to the recovery set
  D. Putting the MASTERTBS tablespace in read-only mode
  B. Dropping the relationship between the tables
  C. Adding the MASTERTBS tablespace to the recovery set

• Question 174:

  You want to configure the Flashback Database feature and retain flashback logs for three days. Presently base is open and configured in ARCHIVELOG mode.

  The following steps must be performed in the correct sequence to do this:

  1.Set the retention target:

  SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;

  2.Enable Flashback

  Database:

  SQL> ALTER DATABASE FLASHBACK ON;

  3.Mount the database:

  SQL> STARTUP MOUNT EXCLUSIVE

  4.Shutdown the instance:

  SQL> SHUTDOWN IMMEDIATE

  5.Open the database:

  SQL> ALTER DATABASE OPEN; Choose the correct sequence.

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

• Question 175:

  During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?

  A. The installation terminates with an error.
  B. The installation proceeds with the default value without warnings and errors.
  C. The installation proceeds with the default value but it would not be an OFA-compliant database.
  D. The installation proceeds with the default value but a message would be generated in the alert log file.
  D. The installation proceeds with the default value but a message would be generated in the alert log file.

• Question 176:

  In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:

  SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUP BY sale_category;

  Where would the result of this query be stored?

  A. database buffer cache
  B. shared pool
  C. PGA
  D. large pool
  B. shared pool

• Question 177:

  Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:

  SQL> SELECT * FROM sales;

  Which process would retrieve the result from the database and return it to the client program?

  A. User process
  B. Server process
  C. System Monitor (SMON)
  D. Process Monitor (PMON)
  E. Checkpoint process (CKPT)
  B. Server process

• Question 178:

  Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)

  A. ENABLE
  B. ENABLE_PROGRAM
  C. VALIDATE_PROGRAM
  D. SET_ATTRIBUTE
  E. SET_ENABLED
  A. ENABLE
  D. SET_ATTRIBUTE

• Question 179:

  You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the database has crashed. What would be the appropriate order of operations to correct the situation?

  a.

  Mount the database with the startup mount command.

  b.

  Take the SYSTEM data file offline with the alter database command.

  c.

  Restore the SYSTEM_01.dbf data file from backup media with the required archived redo logs.

  d.

  Restore all SYSTEM tablespace–related datafiles from backup media.

  e.

  Issue the recover tablespace SYSTEM command.

  f.

  Issue the recover data file SYSTEM_01.dbf command.

  g.

  Open the database with the alter database open command.

  h.

  Open the database with the alter database open RESETLOGS command.

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

• Question 180:

  You issued the following command:

  CREATE GLOBAL TEMPORARY TABLE admin_work_area

  (startdate DATE, enddate DATE, class CHAR(20))

  ON COMMIT DELETE ROWS TABLESPACE tbs_t1;

  An index is then created on the ADMIN_WORK_AREA temporary table.

  Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

  A. It stores only the temporary table but not its indexes.
  B. It stores both the temporary table as well as its indexes.
  C. It must be a nondefault temporary tablespace for the database.
  D. It can be a default or nondefault temporary tablespace for the database.
  E. It must be the default temporary tablespace of the user who issues the command.
  B. It stores both the temporary table as well as its indexes.
  D. It can be a default or nondefault temporary tablespace for the database.