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 4485

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

4 6669

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

Infogain,

1 3275

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

Infogain,

3 8797

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

4 8852

How to find last day of the month in sql query

4 8210

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

2 5127

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 11480

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 6473

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 6078

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 5105

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.

2199

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 7138

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

Oracle,

1 6739

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 6873

Un-Answered Questions { Databases }

What are the types of indexing?

1031

Is sql similar to mysql?

820

Can we deploy SSRS reports on our personal website?

162

Is inner join same as self join?

1063

What is the file extension for sql database?

939

What is normalization in dbms?

864

Explain the use of where clause in ms access sql?

804

What are the different methods to insert document?

How to end the current transaction in oracle?

966

In which files does sql server actually store data?

853

What is tkprof?

Display the employees whose salary is less than average salary.

1011

What is the process of normalization?

1058

What is where clause in oracle?

982

What is a natural key in sybase?

948

For More Un-Answered { Databases } Questions Click Here