Online Access Free 1Z0-072 Exam Questions

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

• A.It is offline by default.
• B.It uses the default blocksize used at database creation.
• C.It is read-only by default.
• D.It is a locally managed tablespace.
• E.DML operations performed on objects in this tablespace are not logged by default.
• F.The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.

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

• A.It contains only static initialization parameters.
• B.It can be used to create a pfile.
• C.It must exist for a database instance to start.
• D.It is the first file processed at instance startup.
• E.It can be edited by SYS when the database instance is shut down.
• F.It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

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

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

• A.Only incremental backups can be used to roll forward the database while performing complete recovery.
• B.Uncommitted transactions will be rolled back after complete recovery completes.
• C.The database must have FLASHBACK enabled in order to perform incomplete recovery.
• D.Uncommitted transactions will be rolled back after incomplete recovery completes.
• E.Incomplete recovery is possible only when the database is open.

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 undo tablespace
• B.in the SYSAUX tablespace
• C.in the redo logs
• D.in the temporary tablespace
• E.in rollback segments