1Z0-072 Exam Questions

The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE. UNDOTBS2 is the active undo tablespace. Examine these commands: SQL> SELECT tablespace_name, status, retention FROM dba...

Which three failures require intervention for recovery? (Choose three.)

Which three are true about Oracle Managed Files (OMF)? (Choose three.)

Your client application and Oracle database are located on different hosts. Which statement is true about establishing a connection between them?

In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. USER1 has EMP_table with primary key EMP_ENO. PK resides in TBS1. USER1's EMP_IDX residing in ORCL is an index on...

In your database, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO HR WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)

TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF). Examine this command: DROP TABLESPACE TBS1; Which is required to ensure that TBS1 is dropped an...

Which three types of files are created by expdp operations? (Choose three.)

DATADIR1 and DATADIR2 are database directory objects. Examine this command: [oracle@host01 ~]$ expdp system/oracle \ > FULL=y \ > DUMPFILE=datadir1:full%U.dmp, datadir2:full2%U.dmp...

Which statement is true about smallfile tablespaces?

Which two are true about RETENTION GUARANTEE? (Choose two.)

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

What three are true about Oracle Flashback technology? (Choose three.)

Which two can you use to recover a dropped table? (Choose two.)

oracle@host[~] impdp system/oracle \ > SCHEMAS=ee \ > REMAP_SCHEMA=sh:hr \ > DUMPFILE=orcl.dmp \ > EXCLUDE=index \ > TABLE_EXISTS_ACTION=replace \ > SQLFILE=impdp.log Which two are...

Which is true about roles?

Which is true about security rules on a compute node?

In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE. Examine this command: SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, C2 CLOB); Which table segments are created?

Which is a machine image in Oracle Cloud?

The DATA tablespace uses Automatic Segment Space Management. Examine this query and its output: SQL> SELECT tablespace_name, pct_free FROM user_tables WHERE table_name='EMP'; TABLE...

Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value. Which three actions could help in handling a large number of concurrent users...

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete. You want to verify this. Which two views may reveal for w...

What two are benefits of Data Pump? (Choose two.)

Which two are true about complete recovery? (Choose two.)

Which two functions are performed by a listener?

Which three failures do not require intervention for recovery? (Choose three.)

Which two statements are true about the tablespace SEGMENT SPACE MANAGEMENT clause? (Choose two.)

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

Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.)

Which three object types support deferred segment creation? (Choose three.)

In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA. Examine these parameters. NAME TYPE VALUE -------------------- -------- ------- TEMP...

Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)

Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter. Examine these steps. 1. Shut down the database instance. 2....

Which two types of files are opened by a database instance in the NOMOUNT state?

Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)

Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

Examine the command: CREATE USER user1 IDENTIFIED BY user123 DEFAULT TEMPORARY TABLESPACE temp QUOTA 2M ON system PROFILE dflt_user PASSWORD EXPIRE; Which two are true? (Choose two...

Which two are true about the roles? (Choose two.)

Which three are true about the Oracle Optimizer? (Choose three.)

Which two are true about conventional path SQL load? (Choose two.)

Which two are true about Oracle recovery and data protection solutions? (Choose two.)

Which two are true about complete and incomplete recovery? (Choose two.)

Which two are true about the expdp operation? (Choose two.)

Examine this command: CREATE TEMPORARY TABLESPACE temp_tbs TEMPFILE 'temp01.dbf' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED SEGMENT MANAGEMENT AUTO; Which two changes must yo...

ORCL.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: {oracle@host} > impdp system/oracle \ > SCHEMAS=...

In the ORCL database, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO HR WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)

oracle.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle \ > SCHE...