Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 61:

  Which three statements are true about Oracle checkpoint processing? (Choose three.)

  A. Frequent thread checkpoints can degrade database performance

  B. Database Writer (DBWn) processes write checkpoint information to datafile headers and the control file

  C. It reduces the recovery time from instance failures

  D. Incremental checkpoints write some dirty buffers to the datafiles and unwritten redo to the online redo logs.

  E. Thread checkpoints ensure that all dirty buffers are written to data files during a normal shutdown

  Correct Answer: BCE

• Question 62:

  You want a job that performs a bulk insert as soon as the loader file arrives on the local file system. Which two would you do to accomplish this? (Choose two.)

  A. Create a file watcher

  B. Create a bulk loader watcher

  C. Create a light weight job for bulk insert

  D. Create an event-based job for bulk insert

  E. Create a job chain with a step for bulk insert

  Correct Answer: AD

• Question 63:

  Which four are true about creating and running a remote database scheduler jobs? (Choose four.)

  A. A database destination must exist or be created for the remote database

  B. It must run as a user that is defined on the remote database

  C. Remote database jobs always run as the same user who submits the job on the local database

  D. A credential is optional for a remote database job

  E. A credential must be created to define the remote user

  F. A database destination group must exist or be created for a job to run on multiple remote databases

  G. A destination is optional for a remote database job because DB links can be used instead

  Correct Answer: ABDF

• Question 64:

  Your database is configured in ARCHIVELOG mode.

  Examine the RMAN configuration parameters:

  

  Examine the command:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  Which two are true? (Choose two.)

  A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command

  B. It creates image copies of the archivelogs

  C. It creates a backupset of archive log files

  D. It creates image copies of the database files

  E. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command

  Correct Answer: BE

• Question 65:

  Which two tools can be used to configure static service information in the listener.ora file? (Choose two.)

  A. Oracle Net Manager

  B. Oracle Enterprise Manager Cloud Control

  C. Oracle Net Configuration Assistant

  D. Listener Control Utility (LSNRCTL)

  E. Oracle Enterprise Manager Database Express

  Correct Answer: AB

• Question 66:

  Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system? (Choose three.)

  A. online redo log files

  B. parameter file

  C. multiplexed copies of the current control file

  D. archived log files

  E. Flashback Data Archive files

  F. Flashback logs

  Correct Answer: ADF

• Question 67:

  You install Oracle Grid Infrastructure standalone server and issue the following command:

  crsctl start has

  Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.)

  A. Oracle CSSD services

  B. the database whose instance is running

  C. Oracle Notification services

  D. Oracle Healthcheck services

  E. Oracle Net Listener

  Correct Answer: AC

• Question 68:

  Examine this command executed on a client that is remote from the database server.

  SQL> CONNECT hr/hr@orcl

  Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)

  A. An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files

  B. An orcl TNS entry must be defined in the client-side tnsnames.ora file

  C. A service name must be defined to the listener that matches the service name in the orcl TNS entry

  D. An orcl TNS entry must be defined in the server-side tnsnames.ora file

  E. The service name orcl must be defined to the listener

  Correct Answer: DE

• Question 69:

  One of your databases supports an OLTP workload. The default UNDO tablespace is fixed size with:

  1.

  RETENTION NOGUARANTEE

  2.

  UNDO_RETENTION is 12 minutes

  User SCOTT gets this error after a query on the SALES table has run for more than 15 minutes:

  ORA-01555: snapshot too old

  Which three factors taken separately or in some combination might be the cause? (Choose three.)

  A. An update was made to the SALES table after the query began

  B. An update to the SALES table was committed after the query began

  C. A committed delete to the SALES table was made more than 12 minutes before the query began

  D. An uncommitted update to the SALES table was made more than 12 minutes before the query began

  E. A committed update to the SALES table was made more than 12 minutes before the query began

  F. An uncommitted delete to the SALES table was made more than 12 minutes before the query began

  G. An update was made to the SALES table before the query began

  Correct Answer: ADE

• Question 70:

  You executed the following query:

  

  Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

  A. The time when the last flashback operation in your database was performed

  B. The time when the first flashback operation in our database was performed

  C. The approximate time and the lowest system change number (SCN) to which you can flash back your database

  D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

  Correct Answer: C