Interview Questions Answers in SQL PLSQL, Manual Testing

Question { 8567 }

What is an Integrity Constraint?

Answer

Integrity Constraint is a rule that restricts a value to a
clomn in table.

Is This Answer Correct ?

2 Yes

0 No

Question { 7794 }

What is a database link?

Answer

It's a named path through which remote database can be

accessed.

Is This Answer Correct ?

0 Yes

1 No

Question { 6824 }

What is the Subquery?

Answer

SELECT Statement which is embedded in another class of
SELECT statement is nothing but "Sub-Query".

In this ..Inner query will execute first.based on that
result outer query will execute.

Thank you,
Suresh

Is This Answer Correct ?

6 Yes

0 No

Question { DELL, 20730 }

What is NOCOPY?

Answer

OUT and IN OUT parameters passed by reference which avoid
COPY overhead.

Is This Answer Correct ?

2 Yes

1 No

Question { 21999 }

What is difference between % ROWTYPE and TYPE RECORD ?

Answer

%ROWTYPE is to be used whenever query returns a row of
Database Table.

RECORD TYPE is to be used whenever query returns a columns
of different Tables.

Eg : TYPE IS RECORD (Name Varchar2,
No Number);

Thank you,
Suresh

Is This Answer Correct ?

15 Yes

4 No

Question { 9325 }

What are the PL/SQL Statements used in cursor processing ?

Answer

Declaring a CURSOR
Open the CURSOR
FETCH the rows from the CURSOR
CLOSE the CURSOR...

Is This Answer Correct ?

5 Yes

2 No

Question { 8765 }

What is a cursor for loop ?

Answer

Cursor for loop implicitly declares %rowtype as Loop index
opens the cursor and fetch the rows from active set into
fields and then process it and then close the cursor.

Is This Answer Correct ?

1 Yes

3 No

Question { TCS, 12131 }

What is a 'instead of trigger'?

Answer

These Triggers are used to modify the VIEW whaich can't be
modified by DML statements.

Thank you,
Suresh.

Is This Answer Correct ?

1 Yes

0 No

Question { TCS, 9737 }

Types of backups ?

Answer

1.Physical Backup :-----
a.Hot Backup (which is running)

b.Cold Backup (Which is not running)

2.Logical backup (Done by Programmer)

Is This Answer Correct ?

6 Yes

1 No

Question { Hexaware, 59170 }

What is INSTEAD OF trigger ?

Answer

"Instead Of Triggers " are used to modify the view
which can't be modified by DML Statements.

Is This Answer Correct ?

31 Yes

28 No

Question { BirlaSoft, 20648 }

What is normalization ?

Answer

Normalization is the process of organizing the table to
remove redundancy.

Is This Answer Correct ?

8 Yes

0 No

Question { 21537 }

what is ref cursor in pl/sql?

Answer

Re-usability of a cursor is nothing but " REF CURSOR".
It is of 2 types.
1. Weak REF Cursor
2. Strong REF Cursor.

SYNTAX:
1.Strong Refcursor
SYN: TYPE IS
REFCURSOR RETURN
2.Weak Refcursor
SYN : TYPE IS
REFCURSOR

Thank you,
Suresh

Is This Answer Correct ?

11 Yes

2 No

Question { PreVator, 18268 }

Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?

Answer

%Type is used to change the size of any datatype but only
for one record.

%Rowtype is used to declare a recoed that represents a
particular row of a table.

Is This Answer Correct ?

9 Yes

4 No

Question { 12765 }

what is meant by tuning and tk proof?

Answer

Tkproof is a tool by Oracle to format the trace file Output.

Is This Answer Correct ?

6 Yes

0 No

Question { TCS, 40943 }

what is the output of the query select * from emp where 1=2

Answer

Hi Anfal,

Try the following Query.

SQL> CREATE TABLE EMP_NEW
AS
SELET *
FROM EMP
WHERE 1=2;
Table Created

SQL> SELECT * FROM EMP_NEW
no rows selected.

SQL> DESC EMP_NEW;
Structure will be displayed.

Please correct me if any mistakes.

Thank you,
Suresh

Is This Answer Correct ?

11 Yes

4 No

user71408