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 5151

Differences between functions and stored procedures?

247Customer, Accenture,

8 13032

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

247Customer,

12 12883

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 4224

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.

2879

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

1433

what is null value?

9 8108

How to recompile a already made trigger?

2 10831

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

TCS,

3 7407

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

8 9584

what is transaction state, buffer management, shadow paging

2926

Un-Answered Questions { Databases }

What are the benefits of mongodb?

What are different types of data models available? Explain with example?

657

What command do we use to rename a database?

609

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1576

How many types of schemas are there?

523

Where does the clusterware write when there is a network or storage issue?

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

726

how to start mysql server? : Sql dba

607

Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?

What is dynamic proxy?

547

Explain the truncate command? : sql server architect

432

Explain the Normalized Relations?

2304

What is oracle database 10g express edition?

589

How does mongodb sharding work?

Is inner join faster than left join?

627

For More Un-Answered { Databases } Questions Click Here