databases Online Quiz - 128

Description: databases Online Quiz - 128
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

Correct Option: C

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

  1. Table

  2. View

  3. Procedure

  4. Package

  5. Another Synonym

  6. Sequence

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

Which table is used to identify the changes made to objects

  1. V$Session




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?

  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

Correct Option: C

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

  1. True

  2. False

Correct Option: A

How to protect PL/SQL code?

  1. Cant protect the code

  2. Third party utilities

  3. Binary wrapper utility

  4. Only DBA's are allowed to protect

Correct Option: C

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

  1. No limitations

  2. 542

  3. 254

  4. 245

Correct Option: C

Limitation for level of blocks in a PL/SQL program

  1. 125

  2. No limitation

  3. 255

  4. 55

Correct Option: C

Does PL/SQL supports executing operating system commands?

  1. True

  2. False

Correct Option: B




Correct Option: C

Command used to import the data from flat files?

  1. imp

  2. sqlloader

  3. sqlldr

  4. exp

Correct Option: C

Whether SQL has unloader facility to unload the data?

  1. True

  2. False

Correct Option: B

Which are the commands used to improve the performance of loader

  1. direct=true

  2. command

  3. indexes

  4. constraints

  5. running multiple load jobs

  6. fast=true

Correct Option: A,C,D,E
  1. Specifying carriage return statement in control file

  2. Position based loading

  3. Sperators as comments in the source file

  4. Carriage return

Correct Option: A,B,D

What are the Capabilities of SELECT Statement?

  1. Selection

  2. Projection

  3. Joining

  4. None of these

Correct Option: A,B,C
- Hide questions