Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 521:

  Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

  A. It's only supported for the backups performed on the tape
  B. It is not supported for backup operations that produce image copies
  C. Duplex backups need a parallelism for the device to be equal to number of copies
  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously
  B. It is not supported for backup operations that produce image copies
  D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

• Question 522:

  Your database initialization parameter file has the following entry:

  SEC_MAX_FAILED_LOGIN_ATTEMPTS=3

  Which statement is true regarding this setting?

  A. It drops the connection after the specified number of login attempts fail for any user.
  B. It is enforced only if the password profile is enabled for the user.
  C. It locks the user account after the specified number of attempts.
  D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
  A. It drops the connection after the specified number of login attempts fail for any user.

• Question 523:

  Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

  A. backup database
  B. backup database and archivelogs
  C. backup database plus archivelogs
  D. backup database plus archivelog delete input
  E. backup database and archivelog delete input
  D. backup database plus archivelog delete input

• Question 524:

  Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

  A. It can be used to back up all data on ASM disks.
  B. It can be used to recover the damaged ASM disk group along with the data.
  C. It can be used to gather information about a pre-existing ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
  D. It can be used to re-create the ASM disk group with its attributes.
  C. It can be used to gather information about a pre-existing ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
  D. It can be used to re-create the ASM disk group with its attributes.

• Question 525:

  You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?

  A. parallel image copy backup
  B. backup with MAXPIECESIZE configured for the channel
  C. parallel backup with MAXPIECESIZE configured for the channel
  D. intrafile parallel backup
  D. intrafile parallel backup

• Question 526:

  Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?

  a.

  restore controlfile

  b.

  restore database

  c.

  restore spfile

  d.

  recover database

  e.

  alter database open

  f.

  alter database open resetlogs

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

• Question 527:

  Upon starting your database, you receive the following error:

  SQL> startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.

  ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01.log' ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01a.log'

  You can choose from the following steps:

  a: Restore the database datafiles.

  b: Issue the alter database clear unarchived logfile group 1 command.

  c: Issue the alter database open command.

  d: Issue the alter database open resetlogs command.

  e: Recover the database using point-in-time recovery.

  f: Issue the Startup Mount command to mount the database.

  g:

  Back up the database.

  Which is the correct order of these steps in this case?

  A. a, f, e, d, g
  B. f, e, d
  C. f, b, c, g
  D. a, f, c
  E. The database cannot be recovered.
  C. f, b, c, g

• Question 528:

  Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

  A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
  B. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
  C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
  D. Health Monitor checks are always initiated manually when there is some critical error.
  A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
  B. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.

• Question 529:

  The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You d the following command to startup the Automatic Storage Management (ASM) instance.

  SQL> STARTUP;

  Which two activities are performed during a successful start up operation? (Choose two.)

  A. The databases configured to use the ASM instance are mounted
  B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
  C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
  D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
  B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
  C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

• Question 530:

  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.