databases Online Quiz - 136
|Description: databases Online Quiz - 136|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)
When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)
Which three are the physical structures that constiture the Oracle database ? (Choose Three)
What file will give you Oracle instance status information?
Which three features are provided by Oracle Net Services? (Choose three)
You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three)
Which two roles or privileges must you have to export tables owned by another user? (Choose two)
SQL> CREATE TABLESPACE user_data EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully ? (Choose two)
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
Pick the odd one out
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?