You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?
A. Both the LOB descriptor and the LOB data will be stored in the base table.
B. The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.
C. Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.
D. Only the LOB data will be stored in the base table.
正解:D
質問 2:
Which of the following is NOT a valid workload name?
A. SYS_WKLOAD
B. DBA_WKLOAD
C. &WKLOAD
D. #WKLOAD
正解:A
質問 3:
When using an online backup recovery strategy, what steps are required to backup and recover a database to the end of backup timestamp?
A. Backup the database.
Restore the database.
Roll forward the database to the end of backup timestamp.
B. Backup the database and include the recovery logs.
Restore the database.
Roll forward the database to the end of backup timestamp.
C. Backup the database.
Roll forward the database to the end of backup timestamp.
D. Backup the database and include the recovery logs.
Restore the database to the end of backup timestamp.
正解:B
質問 4:
If table TAB_A and index TABA_IDX are created as follows:
What can be compressed?
A. All data in table TAB_
B. Only data in columns C1 and C2 of table TAB_A.
C. All data in table TAB_A and index TABA_IDX.
D. Only data in columns C1 and C2 in table TAB_A and index TABA_IDX.
正解:D
質問 5:
The following trusted context has been defined:
Which statement is correct?
A. If APP1 connects from address 9.26.113.204 and no role has been granted to APP1, then and only then will role CONTEXT_ROLE be used.
B. If USER1 connects to the database from address 9.26.113.204 without providing a password, the connection will run under userid APP1.
C. If APP1 establishes a connection to the database, a connection to the database server at address 9.26.113.204 will be enabled using a role of CONTEXT_ROLE.
D. If APP1 connects from address 9.26.113.204, it will have role CONTEXT_ROLE associated with the connection.
正解:D
質問 6:
Which command will activate the statement concentrator?
A. UPDATE DB CFG FOR mydb USING STMTCONCENT ON
B. UPDATE DB CFG FOR mydb USING STMT_CONC YES
C. UPDATE DB CFG FOR mydb USING STMT_CONC LITERALS
D. UPDATE DB CFG FOR mydb USING STMTCONC ENABLED
正解:C
宫脇** -
C2090-546合格できてとても嬉しいです。ほんとうに内容は素晴らしいと思います