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 6404

Differences between functions and stored procedures?

247Customer, Accenture,

8 15734

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

247Customer,

12 16569

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 4996

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.

3332

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

1907

what is null value?

9 10627

How to recompile a already made trigger?

2 11840

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

TCS,

3 8653

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

8 11862

what is transaction state, buffer management, shadow paging

3462

Un-Answered Questions { Databases }

Can you redefine a table online?

1117

List types of tables in SQL Azure?

126

What are the characteristics of data in the database?

984

Explain the collation?

1115

How do I show users in mysql?

1066

What is the equivalent of oracle/db2 coalesce function in sybase?

875

What is a raid and what are different types of raid configurations?

1267

Is it possible in sql table to have more than one foreign key?

1037

What is innodb_buffer_pool_size?

982

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1115

How do I install mysql on windows 10 64 bit?

915

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1029

when would you go for denormalization? : Sql server database administration

874

How many control files should you have? Where should they be located?

584

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

1110

For More Un-Answered { Databases } Questions Click Here