QUESTION NO: 1
What is the minimum authority required to execute the LOAD command?
What is the minimum authority required to execute the LOAD command?
Correct Answer: A
Vote an answer
QUESTION NO: 2
A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?
A batch application updates a large number of rows within a single transaction. What is one way to help the application complete quickly?
Correct Answer: D
Vote an answer
QUESTION NO: 3
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?
Correct Answer: C
Vote an answer
QUESTION NO: 4
Given a database created as follows:
If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/foreign key relationship between column C1 in table T1, and column C1 in table T2?
Given a database created as follows:
If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/foreign key relationship between column C1 in table T1, and column C1 in table T2?
Correct Answer: A
Vote an answer
QUESTION NO: 5
How can you change an existing non-partitioned index for a partitioned table to a partitioned index?
How can you change an existing non-partitioned index for a partitioned table to a partitioned index?
Correct Answer: B
Vote an answer
QUESTION NO: 6
A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
Correct Answer: D
Vote an answer
QUESTION NO: 7
Which command would be used to obtain the name of the first active log file for a database with log retain enabled?
Which command would be used to obtain the name of the first active log file for a database with log retain enabled?
Correct Answer: C
Vote an answer
QUESTION NO: 8
What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)
Correct Answer: D,E
Vote an answer
QUESTION NO: 9
A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?
A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?
Correct Answer: D
Vote an answer
QUESTION NO: 10
What would indicate intra-partition parallelism in an Optimizer Plan?
What would indicate intra-partition parallelism in an Optimizer Plan?
Correct Answer: D
Vote an answer