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 7700

what is insert all statement in sql

CGI, TCS,

2 6513

Explain the architecture models of SQL Server?

2336

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

3 7079

what is self join and how it works??

Infosys,

2 8536

wtite down triggr not any entry on Sunday

NIT,

2 6208

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

HP,

2115

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

2 3865

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 5674

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

HP,

2 6232

what is the use of home directory???

HP,

1 5309

what is rebuild index??

IBM, Sapient,

2 5705

What is the dataguard background process??

iGate,

1 6329

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

iGate,

2729

why not null is not allowed at table level

Cognizant,

2761

Un-Answered Questions { Databases }

What are rows and columns?

1019

What is the difference between oracle and postgresql?

949

Why we use the openxml clause?

1011

Explain what is the use of custom fields in report?

927

How to delete all rows with truncate table statement in ms sql server?

1001

What is a scalar value in sql?

1070

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1030

What is session variable in mysql?

979

What is the stored procedure to view current lock and processes respectively?

882

Is mysql relational?

913

Explain magic tables in sql server?

1057

What are the types of resultset?

967

How do I set a password to be null?

921

If you remove an object attribute, is it deleted from the database?

Enlist the disadvantages of query.

1163

For More Un-Answered { Databases } Questions Click Here