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

• Question 41:

  All of your database instances use SPFILES.

  You executed this command in one of them:

  ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M;

  Which statement is true?

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

  B. The command returns an error.

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

  D. The parameter is modified in memory only.

  Correct Answer: C

  Reference: https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN00207

• Question 42:

  Which two utilities can NOT configure a new listener on port 1526? (Choose two.)

  A. dbca

  B. asmca

  C. netca

  D. netmgr

  E. lsnrctl

  Correct Answer: CE

  Reference: https://community.oracle.com/thread/3781791?start=15andtstart=0

• Question 43:

  In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)

  A. when free space in a locally managed tablespace falls below a specified percentage

  B. when the number of logons per second exceeds a specific value

  C. when a resumable statement is suspended

  D. when the total number of locked user account exceeds a specific value

  E. when the total number of logons exceeds a specific value

  F. when free space in a dictionary managed tablespace falls below a specified percentage

  Correct Answer: ABC

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm https:// docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm

• Question 44:

  Which three statements are true about a job chain? (Choose three.)

  A. The DBA role is required to create a job chain.

  B. It can be used to implement dependency-based scheduling.

  C. It cannot invoke the same program or nested chain in multiple steps in the chain.

  D. It cannot have more than one dependency.

  E. It can be executed using event-based schedules.

  F. It can be executed using time-based schedules.

  Correct Answer: BEF

• Question 45:

  An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is

  uncommitted.

  Which two types of lock are held by the transaction? (Choose two.)

  A. a row level lock on the row being updated

  B. a null lock on the row being updated

  C. a row shared lock on the EMPLOYEES table

  D. an exclusive lock on the EMPLOYEES table

  E. a null lock on the EMPLOYEES table

  Correct Answer: AC

• Question 46:

  DEFERRED_SEGMENT_CREATION is TRUE in one of your databases. You execute this command:

  

  Which three statements are true immediately after this statement executes successfully?

  A. A database object is created.

  B. No database segment is created.

  C. The table and column definitions are stored in the data dictionary.

  D. No table definition is stored in the data dictionary.

  E. No column definitions are stored in the data dictionary.

  F. No object definition is stored in the data dictionary.

  Correct Answer: ABC

• Question 47:

  A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300

  to 400 and make it persistent for your database instance.

  You plan to use the ALTER SYSTEM command.

  Which two methods can be used? (Choose two.)

  A. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.

  B. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.

  C. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.

  D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

  E. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.

  F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

  Correct Answer: CF

• Question 48:

  In one of your databases, unified auditing is enabled and an SH.SALES table exists. You can successfully execute these commands:

  

  Which statement is true about SALES_POL?

  A. Audit records are always stored in an external audit file.

  B. It is enabled for all users having SELECT privilege on SH.SALES.

  C. It is only enabled for SH.

  D. Only successful queries of SH.SALES are written to the audit trail.

  Correct Answer: D

• Question 49:

  What should you do for a Scheduler to start a job when a file arrives on a remote system?

  A. Start an Oracle database instance on the remote system and register the Scheduler agent with this database.

  B. Install the Scheduler agent on the remote system and register the agent with the database on the local system.

  C. Ensure dedicated server is enabled on both the local and remote databases.

  D. Shutdown the file watcher on the local system.

  Correct Answer: A

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

• Question 50:

  Your database is in ARCHIVELOG mode.

  You want to disable archiving for the database.

  Examine these steps:

  1.

  Execute the ALTER DATABASE NOARCHIVELOG command

  2.

  Execute SHUTDOWN IMMEDIATE

  3.

  Execute STARTUP MOUNT

  4.

  Set the DB_RECOVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/

  5.

  Execute STARTUP NOMOUNT

  6.

  Open the database

  7.

  Execute SHUTDOWN TRANSACTIONAL

  Identify the required steps in the correct sequence.

  A. 1, 2, 3, 4, 6

  B. 2, 5, 1, 6

  C. 4, 2, 5, 1, 6

  D. 2, 3, 1, 6

  Correct Answer: B

  Reference: http://dba-oracle.com/bk_disable_archive_log_mode.htm