Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 581:

  What is the purpose of the until change option of the restore command?

  A. It allows you to select the SCN that you want to restore to.
  B. It allows you to select the log sequence number you want to restore to.
  C. It allows you to select the timestamp you want to restore to.
  D. It allows you to manually stop the restore at any time as online redo logs are applied.
  E. None of the above.
  A. It allows you to select the SCN that you want to restore to.

• Question 582:

  If a log file becomes corrupted, it may cause the database to stale.

  How would you correct such a situation?

  A. Recover the online redo log from backup.
  B. Delete and re-create the log file.
  C. Use the ALTER DATABASE CLEAR LOGFILE command to clear the log file.
  D. Shut down the database and restart it.
  E. Shut down the database and then mount it. Clear the log file with the ALTER DATABASE CLEAR LOGFILE command and then restart the database with ALTER DATABASE OPEN RESETLOGS.
  C. Use the ALTER DATABASE CLEAR LOGFILE command to clear the log file.

• Question 583:

  View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance.

  What value would you assign?

  Exhibit:

  

  A. 1440 MB
  B. 90 MB
  C. 362 MB
  D. 272 MB
  C. 362 MB

• Question 584:

  You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.

  Which statement about the result is true?

  A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.
  B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.
  C. The database instance starts, but Automatic Memory Management is disabled.
  D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.
  B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.

• Question 585:

  Which statement is true regarding the VALIDATE DATABASE command?

  A. It checks the database for intrablock corruptions only.
  B. It checks for block corruption in the valid backups of the database.
  C. It checks the database for both intrablock and interblock corruptions.
  D. It checks for only those corrupted blocks that are associated with data files.
  A. It checks the database for intrablock corruptions only.

• Question 586:

  Evaluate the following block of code:

  

  What is the outcome of the above code?

  A. It produces an error because a fully qualified host name needs to be specified.
  B. It produces an error because the range of ports associated with the hosts has not been specified.
  C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
  D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
  C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.

• Question 587:

  Which of the following files cannot be backed up by RMAN? (Choose all that apply.)

  A. Database datafiles
  B. Control files
  C. Online redo logs
  D. Database pfiles
  E. Archived redo logs
  C. Online redo logs
  D. Database pfiles

• Question 588:

  View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:

  SQL> startup

  ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

  Why did the instance fail to start?

  Exhibit:

  

  A. Because the PGA_AGGREGATE_TARGET parameter is not set
  B. Because the STATISTICS_LEVEL parameter is set to BASIC
  C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
  D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
  B. Because the STATISTICS_LEVEL parameter is set to BASIC

• Question 589:

  Which type of backup must be performed first with an incremental backup?

  A. Level 1
  B. Level 0
  C. Level 2
  D. Level 3
  B. Level 0

• Question 590:

  Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)

  A. stored scripts in the recovery catalog
  B. backups that can be deleted from disk
  C. backup sets and image copies are obsolete
  D. backups that do not have the AVAILABLE status in the RMAN repository
  A. stored scripts in the recovery catalog
  D. backups that do not have the AVAILABLE status in the RMAN repository