Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 241:

  You want to schedule a job to rebuild a table's indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system.

  What would you do to accomplish this?

  A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table.

  B. Create a file watcher for the bulk inserts and then create a job to rebuild indexes.

  C. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array.

  D. Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes.

  Correct Answer: A

• Question 242:

  You execute this command:

  

  Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

  A. Space utilization inside segments is mapped by bitmaps.

  B. Segments are automatically shrunk and compressed when rows are deleted.

  C. The PCTFREE storage parameter has no effect on segments created in this tablespace.

  D. The PCTUSED storage parameter has no effect on segments created in this tablespace.

  Correct Answer: AD

• Question 243:

  Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)

  A. It records checkpoint information in the control file.

  B. It frees unused temporary segments.

  C. It kills sessions that exceed idle time.

  D. It registers database services with all local and remote listeners known to the database instance.

  E. It frees resources held by abnormally terminated processes.

  Correct Answer: DE

  References: https://docs.oracle.com/database/122/CNCPT/process-architecture.htm#CNCPT9840

• Question 244:

  Which two statements are true about standard database auditing? (Choose two.)

  A. DDL statements can be audited.

  B. Statements that refer to standalone procedure can be audited.

  C. Operations by the users logged on as SYSDBA cannot be audited.

  D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

  Correct Answer: AB

• Question 245:

  You executed the following command to create a password file in the database server:

  $ orapwd file = orapworcl entries = 5 ignorecase=N

  Which statement describes the purpose of the above password file?

  A. It records usernames and passwords of users when granted the DBA role

  B. It contains usernames and passwords of users for whom auditing is enabled

  C. It is used by Oracle to authenticate users for remote database administrator

  D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

  Correct Answer: A

• Question 246:

  Which three statements are true about space usage alerts? (Choose three.)

  A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.

  B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

  C. Database alerts can provide warnings about low space availability at both tablespace and segment levels.

  D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.

  E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.

  Correct Answer: ADE

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

• Question 247:

  Which three statements are true about Oracle Data Pump? (Choose three.)

  A. IMPDP can be used to change target data file names, schemas, and tablespaces during import.

  B. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.

  C. EXPDP and IMPDP are the client components of Oracle Data Pump.

  D. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  E. IMPDP always use the conventional path insert method to import data.

  Correct Answer: ABC

  References: https://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL2880

• Question 248:

  Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

  A. The ADDM requires at least four AWR snapshots for analysis

  B. The ADDM runs after each AWR snapshot is collected automatically by MMON

  C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

  D. The ADDM analysis provides only diagnostics information but does not provide recommendations

  E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

  Correct Answer: BC

• Question 249:

  In your production database, data manipulation language (DML) operations are executed on the SALES

  table.

  You have noticed some dubious values in the SALES table during the last few days. You are able to track

  users, actions taken, and the time of the action for this particular period but the changes in data are not

  tracked. You decide to keep track of both the old data and new data in the table long with the user

  information.

  What action would you take to achieve this task?

  A. Apply fine-grained auditing.

  B. Implement value-based auditing.

  C. Impose standard database auditing to audit object privileges.

  D. Impose standard database auditing to audit SQL statements.

  Correct Answer: B

• Question 250:

  The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a

  session and executes commands as follows:

  SQL> INSERT INTO cust VALUES(101, 'JACK');

  1 row created.

  SQL> INSERT INTO cust VALUES(102, 'SMITH');

  1 row created.

  As a DBA, you execute the following command from another session:

  ALTER TABLESPACE sales READ ONLY;

  Which statement is true regarding the effect of this command on the transaction in Scott's session?

  A. The command fails as a transaction is still pending.

  B. The transaction in Scott's session is rolled back and the tablespace becomes readonly.

  C. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.

  D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

  Correct Answer: B