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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

create one table to capture an employee details with a primary key.

CTS,

1 4506

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 6700

What is the criteria while applying index to any column on any table.

Infogain,

1 3304

What is the diffrence between IN and EXISTS.which one is faster.

Infogain,

3 8836

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 8896

How to find last day of the month in sql query

4 8244

Fetch an entire row from the employees table for a specific employee ID:

2 5159

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

British Telecom BT,

7 11533

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 6513

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 6109

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

HCL,

1 5124

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2214

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 7178

while loading data into database how can u skip header and footer records in sql*loader

Oracle,

1 6766

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

Oracle, Wipro,

1 6897

Un-Answered Questions { Databases }

What are the properties of a database?

969

What is an Oracle Data Dictionary?

1059

What is procedures in mysql?

898

What is the purpose of database management system?

1006

What does tinyint mean?

872

How to test subquery results with the exists operator?

1053

Explain the importance of partitioning.

928

What are modules in ms access?

742

How to define Data Block size in Oracle?

1082

What is dcl? : sql server DBA

1205

When would you use the stored procedures or functions?

962

Tell about MOM Tool(Microsoft Operator Manager)?

1869

How does mongodb replica set work?

Can you please differentiate between a primary key and a unique key?

968

What are the advantages of sql?

1016

For More Un-Answered { Databases } Questions Click Here