Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Which are not an advantages of a synonym?

  1. Alias for a schema object

  2. Provide security by hiding the name of the object

  3. Provide security by hiding the schema owner of the object

  4. Reduce complexity in SQLs by creating short synonyms names for objects with long names

  5. By granting privilege to synonym, granting privilege to the underlying object can be avoided
Reveal answer Fill a bubble to check yourself
E Correct answer
Full explanation
Multiple choice technology databases

There are 2 schemas – S1 and S2 in a database. S1 has a table T1 in it. S2 don’t have any privileges on objects of S1. A synonym SYN_T1 is created in the schema S2 for S1.T1 and select privilege is granted to S2 on the synonym. Now, the newly created synonym is dropped. What will be the output of the following query executed from S2: Select * from S1.T1

  1. Error - Table or view does not exist

  2. Error - Synonym translation is invalid

  3. Output – all the rows of S1.T1

  4. Output – no rows retrieved
Reveal answer Fill a bubble to check yourself
C Correct answer