1Z0-072 Online Practice Questions and Answers

Which is true about the UNLIMITED TABLESPACE SYSTEM privilege?

A. It can be granted to any user and any role.

B. It is overridden by any specified user space quota.

C. It allows a user to have unlimited space in any tablespace in the database.

D. It allows a user to have unlimited space only in his or her default permanent tablespace.

E. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

orcl.dmp contains a full export of the ORCL database.

This command is executed to load data from orcl.dmp into the TESTDB database:

Which two are true? (Choose two.)

A. It skips only tables that exist in both ORCL:SH and TESTDB:HR.

B. It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.

C. It skips all indexes of ORCL:SH and ORCL:OE.

D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

Which two actions are performed? (Choose two.)

A. The control file is read.

B. The online data files are opened.

C. The online redo logs are opened.

D. The Oracle background processes are started.

E. The alert log records the execution details.

F. The initialization parameter file is read.

Examine these commands: What is the expected result?

A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.

B. Only the first row in EMP.DAT is inserted into U1.EMP.

C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.

D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.

E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

Which three statements are true about an spfile? (Choose three)

A. It contains only static initialization parameters.

B. It is the first file processed at instance startup.

C. It can be edited by SYS when the database instance is shut down.

D. It must exist for a database instance to start.

E. It can be used to create a pfile.

F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

Which is true about revoking roles?

A. Only users who are granted the DBA role can revoke a role.

B. Only users who are granted SYSDBA can revoke a role.

C. Users who have the GRANT ANY ROLE privilege can revoke any role.

D. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.

E. Users can revoke a role that is granted to them through other roles.

A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

A. in the SYSAUX tablespace

B. in the undo tablespace

C. in the redo logs

D. in rollback segments

E. in the temporary tablespace

Which is a machine image in Oracle Cloud?

A. the number of OCPUs and amount of memory allocated to an instance

B. the physical persistent block storage space allocated to an instance

C. the number of OCPUs, amount of memory, and persistent block storage space allocated to an instance

D. a template of a virtual hard disk of specific size without an operating system installed

E. a template of a virtual hard disk of specific size with an installed operating system

Which three are true about Oracle Database backup taken with RMAN?

A. A whole backup contains all data blocks of all data files.

B. RMAN cannot backup REDO logs.

C. A full backup contains all data blocks from one or more data files.

D. An RMAN image copy can be written only to disk.

E. Only offline backup are consistent.

F. RMAN always includes the control file in a backup.

Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?

A. It contains undo only for uncommitted transactions.

B. It is used for the FLASHBACK TABLE...TO BEFORE DROP operation.

C. It can be recovered while the instance is open in READ WRITE mode.

D. It must be a smallfile tablespace.

E. It is a locally managed tablespace.

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

A. partitioned tables

B. external tables

C. heap organized tables

D. clustered tables

E. index organized tables

F. temporary tables

Which two operations can be performed on external tables? (Choose two.)

A. creating invisible indexes

B. creating views

C. creating partitions

D. creating public synonyms

E. executing UPDATE statements

Which two functions are performed by a listener?

A. creating a user session in the System Global Area (SGA)

B. verifying the service name in an incoming user request

C. verifying a user's authentication credentials

D. maintaining the connection to a client's user process until the user request is completed

E. returning the results of processing from the server process to the user process

F. connecting a user process to a server process

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

A. It is guaranteed to complete within fast_start_mttr_target number of seconds.

B. Archived REDO log files are required to perform instance recovery.

C. The database opens after the roll forward phase of instance recovery.

D. It is performed when mounting a database.

E. Archived REDO log files are never required to perform instance recovery.

F. It occurs after a SHUTDOWN IMMEDIATE.

Which two are responsibilities of an Oracle DBA regarding database availability, backup, and recovery?

A. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode

B. implementing FLASHBACK DATA ARCHIVE to decrease MTBF

C. ensuring that critical components are protected by implementing redundancy

D. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode

E. implementing FLASHBACK DATA ARCHIVE to decrease MTTR