databases Online Quiz - 166
|Description: databases Online Quiz - 166|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which two roles or privileges must you have to export tables owned by another user? (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)
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)
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)
what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)
What file will give you Oracle instance status information?
Which of the following SQL statements does count the rows in the 'Sales' table?
Which SQL statement inserts data into a table called Projects?
The LIKE SQL keyword is used along with ...
Which of the following is a SQL aggregate function
The JOIN is a SQL keyword used to ...
Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 2006?
Can you use the UPDATE and SELECT clauses in one SQL statement?
What does the FROM SQL keyword specify?
A trigger belongs to…