1Z0-062 Practice Questions

Which three statements are true about Oracle Data Pump export and import operations?

Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using infor...

Which three statements are true about Flashback Database?

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?

In which two scenarios do you use SQL* Loader to load data?

Which three factors influence the optimizer's choice of an execution plan?

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. Which two statements are true?

Which action takes place when a file checkpoint occurs?

Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled. You want to perform online segment...

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

Your database is open and the listener LISTNENER is up. You issue the command: LSNRCTL> RELOAD What is the effect of reload on sessions that were originally established by listener...

Which statement is true regarding the startup of a database instance?

Examine the memory-related parameters set in the SPFILE of an Oracle database: Which statement is true?

Which two statements are true about extents?

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You...

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN): RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Identify the statement that c...

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process,...

You executed the following query: Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BA...

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by u...

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?

You performed an incremental level 0 backup of a database: RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable block change tracking after the incremental level 0 backup, you iss...

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

Which three statements are true about windows? (Choose three.)

Which three statements are true about the Pre-Upgrade Information Tool?

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c

Which two tools can be used to configure static service information in the listener.ora file?

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and a Automatic Workload Repository (AWR) snapshot is taken every 30 minutes. Which two statements are true about...

Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system?

You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA). Which option should you use?

Which two statements are true about the Database Configuration Assistant (DBCA)?

Identify two prerequisites for configuring Enterprise Manger Database Express (EM Express).

Which three tools or tasks are run by default as part of automated maintenance tasks?

Which three statements are true about automated maintenance tasks?

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

You install Oracle Grid Infrastructure standalone server and issue the following command: crsctl start has Which two existing components get automatically added to the Oracle Resta...

Which three statements are true about Oracle Restart?

Which two statements are true about using SQL*Loader?

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?

You want the execution of a large database operation to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter RESUM...

In your database instance, the RESOURCE_LIMIT parameter is set to TRUE. You create the profile: CREATE PROFILE app_user LIMIT SESSIONS_PER_USER 5 CPU_PER_SESSION UNLIMITED CPU_PER_...

You want to reduce fragmentation and reclaim unused space of the SALES table but not its dependent objects. During the operation, you want to ensure the following:

The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction. Which type of lock would this scenario lead to?