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

• Question 31:

  Which two are true about database table rows? (Choose two.)

  A. They always have a row header.

  B. They are always stored in a single database block.

  C. They are chained across multiple blocks only when the table has more than 255 columns.

  D. They have a row header only when they are chained across multiple database blocks.

  E. They can be stored in a single database block.

  Correct Answer: CE

  Reference https://blogs.sap.com/2013/02/17/oracle-unchain-database-and-sql-performance-by-designrow-chaining/

• Question 32:

  Which four are true about the SHUTDOWN TRANSACTIONAL command and its effects in a single instance Oracle database environment with a single active transaction? (Choose four.)

  A. The Oracle server waits for all sessions to disconnect before completing the shutdown.

  B. An instance shutdown will occur if the transaction issues a COMMIT.

  C. Sessions are unable to begin new transactions.

  D. All sessions are terminated when the transaction ends.

  E. An instance shutdown will occur if the transaction issues a ROLLBACK.

  F. All the active transactions are rolled back and all user sessions are terminated.

  G. The next startup requires instance recovery, which occurs automatically.

  Correct Answer: CEFG

  Reference: https://www.oracletutorial.com/oracle-administration/oracle-shutdown/

• Question 33:

  Which two are true about the SMON background process? (Choose two.)

  A. It performs instance recovery, if required, at instance startup.

  B. It monitors sessions for idle time out.

  C. It performs process recovery for user process failures.

  D. It deletes orphaned temporary segments in permanent tablespaces.

  E. It monitors the status of dispatchers and server processes.

  Correct Answer: BE

• Question 34:

  Examine these statements:

  

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

  A. The HR account will get locked by Oracle after ten consecutive failed login attempts.

  B. User HR is permitted to create more than three concurrent sessions.

  C. Password complexity checking is enforced for user HR.

  D. User HR sessions will terminate after ten minutes of continuous inactivity.

  E. The HR account will be locked after three consecutive failed login attempts.

  F. The password complexity will not enforce on the HR account.

  Correct Answer: BEF

• Question 35:

  Which three are true about the default database buffer cache? (Choose three.)

  A. Buffers containing block images may be selected for reuse based only on a Least Recently Used (LRU) algorithm.

  B. It is in the fixed area of the SGA.

  C. Its buffers can contain data block images for blocks that have a corresponding image in a data file.

  D. Buffers containing block images may be selected for reuse based only on a touch count algorithm.

  E. It can contain block images only for database blocks whose block size is equal to the buffer size.

  F. The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.

  G. Its buffers can contain data block images for blocks that have no corresponding image in a data file.

  Correct Answer: BFG

• Question 36:

  One of your databases runs in ARCHIVELOG mode. Examine this command:

  

  Now examine these steps executed from RMAN:

  1) SHUTDOWN IMMEDIATE 2) STARTUP MOUNT 3) BACKUP DATABASE; 4) BACKUP ARCHIVELOG ALL; 5) ALTER DATABASE OPEN; 6) STARTUP

  Identify the minimum required steps in the correct order needed to perform a whole consistent database backup.

  A. 1, 2, 3, 5

  B. 1, 6, 3, 4

  C. 1, 6, 3

  D. 1, 2, 3, 4, 5

  E. 3, 4

  Correct Answer: A

  Reference: https://community.oracle.com/thread/451341

• Question 37:

  Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)

  A. the private SQL area

  B. the Automatic Workload Repository (AWR)

  C. the Automatic Database Diagnostic Monitor (ADDM)

  D. the shared SQL area

  E. the SQL Access Advisor

  F. the AWR Compare Periods Report

  Correct Answer: BCE

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/sql_tune.htm#i34782

• Question 38:

  Examine these steps:

  CONNECT / AS SYSDBA

  CREATE DIRECTORY dumpdir AS '/u01/app/';

  Directory created.

  GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC;

  Grant succeeded.

  CREATE USER TEST IDENTIFIED BY test;

  User created.

  GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE TO test;

  Grant succeeded.

  CONN test/test

  Connected.

  CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7)); Table

  created.

  SQL> CREATE SYNONYM emp FOR test_employees;

  Synonym created.

  Now examine this command:

  $ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp

  CONTENT=data_only query='EMP:"WHERE salary=12000"' What is true about the execution of this command?

  A. It throws an error as the QUERY parameter is not supported on an empty table.

  B. It throws an error as the table test_employees is empty and CONTENT=data_only is specified.

  C. It performs the export successfully.

  D. It throws an error as Data Pump cannot find a table called TEST.EMP.

  Correct Answer: C

• Question 39:

  The HR schema exists in databases, BOSTON and DENVER, with the same password, HR.

  You have CREATE DATABASE LINK and CREATE SESSION privileges in both databases.

  DENVER is defined as a service name in the tnsnames.ora of both databases.

  You plan to use this command:

  CREATE DATABASE LNK hr_link CONNECT TO hr IDENTIFIED BY hr USING `DENVER';

  What must be done to ensure that all users in BOSTON can access the HR schema in DENVER?

  A. Change the command to create a public database link in BOSTON.

  B. Change the command to create a public database link in DENVER.

  C. Execute the command as SYS in DENVER.

  D. Execute the command as SYS in BOSTON.

  E. Execute the command as HR in BOSTON and SYS in DENVER.

  F. Execute the command as SYS in both databases.

  Correct Answer: E

• Question 40:

  Examine these statements: DESC emp

  

  INSERT INTO emp VALUES ( 101, 'John', 12000);

  1 row created.

  SAVEPOINT after_insert;

  Savepoint created.

  UPDATE emp SET salary=16000 WHERE empno=101;

  1 row updated.

  SAVEPOINT after_update;

  Savepoint created.

  DELETE FROM emp WHERE empno=101;

  1 row deleted.

  SAVEPOINT after_delete;

  Savepoint created.

  ROLLBACK TO SAVEPOINT after_update;

  Rollback complete.

  INSERT INTO emp VALUES ( 102, 'Emma', 12000);

  ROLLBACK TO SAVEPOINT after_delete;

  Which is the result and effect of this ROLLBACK?

  A. The ROLLBACK backs out all DMLS before after_delete.

  B. The ROLLBACK backs out all DMLS until after_delete.

  C. The ROLLBACK throws an error.

  D. The ROLLBACK executes successfully but does not back out any DMLS.

  Correct Answer: B