RDBMS 2

PL/SQL is a

• Block Structured Language

• Brick Structured Language

• Banner Structured Language

• Build Structured Language

What does PL/SQL stand for?

• Primary Language Extension of SQL

• Pattern Language Extension of SQL

• Procedural Language Extension of SQL

• Private Language Extension of SQL

A Variable in PL/SQL should not exceed

• 10

• 20

• 30

• 40

PL/SQL Variables are by default

• Not Case Sensitive

• Lower Case Sensitive

• Upper Case Sensitive

• Case Sensitive

Which of the following cannot be overwritten by procedure?

• IN

• OUT

• INOUT

• ALL

Which of the following is the correct syntax to fetch the cursor?

• INTO variable_list FETCH cursor_name;

• FETCH variable_list INTO cursor_name;

• FETCH cursor_name INTO variable_list;

• INTO cursor_name FETCH variable_list;

How many types of exceptions are there?

When ZERO_DIVIDE exception is raised?

Which clause is used to open the cursor?

• OPEN

• START

• BEGIN

• DECLARE

PL/SQL function must contain