Oracle Oracle Database Application Development 1Z0-062 Questions & Answers

• Question 11:

  Examine this command.

  

  Now examine these statements: Which three are true about the result of processing the last statement? (Choose three.)

  

  A. The parameter is modified in memory and in the parameter file.

  B. The modification persists across instance checkpoint.

  C. The parameter is modified in the parameter file only.

  D. The parameter is modified in memory only.

  E. The modification persists across a SHUTDOWN IMMEDIATE command.

  F. The modification does not persist across a SHUTDOWN TRANSACTIONAL command.

  Correct Answer: BEF

• Question 12:

  Which two statements are true about the Database Configuration Assistant (DBCA) in Oracle Database 12c? (Choose two.)

  A. It can upgrade an Oracle Database from an Older release to 12c.

  B. It can unplug a PDB from a CDB.

  C. It can plug in a PDB into a CDB.

  D. It never creates an Oracle 12c database including the sample schemas.

  E. It can migrate an Oracle 12c database to a different platform.

  F. It can create a Pluggable Database (PDB) in a Container Database (CDB).

  Correct Answer: BF

  Reference: https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD003

• Question 13:

  Examine these configuration details:

  1.

  A Fast Recovery Area (FRA) has been specified for a database.

  2.

  The database instance is in ARCHIVELOG mode

  3.

  The default location for archived redo log files is the FRA.

  Which two types of files are removed automatically due to space pressure in the FRA? (Choose two.)

  A. flashback logs

  B. obsolete RMAN database backup sets

  C. obsolete spfiles

  D. expired RMAN image copies

  E. expired RMAN database backup sets

  F. Mirrored copies of online logs

  Correct Answer: AB

  Reference: http://satya-dba.blogspot.com/2009/02/flash-recovery-area.html

• Question 14:

  SALES is a valid TNS entry referring to: Hostname: HOST01

  Port: 1521 Service_name: SALES_SRV You issue this command: $ tnsping SALES Which two are true? (Choose two.)

  A. It validates that there is a listener on HOST01 port 1521.

  B. It validates that SALES is a valid TNSNAMES entry reachable by the configured name resolution method.

  C. It validates that SALES_SRV service is active in any database instance on HOST01.

  D. It validates that a SALES_SRV database on HOST01 is open.

  E. It validates that SALES_SRV service is active in a specific database instance on HOST01.

  Correct Answer: AD

• Question 15:

  Examine this parameter setting: Now examine these statements:

  

  

  Which three are true about the processing of these statements? (Choose three.)

  A. LGWR will only write redo generated by the INSERT statement to the redo log during execution of the COMMIT statement.

  B. Undo generated for the transaction will be in an unexpired state immediately after the commit.

  C. Only the 900 most recently generated undo statements will be in an unexpired state after the commit.

  D. DBWR might write the content of the modified EMP table block image to a data file before the COMMIT is executed.

  E. Only the 900 most recently generated undo statements are guaranteed to be retained.

  F. LGWR might write redo generated by the INSERT statement to the redo log before the COMMIT is executed.

  G. DBWR must write the content of the modified EMP table block image to a data file before the COMMIT executed.

  Correct Answer: DEG

• Question 16:

  Examine these parameter settings:

  

  Now examine this statement:

  ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;

  Tablespace altered.

  Which two are true about undo retention in this configuration? (Choose two.)

  A. Unexpired undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.

  B. Active undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.

  C. Undo data is written to flashback logs after 900 seconds.

  D. Expired undo is retained for at least 900 seconds before being deleted to free up space even if other transactions fail due to lack of space in the UNDO TABLESPACE.

  E. Undo data expires after 900 minutes.

  F. Unexpired undo is retained for 900 seconds, only if free undo space is available.

  Correct Answer: DF

• Question 17:

  Examine these statements: Which two are true about the result and effects of executing these commands? (Choose two.)

  

  A. User Alice is permitted to grant the CREATE USER privilege to user HR.

  B. The REVOKE statement successfully revokes the system privilege from Alice.

  C. User Alice is permitted to grant the CREATE USER privilege to user HR only.

  D. User Alice is not permitted to revoke the CREATE USER from user John.

  E. User HR is permitted to grant the CREATE USER privilege to any other user.

  F. The REVOKE statement successfully revokes the system privilege from user HR.

  Correct Answer: AE

• Question 18:

  All of your live databases run in ARCHIVELOG mode.

  On the SALES database there is no LEVEL 0 backup.

  Examine these commands issued against the SALES database target:

  RMAN> BACKUP AS BACKUPSET DATABASE;

  ..

  backup set complete, elapsed time: 00:00:03

  RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

  What is true about the execution of these commands?

  A. A Level 0 backup of the database is created instead of the Level 1.

  B. A backup is created which only contains blocks that have changed since BACKUP AS BACKUPSET command.

  C. It throws an error because incremental level 1 backups require image copy backups as the Level 0 backup.

  D. It throws an error because a Level 0 backup does not exist.

  Correct Answer: B

• Question 19:

  Examine these statements:

  

  Which two are true about the result and effects of executing these commands? (Choose two.)

  A. CREATE SESSION is only revoked from role DEV1.

  B. CREATE SESSION is only revoked from user JOHN.

  C. User JOHN is not permitted to connect to the database.

  D. User JOHN is permitted to connect to the database.

  E. CREATE SESSION is revoked from both the role DEV1 and JOHN.

  Correct Answer: AD

• Question 20:

  Examine these commands:

  

  Now examine these steps:

  1) STARTUP NOMOUNT 2) STARTUP MOUNT 3) STARTUP FORCE 4) ALTER DATABASE ARCHIVELOG; 5) SHUTDOWN TRANSACTIONAL 6) ALTER DATABASE OPEN; 7) SHUTDOWN ABORT 8) ALTER DATABASE MOUNT

  Identify the required steps in the correct order to change the database to run in ARCHIVELOG mode.

  A. 5, 2, 4, 6

  B. 5, 1, 4, 8, 6

  C. 5, 1, 4, 6

  D. 7, 1, 4, 8, 6

  E. 5, 3, 4, 6

  F. 5, 2, 6, 4

  Correct Answer: D

  Reference: https://support.arcserve.com/s/article/202782255?language=en_US