1Z0-072 Online Practice Questions and Answers

Which two tasks does DBUA perform by default? (Choose two.)

A. setting user tablespaces to "read only" before starting the upgrade

B. adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade

C. running the Pre-Upgrade information tool

D. starting the source database instance if not started

E. enabling flashback in the source database if not enabled

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.

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

A. All privileges and roles granted to a user are enabled by default when the user logs in.

B. The SET ROLE statement can be used once per session.

C. The SET ROLE statement enables as well as disables roles in a session.

D. A role must be disabled before it can be revoked from a user.

E. The ALTER USER statement must be used to set specific default roles for a user.

Which two tasks can you perform by using DBCA for a new database?

A. Register it with an available Enterprise Manager Management server.

B. Configure a nonstandard block size.

C. Configure incremental backups.

D. Enable flashback.

E. Create user tablespaces.

When is a SID_LIST_ section required in a LISTENER.ORA file?

A. when the listener uses multiple port numbers for different database instances

B. when a static listener is used

C. when a dynamic listener is used

D. when multiple dynamic listeners are used

E. when the list of existing database services must be defined

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. using Automatic SGA Memory Management (ASMM)

B. setting the LARGE_POOL_SIZE parameter to a non-zero value

C. increasing the size of the PGA

D. setting the SHARED_POOL_SIZE parameter to a non-zero value

E. increasing the number of dispatchers

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 two tasks can be performed in the NOMOUNT state? (Choose two.)

A. re-creating control files

B. full database recovery

C. enabling online redo log archiving

D. renaming data files

E. creating a database

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

A. SQL files

B. dump files

C. reject files

D. log files

E. input data files

F. bad files

G. control files

In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1. USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. TBS1 is exported from ORCL by using this command:

The TESTDB database has a TBS1 tablespace but no TBS2. The SYSTEM user in TESTDB executes this command:

What is the result and why?

A. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.

B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.

C. It fails because TESTDB has TBS1.

D. It imports only EMP.

E. It fails because TESTDB does not have TBS2 to create EMP_IDX.