databases Online Quiz - 136
|Description: databases Online Quiz - 136|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)
Which three features are provided by Oracle Net Services? (Choose three)
Which two statments regarding the control file and Recover Manager are true ? (Choose two)
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)
Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)
what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)
Which of the following data type is newly added in DB2 version 9?
Which type of index is used to control the physical sequence of data in table?
What type of database object does the following DDL statement creates CREATE TEST VOLUMES(ABCD1,ABCD2,ABCD3) VCAT dsn1
Maximum size of buffer pool page size
Which of the following statement is used for executing dynamic SQL
XQuery is used to retrieve what type of data?
Which of the following utility is recommended after REORG is performed on tablespaces?