Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

There are Two pl/sql Libraries Lib1,Lib2 are attached to a form and these two libraries contains functions with same name fun1 (i,e lib1 have a function fun1 and lib2 also have a function fun1).how to call these functios from forms?

3i Infotech,

3 7602

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

Accenture, Unisoft Infotech,

2 17951

Give which cursor is better for better performance means type of cursors?

2 7798

what is the difference between granting and creating a view?

2 6393

How to return multiple records from procedure?

2 9106

Un-Answered Questions { Databases }

How can we access neo4j interface?

Is mongodb better than mysql?

What is DCL?

1104

What are sql server procedures?

1037

When does checkpoint occur in dbms?

1080

What is scalar and vector?

1063

What is pivot query?

1124

What is the difference between the conventional and direct path loads? : aql loader

1476

What are the logical operations?

1174

What are the operators used in select statements?

1100

How to store and query spatial data?

1048

What is de-normalization and what are some of the examples of it?

1020

Explain normalization and what are the advantages of it?

1001

Write a query to display even rows in student table using mysql?

942

Can delete statement be rollbacked?

1033

For More Un-Answered { Databases } Questions Click Here