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 7578

what is insert all statement in sql

CGI, TCS,

2 6420

Explain the architecture models of SQL Server?

2297

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

3 6965

what is self join and how it works??

Infosys,

2 8437

wtite down triggr not any entry on Sunday

NIT,

2 6098

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

HP,

2071

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

2 3756

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 5575

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

HP,

2 6146

what is the use of home directory???

HP,

1 5237

what is rebuild index??

IBM, Sapient,

2 5599

What is the dataguard background process??

iGate,

1 6244

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

iGate,

2669

why not null is not allowed at table level

Cognizant,

2717

Un-Answered Questions { Databases }

How many types of database triggers exist?

1080

What are subqueries in sql server? Explain its properties.

978

How to create a test table in your mysql server?

989

When would you use the stored procedures or functions?

961

Can I copy mysql data directory?

877

What will be the maximum number of index per table?

965

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

957

how can you create an empty table from an existing table? : Sql dba

1094

How to recover from sql injection? : sql server security

971

How does cross join work in sql?

971

What are secondary keys?

934

What is a trigger oracle?

1051

How can we find out which auto increment was assigned on Last insert?

1048

What are the various features present in ms access?

786

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1709

For More Un-Answered { Databases } Questions Click Here