databases Online Quiz - 128 Online Test

0

databases Online Quiz - 128

Description: databases Online Quiz - 128
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: 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

technology databases

Error - Table or view does not exist
Error - Synonym translation is invalid
Output – all the rows of S1.T1
Output – no rows retrieved

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

technology databases

Table
View
Procedure
Package
Another Synonym
Sequence

Which table is used to identify the changes made to objects

technology databases

V$Session
USER_CHANGES
USER_OBJECTS
USER_TRACKER

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

Public synonym will be created
Only a private synonym will be created
Error
Public synonym will be created, but accessible only from S2

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

technology databases

True
False

How to protect PL/SQL code?

technology databases

Cant protect the code
Third party utilities
Binary wrapper utility
Only DBA's are allowed to protect

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

technology databases

No limitations
89
76
98

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

technology databases

No limitations
542
254
245

Limitation for level of nesting in a PL/SQL program

technology databases

10
32
23
No limitations

Limitation for level of blocks in a PL/SQL program

technology databases

125
No limitation
255
55

Does PL/SQL supports executing operating system commands?

technology databases

True
False

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

technology databases

SET OUTPUT ON
SET BUFFEROUTPUT ON
SET SERVEROUTPUT ON
SET SCREEN ON

Command used to import the data from flat files?

technology databases

imp
sqlloader
sqlldr
exp

Whether SQL has unloader facility to unload the data?

technology databases

True
False

Can SQL loader handle EBCDIC data?

technology databases

True
False

SQL loader can load images, sound clips and documents

technology databases

True
False

Which are the commands used to improve the performance of loader

technology databases

direct=true
command
indexes
constraints
running multiple load jobs
fast=true

Which are all true in loading multi-line records?

technology databases

Specifying carriage return statement in control file
Position based loading
Sperators as comments in the source file
Carriage return

What are the Capabilities of SELECT Statement?

technology databases

Selection
Projection
Joining
None of these

To join n tables together, you need a minimum of ________ join conditions

technology databases

N-2
N
N-1
None of these

- Hide questions