Oracle MCQ

Oracle:

      Full form of RDBMS: Relational DataBase Management System

1.

Data entered by user is usually validated by: 

Client

2.

Normalization is used:

5NF

3.

Using ‘LIKE’ operator, we may compare single character with: 

     _ Underscore

4.

Which is the pseudo-column in oracle table?

    ROWID

5.

The option ON DELETE CASCADE can be defined with: Foreign Key            

6.

Two copies of same table is created in memory if join operator: Self Join

7.

Force View means:

View created without table

8.

The sequence object always generates: Numeric Value

9.

When the variable is not initialized in PL/SQL block, it contains:

 NULL  

10. In PL/SQL block, single line comment can be inserted using:

Both of above  

11.When the SIZE any TYPE if column is likely to be changed, we should declare the variable of type

   % ROWTYPE%

12.

The default parameter mode is: IN type

13.

Which type of trigger will be fired first – when event occurs?

Before – statement Level 

14.  : OLD and: NEW are: Pseudo records for now level trigger      

 

 
15. You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?   Ans:SELECT last_name, department_name
FROM employees e LEFT OUTER
JOIN departments d ON (e.department_id = d.department_id);


16. The relational database environment has all of the following components exce: separate files
17.

The language used application programs to request data from the DBMS is
referred to as the: DML

18.

The highest  level in the hierarchy of data organization is called: data base