Online Access Free 1z1-072 Practice Test

Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

• A.VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.
• B.VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.
• C.VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
• D.VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.
• E.VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.

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

• A.An RMAN image copy can be written only to disk.
• B.Only offline backup are consistent.
• C.RMAN cannot backup REDO logs.
• D.A whole backup contains all data blocks of all data files.
• E.RMAN always includes the control file in a backup.
• F.A full backup contains all data blocks from one or more data files.

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

• A.The database must have FLASHBACK enabled in order to perform it.
• B.Uncommitted transactions will be rolled back after it completes.
• C.It is possible only when the database is in MOUNT state
• D.Incremental backups can be used to roll forward the database while performing it.
• E.Only RMAN backupsets can be used to restore a database as part of it.

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.setting the SHARED_POOL_SIZE parameter to a non-zero value
• B.setting the LARGE_POOL_SIZE parameter to a non-zero value
• C.increasing the number of dispatchers
• D.using Automatic SGA Memory Management (ASMM)
• E.increasing the size of the PGA

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.The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.
• B.The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.
• C.The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.
• D.All other DB_nK_CACHE_SIZE parameters should be set to zero.
• E.The value of the DB_CACHE_SIZE parameter should not be 16 KB.