Definition of relational DataBase by Dr. Codd (IBM)

What are the various types of RollBack Segments ?

Public Available to all instances
Private Available to specific instance

Can you use %RowCount as a parameter to a cursor ?

Yes

Is the query below allowed :
Select sal, ename Into x From emp Where ename = 'KING'
(Where x is a record of Number(4) and Char(15))
Yes

Is the assignment given below allowed :
ABC = PQR (Where ABC and PQR are records)
Yes

Is this for loop allowed :
For x in &Start..&End Loop
Yes

How many rows will the following SQL return :
Select * from emp Where rownum <>
9 rows

How many rows will the following SQL return :
Select * from emp Where rownum = 10;
No rows

Which symbol preceeds the path to the table in the remote database ?
@

Are views automatically updated when base tables are updated ?
Yes

Can a trigger written for a view ?
No

If all the values from a cursor have been fetched and another fetch is issued, the output will be : error, last record or first record ?
Last Record

A table has the following data : [[5, Null, 10]]. What will the average function return ?
7.5

Is Sysdate a system variable or a system function?
System Function

Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2. Suppose at this point we issue an rollback and again issue a nextval. What will the output be ?

answer :3

Definition of relational DataBase by Dr. Codd (IBM)?

A Relational Database is a database where all data visible to the user is organized strictly as tables of data values and where all database operations work on these tables.