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 7077

what is self join and how it works??

Infosys,

2 8536

wtite down triggr not any entry on Sunday

NIT,

2 6205

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

HP,

2113

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 5704

What is the dataguard background process??

iGate,

1 6329

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

iGate,

2728

why not null is not allowed at table level

Cognizant,

2758

Un-Answered Questions { Databases }

what are the different stages of Report Processing?

135

Is foreign key indexed mysql?

894

When do we use triggers?

1078

How set mysql root password?

916

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

Who owns sybase?

845

How to set mysql variable in php?

927

How to connect mongodb with visual studio 2017?

How do you say mysql?

898

Explain what are partitioned views and distributed partitioned views?

943

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7972

8. Supporting AP, AR and GL?

2308

What are the ways tablespaces can be managed and how do they differ?

2365

How is incremental backup different from differential backup?

What are object group?

For More Un-Answered { Databases } Questions Click Here