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

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

Which table is used to identify the changes made to objects

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?

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

How to protect PL/SQL code?

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

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

Limitation for level of nesting in a PL/SQL program

Limitation for level of blocks in a PL/SQL program

Does PL/SQL supports executing operating system commands?

Which command is used to write information to an output buffer?

Command used to import the data from flat files?

Whether SQL has unloader facility to unload the data?

Can SQL loader handle EBCDIC data?

SQL loader can load images, sound clips and documents

Which are the commands used to improve the performance of loader

Which are all true in loading multi-line records?