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

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 7536

what is insert all statement in sql

CGI, TCS,

2 6390

Explain the architecture models of SQL Server?

2285

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

3 6924

what is self join and how it works??

Infosys,

2 8404

wtite down triggr not any entry on Sunday

NIT,

2 6052

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

HP,

2061

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

2 3726

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 5552

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

HP,

2 6115

what is the use of home directory???

HP,

1 5192

what is rebuild index??

IBM, Sapient,

2 5576

What is the dataguard background process??

iGate,

1 6207

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

iGate,

2661

why not null is not allowed at table level

Cognizant,

2704

Un-Answered Questions { Databases }

how you can get the list of largest tables in a database? : Sql server administration

985

can we have a nested transaction? : Sql server database administration

991

Why is the use of dbms recommended?

1189

What is File steps?

565

what are date and time intervals? : Sql dba

998

What is coalesce and check constraint in sql server?

1041

what is package and it uses and how can u call a package

1951

Is mongodb relational?

What is cdc in sql server?

950

What is foreign key and example?

885

Is it possible to create the following trigger: before or after update trigger for each row?

1236

Is the After report trigger fired if the report execution fails ?

2876

What is couchdb?

How to insert a record into a table?

1018

What are the differences between hash join, merge join and nested loops?

935

For More Un-Answered { Databases } Questions Click Here