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

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

CGI,

4 7830

what is insert all statement in sql

CGI, TCS,

2 6622

Explain the architecture models of SQL Server?

2380

PL/SQL allocates memory for the variable's at runtime or at compile time

3 7199

what is self join and how it works??

Infosys,

2 8629

wtite down triggr not any entry on Sunday

NIT,

2 6328

how can you connect from 10g user to 11g user??

HP,

2164

one datafile is lost in standy side how can you recover that??

2 3954

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

iGate,

1 5748

I lost one datafile i dont have backup how can you recover that???

HP,

2 6352

what is the use of home directory???

HP,

1 5394

what is rebuild index??

IBM, Sapient,

2 5798

What is the dataguard background process??

iGate,

1 6414

which background process invoke at the time of upgradation tell me???

iGate,

2778

why not null is not allowed at table level

Cognizant,

2807

Un-Answered Questions { Databases }

Explain the etl (extraction, transformation, and loading)?

1052

does sql support programming? : Sql dba

1087

What is the difference between a primary key and a clustered index?

1035

What is blind sql injection?

1164

What are commit, rollback, and savepoint?

1047

What do you mean by stored procedures?

1069

Why use “pivot” in sql server?

1177

What is it unwise to create wide clustered index keys?

1045

How do you create type- insensitive operator?

1099

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

631

How do you rename a database?

972

Can primary key be null postgres?

872

What is pg bouncer?

802

What are the different mysql database engines?

1233

What are the differences between union, intersect, and minus operators?

1140

For More Un-Answered { Databases } Questions Click Here