Oracle 1Z0-034 Online Practice Questions and Exam Preparation

Oracle 1Z0-034 Online Questions & Answers

• Question 61:

  Examine the following scenario:

  Database is running in ARCHIVELOG mode.

  

  Complete consistent backup is taken every Sunday.

  

  On Tuesday the instance terminates abnormally because the disk on which control files are located

  

  gets corrupted The disk having active online redo log files is also corrupted. The hardware is repaired and the paths

  

  for online redo log files and control files are still valid.

  Which option would you use to perform the recovery of database till the point of failure?

  

  A. Restore the latest whole backup, perform complete recovery, and open the database normally
  B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGSoption.
  C. Restore the latest backups control file, perform complete recovery, and open the database with theRESETLOGS option.
  D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option.
  D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open thedatabase with the RESETLOG option.

• Question 62:

  In one of your online transaction processing (OLTP) applications, table keys are frequently updated and queries performed using many different operators. In addition, reports are generated using complex joins with non-equality operators. What table organization is the best for this workload?

  A. heap table
  B. object table
  C. external table
  D. sorted hash clustered table
  E. global temporary table
  F. hash clustered table
  B. object table

• Question 63:

  What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

  A. The number of DBWR processes increases
  B. The number of ASMB processes increases
  C. The number of DBWR_TO_SLAVES increases
  D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/ Ooverhead
  D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/ Ooverhead

• Question 64:

  Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?

  

  A. Implement RMAN multiplexing
  B. Set the DEBUG ON in the RMAN script
  C. Specify the command ID in the RMAN script
  D. Use a tag with the RMAN BACKUP command
  C. Specify the command ID in the RMAN script

• Question 65:

  Your database is open and running in ARCHIVELOG mode.

  You take RMAN full backups every Sunday night.

  On Monday morning, while querying the user1.emoloyees table, you receive the following error message:

  01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5:

  '/u01/app/oracle/oradata/orcl/exanple0l.dbf*

  You need to recover from this while ensuring that:

  1.

  The data file remains online.

  2.

  Mean Time To Recover (MTTR) is minimized as much as possible You have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements?

  A. flash back the corrupted blocks
  B. use the DBMS_REPAIR package
  C. use RMAN tablespace point in time recovery
  D. use the RMAN BLCCKRECOVER command
  E. perform a table point in time recovery with datapump export and import
  D. use the RMAN BLCCKRECOVER command

• Question 66:

  Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.

  S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table

  $ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat Remap_schema =hr:hr1,oe :oe1

  What would be achieved by running the above commands?

  A. expdp will fail because no path has been defined for the dumpfile.
  B. expdp will succeed but Impdp will fail because users do not exist.
  C. impdp will create two users called hrl and oe1 and import all objects to the new schemas
  D. impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively.
  B. expdp will succeed but Impdp will fail because users do not exist.

• Question 67:

  Note the output of the following query:

  SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS

  -------------------------------------------------------------- FLA1

  You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:

  ALTERTABLEexchange_rateFLASHBACK ARCHIVE;

  What is the outcome of this command?

  A. The table uses the default Flashback Data Archive.
  B. The Flashback Data Archive is created in the SYSAUX tablespace.
  C. The Flashback Data Archive is created in the same tablespace where the tables are stored.
  D. The command generates an error because no Flashback Data Archive name is specified and there is no default Flashback Data Archive.
  A. The table uses the default Flashback Data Archive.

• Question 68:

  You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)

  A. It is a smallfile tablespace.
  B. It is a bigfile tablespace (BFT).
  C. It is a default bigfile tablespace.
  D. It is a locally managed tablespace.
  E. It is a dictionary-managed tablespace.
  A. It is a smallfile tablespace.
  D. It is a locally managed tablespace.

• Question 69:

  View the Exhibits exhibit1 and exhibit2.

  Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than

  the process in exhibit2.

  What is the reason for this?

  lightweight-job-1 (exhibit):

  

  lightweight-job-2 (exhibit):

  

  A. It updates several tables in the SYSTEM tablespace instead of creating new tables.
  B. It creates jobs temporarily in memory only.
  C. It creates less metadata for the jobs.
  D. It writes the job metadata to disk in compressed format.
  C. It creates less metadata for the jobs.

• Question 70:

  User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?

  A. ALTER DATABASE FLASHBACK ON;
  B. GRANT SELECT ANY TRANSACTION TO scott;
  C. GRANT EXECUTE ON dbms_flashback TO scott;
  D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
  E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
  F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
  B. GRANT SELECT ANY TRANSACTION TO scott;
  C. GRANT EXECUTE ON dbms_flashback TO scott;
  D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
  F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;