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 7526

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 17831

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

2 7726

what is the difference between granting and creating a view?

2 6325

How to return multiple records from procedure?

2 9017

Un-Answered Questions { Databases }

what is offset-fetch filter in tsql? : Transact sql

960

How to rename a table?

1047

What is the load plans? And how to create for the load plans?

690

What jobs use sql?

991

what is the informix-list@iiug.org mailing list?

Explain about the process which takes place to execute a stored routine?

761

What are different types of constraints?

940

What is abstracting periodical?

959

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1028

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

2948

How information is stored on graph in neo4j database?

What is single-user mode?

954

How to call a stored function with parameters?

1053

How to recompile stored procedure at run time?

1086

How can you increase the performance of mysql select query?

933

For More Un-Answered { Databases } Questions Click Here