QUESTION 131:
In which two scenarios does a checkpoint occur? (Choose two.)
A.when a log switch occurs
B.when a segment is dropped
C.when a tablespace is dropped
D.when a tablespace is taken offline in NORMAL mode
Tag: 1Z0-031 study materials
QUESTION 91:
In your database, the MAX_DUMP_FILE_SIZE initialization parameter is set as follows:
MAX_DUMP_FILE_SIZE=1000
What would be the effect of this command?
A.The size of the alert log file cannot exceed 1,000 MB.
B.The size of the alert log file cannot exceed 1,000 Oracle database blocks.
C.The total size of all the trace files and the alert log file cannot exceed 1,000 MB.
D.The size of a user trace file or a background trace file cannot exceed 1,000 operating system blocks.
QUESTION 81:
You want to store data in a table that should provide fast key-based access for queries involving exact matches and range searches. Which type of table would you use?
A.clustered table
B.index-organized table
C.regular partitioned table
D.regular table with referential integrity
QUESTION 31:
You want to create a database that uses the Oracle Managed Files (OMF) feature for your database. You specified the following parameters in the initialization parameter file to achieve this:
DB_CREATE_ONLINE_LOG_DEST_1 = ‘/u02/oradata/techdb’
DB_CREATE_ONLINE_LOG_DEST_2 = ‘/u03/oradata/techdb’
The DB_CREATE_FILE_DEST parameter is not specified.
Which statement in this scenario is correct?
A.The OMF feature will not be used because the DB_CREATE_FILE_DEST parameter is not specified.
B.The OMF feature will be used and all the database files are created as Oracle-managed files.
C.The OMF feature will be used, but only online redo log files are created as Oracle-managed files.
D.The OMF feature will be used, but only online redo log files and control files are created as Oracle-managed files.
QUESTION 21:
You specified extent management as local for a tablespace. How will this affect space management in the tablespace?
A.Bitmap will be used to record free and allocated extents.
B.Free extents will be managed by the data dictionary tables.
C.The tablespace can have extents containing blocks of different sizes.
D.The tablespace will be system managed and the users cannot specify the extent size.