Tag: databases

Questions Related to databases

What are the data base objects for which you can create synonyms?
technology databases

  1. Table

  2. View

  3. Procedure

  4. Package

  5. Another Synonym

  6. Sequence

Show answer
Correct Option: A,B,C,D,E,F

Which are not an advantages of a synonym?
technology databases

  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

Show answer
Correct Option: E

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
technology databases

  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

Show answer
Correct Option: C

What are the data base objects for which you can create synonyms?
technology databases

  1. Table

  2. View

  3. Procedure

  4. Package

  5. Another Synonym

  6. Sequence

Show answer
Correct Option: A,B,C,D,E,F

Which table is used to identify the changes made to objects
technology databases

  1. V$Session

  2. USER_CHANGES

  3. USER_OBJECTS

  4. USER_TRACKER

Show answer
Correct Option: C

There are 2 schemas – S1 and S2 in a database. S1 has a table T1 in it. The following command is executed from the DBA user: Create public synonym S2.SYN_T1 for S1.T1 What will be the result?
technology databases

  1. Public synonym will be created

  2. Only a private synonym will be created

  3. Error

  4. Public synonym will be created, but accessible only from S2

Show answer
Correct Option: C

PL/SQL and Java can be used to create Oracle stored procedures and triggers
technology databases

  1. True

  2. False

Show answer
Correct Option: A

How to protect PL/SQL code?
technology databases

  1. Cant protect the code

  2. Third party utilities

  3. Binary wrapper utility

  4. Only DBA's are allowed to protect

Show answer
Correct Option: C

Limitation for level of label Nesting in a PL/SQL program
technology databases

  1. No limitations

  2. 89

  3. 76

  4. 98

Show answer
Correct Option: D

Limitation for level of Subquery Nesting in a PL/SQL program
technology databases

  1. No limitations

  2. 542

  3. 254

  4. 245

Show answer
Correct Option: C