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 4563

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

4 6878

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

Infogain,

1 3385

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

Infogain,

3 8947

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

4 9064

How to find last day of the month in sql query

4 8372

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

2 5261

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 11716

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 6620

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 6202

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 5201

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.

2261

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 7347

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

Oracle,

1 6871

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 6973

Un-Answered Questions { Databases }

What is the cartesian product of table?

1009

What is sparse columns of sql server 2008?

1057

What is the usage of ENUMs in MySQL?

1132

What do you understand by the term 'normalization'?

673

what is the different between now() and current_date()? : Sql dba

1022

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4008

Is it possible to pass parameters to triggers?

1103

How to create a server parameter file?

1135

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1015

What is access runtime 2007?

863

How do I disconnect mysql workbench?

1064

How to use wildcard characters in like operations in ms sql server?

1138

What is filtered index?

1095

How much does sqlite cost?

1037

Is join same as left join?

1038

For More Un-Answered { Databases } Questions Click Here