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 7573

what is insert all statement in sql

CGI, TCS,

2 6417

Explain the architecture models of SQL Server?

2295

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

3 6959

what is self join and how it works??

Infosys,

2 8433

wtite down triggr not any entry on Sunday

NIT,

2 6086

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 3750

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 5571

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

HP,

2 6138

what is the use of home directory???

HP,

1 5233

what is rebuild index??

IBM, Sapient,

2 5597

What is the dataguard background process??

iGate,

1 6237

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

iGate,

2667

why not null is not allowed at table level

Cognizant,

2717

Un-Answered Questions { Databases }

A trigger can reference objects outside the current database? State true or false.

959

What is oracle rownum?

897

Should you start out with sharded or with a non-sharded mongodb environment?

How to test null values?

1052

Explain the terms database and dbms. Also, mention the different types of dbms.

865

What is parallel database architecture?

804

how to convert character strings to numeric values? : Sql dba

1041

What is the main reason behind using an index?

975

What do you understand by oracle forms and why are they required?

967

Does microsoft 365 come with access?

737

Which is the best free database software?

900

What is difference between inner vs self vs cross?

917

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

What is sql used for?

1073

What is tns service name?

1089

For More Un-Answered { Databases } Questions Click Here