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

• Question 21:

  Which three are true about server processes for dedicated server connections? (Choose three.)

  A. They can write and read consistent block images to Oracle data files.

  B. They can parse and execute SQL statements.

  C. They can read data blocks from data files into the default buffer cache.

  D. They can generate archive log entries.

  E. They can generate redo log entries.

  F. They can write current block images contained in clean buffers to Oracle data files.

  Correct Answer: ABC

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT1248

• Question 22:

  Examine these parameter settings:

  

  You execute this:

  CREATE UNDO TABLESPACE UNDOTBS2 SEGMENT SPACE MANAGEMENT AUTO;

  Which is true?

  A. It fails because there is already an active UNDO TABLESPACE for the database instance.

  B. It executes successfully and space in the UNDOTBS2 tablespace will be bitmap managed.

  C. It fails because Automatic Segment Space Management (ASSM) is not supported for an UNDO TABLESPACE.

  D. It fails because size and data file clause are missing.

  E. It executes successfully and space in the UNDOTBS2 tablespace will be freelist managed.

  Correct Answer: B

  Reference: http://www.shannura.com/archives/2226261108_undo_01.html

• Question 23:

  Your databases all run in ARCHIVELOG mode.

  A newly created database has no RMAN backups.

  Examine these commands:

  CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

  RMAN> BACKUP TABLESPACE SYSTEM;

  ..

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

  ..

  RMAN> BACKUP TABLESPACE SYSTEM , SYSAUX;

  ..

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

  ..

  RMAN> BACKUP DATABASE;

  ..

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

  ..

  Which two are true about the execution of the third backup command? (Choose two.)

  A. The first backup of the SYSTEM tablespace is deleted.

  B. A backup is not performed for the SYSAUX tablespace.

  C. The first backup of the SYSTEM tablespace becomes obsolete.

  D. A backup is performed for the SYSAUX tablespace.

  E. A backup is not performed for the SYSTEM tablespace.

  F. The first backup of the SYSTEM tablespace becomes expired.

  Correct Answer: BF

• Question 24:

  Which two are true for databases running in ARCHIVELOG mode? (Choose two.)

  A. Archived redo log files can only be multiplexed to a maximum of ten local destinations.

  B. Inactive redo log groups must be archived before they can be reused.

  C. Archived redo log files can only be backed up when backing up the database.

  D. Archived redo log files get overwritten if the archived redo file destination is full.

  E. Archived redo log files can be multiplexed to a maximum of thirty destinations.

  Correct Answer: AB

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14231/archredo.htm

• Question 25:

  Examine this parameter setting:

  

  Now examine this command:

  ALTER TABLE hr.emp INMEMORY;

  Table altered.

  Which is true about effects of this command and any subsequent processing on hr.emp?

  A. Its data gets loaded into the IM Column Store in row format.

  B. Its data cannot be loaded into the default database buffer cache.

  C. Its data gets loaded into the IM Column Store in columnar format.

  D. The database instance uses the IM Column Store to process DMLs.

  Correct Answer: A

• Question 26:

  Which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnames.ora?

  A. the external naming method

  B. the easy connect method

  C. the local naming method

  D. the directory naming method

  Correct Answer: A

  Reference: https://docs.oracle.com/cd/F49540_01/DOC/network.815/a67440/ch6.htm

• Question 27:

  Which three are true about the Oracle Job Scheduler and its components? (Choose three.)

  A. A newly created job is disabled by default.

  B. A schedule can only be used in the definition of a single job.

  C. A job can run without being part of a window or schedule.

  D. A program can be invoked by multiple jobs.

  E. The CREATE ANY JOB privilege permits a user to create a job in any schema including SYS.

  F. A job can run only when a scheduler window is open.

  Correct Answer: ADE

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN12470

• Question 28:

  Which two can be recommendations given by SQL Access Advisor? (Choose two.)

  A. creation of SQL plan baselines

  B. creation of SQL profiles

  C. creation of materialized views

  D. creation of indexes

  E. rewriting of SQL statements

  Correct Answer: CD

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/advisor.htm#i1008370

• Question 29:

  Examine this command:

  

  Now examine these steps:

  1.

  Oracle instance is started.

  2.

  The control file is read.

  3.

  Instance recovery is started.

  4.

  Datafiles and redo log files are opened.

  5.

  The spfile or pfile is read.

  6.

  The database is available for use.

  7.

  The database is mounted.

  8.

  Instance recovery is completed.

  Identify the steps that were executed in the correct order to open the database:

  A. 5, 1, 3, 2, 7, 4, 6, 8

  B. 5, 2, 1, 7, 4, 3, 6, 8

  C. 5, 1, 2, 7, 4, 3, 8, 6

  D. 5, 1, 2, 7, 4, 6

  E. 5, 1, 2, 7, 4, 3, 6, 8

  F. 5, 2, 1, 4, 7, 6

  Correct Answer: D

• Question 30:

  Examine this parameter:

  

  Now examine this statement which executes successfully in an Oracle Database version 12c or later.

  CREATE TABLESPACE data_olap;

  Which two are true about this tablespace and its attributes? (Choose two.)

  A. The datafile that is created is not auto extensible.

  B. The tablespace is a dictionary managed tablespace.

  C. The datafile has an Oracle generated name.

  D. The tablespace is created with manual segment space management.

  E. The initial datafile size is 100MB.

  Correct Answer: BE

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/CREATETABLESPACE.html#GUID-51F07BF5-EFAF-4910-9040-C473B86A8BF9