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 7501

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 17813

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

2 7709

what is the difference between granting and creating a view?

2 6313

How to return multiple records from procedure?

2 8998

Un-Answered Questions { Databases }

Where is postgresql conf in mac?

1008

What is the difference between inner join and outer join?

1002

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1633

What is the difference between stored procedure and user defined functions?

1194

What is backup in Oracle?

1008

Is mongodb better than cassandra?

What is the difference between functions and scalar functions?

1214

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2266

What is trigger point?

1000

List different type of expressions with the example.

935

How do I stop a query in mysql workbench?

946

Is grant a ddl statement?

904

Can you pass expressions to function parameters?

1107

Can we use threading in pl/sql?

1043

What are different types of transactions in ar? : oracle accounts receivable

1301

For More Un-Answered { Databases } Questions Click Here