Oracle Database 12c: Installation and Administration - 1z1-062 Exam Questions

A. A user's quota can be set for any permanent tablespace but not for the default temporary tablespace. B. Only users with the SYSDBA privilege can change the tablespace quota for other users. C. A user requires only the CREATE SESSION privilege to change his or her own password. D. A user's current session is not affected when the user's profile is changed. E. A new user account can be created only by SYS or SYSTEM users.

A. enabling row movement for the database B. opening the database in exclusive mode C. placing all tablespaces in read-only mode D. disabling Oracle Flashback Database if enabled

A. The impdp operation must be performed by the same user that performed the expdp operation. B. The export dump file must be created before starting the import on the target database. C. All the user-defined tablespaces must be in read-only mode on the source database. D. The source and target database must be running on the same operating system (OS) with the same endianness. E. The import operation must be performed by a user on the target database by a user with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user with the DATAPUMP_EXP_FULL_DATABASE role on the source database.

A. A resumable statement can be suspended and resumed only once during execution. B. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session. C. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block. D. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction. E. A suspended statement will report an error if no corrective action has taken place during a timeout period.

A. A different DEFAULT profile can be created before each user in a database. B. it must be explicitly assigned to the user. C. It can be dropped and recreated. D. The values assigned to the resource limits and password parameters in the default profile can be altered.

A. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS. B. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS. C. Run the Automatic Workload Repository Monitor (ADDM). D. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

A. No table definition is stored in the data dictionary. B. The table and column definitions are stored in the data dictionary. C. A database object is created. D. No database segment is created. E. No object definition is stored in the data dictionary. F. No column definitions are stored in the data dictionary.

A. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup. B. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup. C. Level 0 backup on Sunday contains all the blocks that have been formatted. D. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup. E. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.

A. Service registration with the listener is performed by the process monitor (PMON) process of each database instance. B. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections. C. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance. D. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly. E. A single listener can service only one database instance and multiple remote client connections.

A. RMAN backups that are obsolete B. Archived redo log files that have multiple copies in a different archive location C. user-managed backups of data files and control files D. flashback logs

A. when the RMAN recovery process starts B. when clean buffers for reading new blocks into the database buffer cache are not found easily C. when a user process commits a transaction D. when PMON cleans up dirty buffers in the database buffer cache E. when a tablespace is made read-only or taken offline

A. Each multithreaded Oracle process has an SCMN thread. B. The local listener may pass the request to an existing process which in turn will create a thread. C. Thread creation must be routed through a dispatcher process D. The local listener may spawn a now process and have that new process create a thread E. Each Oracle process runs an SCMN thread.