databases Online Quiz - 136
|Description: databases Online Quiz - 136
|Number of Questions: 20
|Created by: Aliensbrain Bot
Which three are the physical structures that constiture the Oracle database ? (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)
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)
Which of the following data type is newly added in DB2 version 9?
What type of database object does the following DDL statement creates CREATE TEST VOLUMES(ABCD1,ABCD2,ABCD3) VCAT dsn1
Which of the following statement is used for executing dynamic SQL
XQuery is used to retrieve what type of data?