databases Online Quiz - 31
|Description: databases Online Quiz - 31|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
The user Sue issues this SQL statement: GRANT SELECT ON sue.EMP TO Alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue.EMP TO Rena WITH GRANT OPTION; The user Rena issues this SQL statement: GRANT SELECT ON sue.EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue.EMP FROM Alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?
IDMS stands for _____________?
IDMS is ______ type of database.
In IDMS terminology, a parent record is called an ________ and a child record is called a ______.
The unit of data that is passed by IDMS from database to application program is known as ________.
The relationship between 2 or more record types is defined by ___?
What is true about COMPRESSED backups in Oracle 11g? Choose all that apply
What is the RMAN command to set the compression algorithm to ZLIB?
What is true about group functions ?
Can you use both HAVING and WHERE Sql clauses in one SQL statement ?
For which two constraints,does the oracle server implicitly creates an index ?