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
Answers: B
QUESTION 82:
You want to know if there are any default values assigned to the columns in the TECHDATA table. How could you find this information?
A.by describing the table
B.by querying DBA_TABLES
C.by querying USER_TABLES
D.by querying USER_TAB_COLUMNS
Answers: D
QUESTION 83:
Which option lists the correct hierarchy of storage structures, from the smallest to the largest?
A.segment, extent, tablespace, and data block
B.data block, extent, segment, and tablespace
C.tablespace, extent, data block, and segment
D.tablespace, data block, extent, and segment
E.data block, segment, extent, and tablespace
F.segment, tablespace, data block, and extent
Answers: B
QUESTION 84:
You executed the following command that displays the output as shown in the Exhibit:
SQL> SELECT table_name, index_name,
monitoring, used
FROM v$object_usage;
View the Exhibit.
Which two statements are true? (Choose two.)
A.The monitoring is currently turned off for the index.
B.The index was never used when the monitoring was on.
C.The value of the USED column is NO because the monitoring is turned off.
D.The value, NO, for the MONITORING and USED columns indicates that the index is invalid and can never be used by queries.
Answers: A B
QUESTION 85:
You want to reuse all the existing data files, control files, and redo log files to re-create your test database. You execute the following command to create the database:
CREATE DATABASE testdb
DATAFILE
‘/u01/oradata/testdb/system01.dbf’
SIZE 100M REUSE
LOGFILE
GROUP 1 (‘/u01/oradata/testdb/log1a.rdo’,
‘/u02/oradata/testdb/log1b.rdo’)
SIZE 50K REUSE,
GROUP 2 (‘/u01/oradata/testdb/log2a.rdo’,
‘/u02/oradata/testdb/log2b.rdo’)
SIZE 50K REUSE
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10;
The command fails to create the database successfully. What could be the reason?
A.You have set MAXLOGFILES to a very low value.
B.You cannot reuse the online redo log files.
C.You have omitted the CONTROLFILE REUSE clause.
D.You cannot reuse the data file belonging to the SYSTEM tablespace.
Answers: C
QUESTION 86:
Which two statements are true regarding an extent that would be allocated to the table you are creating? (Choose two.)
A.The extent size is always set at the tablespace level.
B.The extent size cannot be changed after creating the table.
C.An extent in a table can have blocks from different data files.
D.The size of the first extent of the table cannot be less than two data blocks.
E.The extent size is rounded off to the nearest multiple of the data block size.
Answers: D E
QUESTION 87:
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.
Answers: D
QUESTION 88:
Which statement regarding the creation of a dictionary-managed tablespace is true?
A.You cannot set the tablespace for NOLOGGING mode.
B.You can set segment space management clause to auto.
C.You can specify default storage for dictionary-managed tablespaces.
D.You cannot specify default storage for a tablespace that consists of an autoextensible data file.
Answers: C
QUESTION 89:
You want to create a password verification function that will validate the password for a user when a new user is created or an existing user’s password is changed. What are the two considerations for creating the function? (Choose two.)
A.The function must be same for all users.
B.The function must return a BOOLEAN value.
C.The function must be owned by the SYS user.
D.The function must be owned by the SYSTEM user.
Answers: B C
QUESTION 90:
You created a role, ROLE1, with two system privileges, CREATE SESSION and CREATE TABLE. You granted the role to a user, USER01.The user is able to grant the role, ROLE1, to other database users in your database. Which two statements are correct in this scenario? (Choose two.)
A.The user is granted the role with the ADMIN OPTION.
B.The user is granted the role with the GRANT OPTION.
C.The user is granted the GRANT ANY ROLE system privilege.
D.The O7_DICTIONARY_ACCESSIBILITY parameter is set to True.
E.The user is granted the GRANT ANY PRIVILEGE system privilege.
Answers: A C
Passleader Latest Sample Questions for Oracle 1Z0-031 Test
