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 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)
what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)
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
XQuery is used to retrieve what type of data?
Which of the following utility is recommended after REORG is performed on tablespaces?