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

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

247Customer,

3 6394

Differences between functions and stored procedures?

247Customer, Accenture,

8 15718

Can we have more than one NULL in a column having unique constraint?

247Customer,

12 16549

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 4987

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1906

what is null value?

9 10604

How to recompile a already made trigger?

2 11833

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

TCS,

3 8643

how to get enames with comma seperated values by deptwise on emp table?

8 11853

what is transaction state, buffer management, shadow paging

3456

Un-Answered Questions { Databases }

What is updatable resultset?

1007

What is sharding in mongodb?

How do I view an execution plan in sql?

983

Is there a database program for mac?

930

How many types of schemas are there?

1042

Determine when to use stored procedure to complete sql server tasks?

1054

How do sql triggers work?

1041

How to avoid duplicate records in a query?

1008

Explain why variables called the most powerful component of ssis?

1097

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7972

How to use "begin ... End" statement structures in ms sql server?

1043

Why is sql better than hql?

992

What is a longblob?

948

How do I change the max connections in mysql?

894

Does mongodb need a lot space of random access memory (ram)?

For More Un-Answered { Databases } Questions Click Here