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 6877

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

Infogain,

1 3383

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 8371

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

2 5257

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 6870

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 6971

Un-Answered Questions { Databases }

What is merge in oracle?

1054

Explain about the architecture of MYSQL?

981

What is a table?

1014

Why are stored procedures used?

794

What happens when a trigger is associated to a view?

913

Why do we create views in sql?

1150

What is isolation levels?

1029

What is the main difference between sql and pl/sql?

1094

How to rebuild the master database?

1080

Explain in details security in SQL azure?

121

How to check if value already exists in mysql database in php?

888

What is dba in dbms?

1065

Is ms access a rdbms?

736

What is BSON?

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2496

For More Un-Answered { Databases } Questions Click Here