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

Oracle (3253)
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 4649

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

4 7042

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

Infogain,

1 3452

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

Infogain,

3 9072

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

4 9189

How to find last day of the month in sql query

4 8514

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

2 5331

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 11916

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 6731

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 6331

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 5274

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.

2316

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 7489

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

Oracle,

1 6968

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 7075

Un-Answered Questions { Databases }

Who maintains postgresql?

925

How can I make sql query run faster?

1067

Which is better Oracle or MS SQL? Why?

5032

Differentiate between sql temp table vs table variable?

927

What is the difference between the application object and session object?

1123

What is the blob data type?

827

What are the operating systems in which sybase could take its presence?

952

Can you store images in postgres?

827

What are the various configuration files that are used by oracle forms?

1073

What are % type and % rowtype?

1081

What is delimiter sql?

1058

Is mongodb publicly traded?

What do database buffers contain?

1083

Can we add an identity column to decimal datatype?

1042

What do you mean by cql?

For More Un-Answered { Databases } Questions Click Here