QUESTION NO: 1
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.
Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table
Correct Answer: C
Vote an answer
QUESTION NO: 2
If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?
If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?
Correct Answer: B
Vote an answer
QUESTION NO: 3
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?
Correct Answer: A
Vote an answer
QUESTION NO: 4
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time "pit".
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE
QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE
QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time "pit".
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE
QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE
QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?
Correct Answer: C
Vote an answer
QUESTION NO: 5
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
Correct Answer: A,E
Vote an answer
QUESTION NO: 6
Which options are valid for an online reorganization operation?
Which options are valid for an online reorganization operation?
Correct Answer: A
Vote an answer