1z1-072 by Oracle Actual Free Exam Q&As

Question 1

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

A. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT. B. Only the CURRENT REDO log group is required to perform instance recovery. C. It is always performed when opening a database. D. No users can log on until instance recovery has completed. E. It is guaranteed to complete within fast_start_mttr_target number of seconds. F. The database opens after the roll forward phase of instance recovery has completed.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

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 contains initialization parameters whose values can be changed using the ALTER SYSTEM command. D. It must exist for a database instance to start. E. It can be edited by SYS when the database instance is shut down. F. It can be used to create a pfile.

Discussion 0

Correct Answer: C,D,F Vote an answer

Question 3

In your database, you want to create a tablespace of non-standard block size by using this command:
CREATE TABLESPACE ns_tbs
DATAFILE '/u01oracle/data/nstbs_f01.dbf' SIZE 100M
BLOCKSIZE 16K;
Which is a requirement for this command to succeed?

A. All other DB_nK_CACHE_SIZE parameters should be set to zero. B. The value of the DB_CACHE_SIZE parameter should not be 16 KB. C. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB. D. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA. E. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.

Discussion 0

Correct Answer: D Vote an answer

Question 4

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

A. Database instances in the cloud can be accessed only by using SSH. B. Oracle-supplied tools can be used with database instances in the cloud. C. DBCS only creates compute nodes; the Oracle Database software must be installed and the database created. D. Third-party tools can be used with database instances in the cloud. E. Database instances in the cloud can be accessed only by using Oracle*Net.

Discussion 0

Correct Answer: A,B Vote an answer

Question 5

Which two are prerequisites for shrinking a table online?

A. It must have a unique key constraint. B. It must have row movement enabled. C. It must not have any referential integrity constraints. D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) . E. It must not have any DML triggers.

Discussion 0

Correct Answer: A,C Vote an answer

Question 6

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 online redo logs are opened. B. The Oracle background processes are started. C. The control file is read. D. The initialization parameter file is read. E. The alert log records the execution details. F. The online data files are opened.

Discussion 0

Correct Answer: B,C Vote an answer

Question 7

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. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows. D. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP. E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.

Discussion 0

Correct Answer: E Vote an answer

Question 8

For which three purposes is UNDO used? (Choose three.)

A. RESTORE DATABASE operations B. ROLLBACK operations C. FLASHBACK TABLE <tablename> TO BEFORE DROP operations D. read consistency E. the roll forward phase of instance recovery F. flashback queries

Discussion 0

Correct Answer: B,D,F Vote an answer

Question 9

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

A. A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions. B. USER1 requires a quota to be able to store objects in the default permanent tablespace. C. The PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile. D. USER1 will be prompted for a new passport at first login. E. USER1's account is locked.

Discussion 0

Correct Answer: A,B Vote an answer

Oracle Database 12cR2 Administration - 1z1-072 Exam Practice Test