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

From where the Transactions per rollback segment is derived ?

1 8758

From where ENQUEUE resources parameter information is derived ?

1 5061

Where does the LGWR process writes information?

1 3825

What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?

1 6052

Where the Databases overall structure is maintained ?

1 11995

can Constraints cannot be exported through EXPORT command ?

Grasim, Oracle, Suvidha,

2 11358

What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?

HCL,

2 14068

What is the difference between a MESSAGEBOX and an ALERT ?

3 18314

Can a DIALOG WINDOW have scroll bar attached to it ?

1 6252

what are the advantages of GUI systems ?

1 9385

What is the difference between a LIST BOX and a COMBO BOX ?

2 4235

Why is it better to use an Integrity Constraint to validate data ?

1 3936

what are the advantages of a client or server model ?

1 4454

What does DLL stands for ?

Nexus Technologies,

2 9025

what is postback trigger?

1 5981

Un-Answered Questions { Databases }

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1056

How many types of auditing in Oracle?

1037

How can we determine what objects a user-defined function depends upon?

1019

After removing a table from database, what other related objects have to be dropped explicitly?

1064

What is ddl and dml commands?

911

What are different methods to trace the pl/sql code?

1124

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

122

What are the recovery models for a database? : sql server DBA

1133

How to delete exactly duplicate records from a table?

1067

can an automatic recovery be initiated by a user? : Sql server administration

958

Are left and right joins the same?

1092

What is view in mysql?

974

What is simple indexing method?

1039

What is the difference between subquery and correlated query?

1070

What is the function of ms access?

938

For More Un-Answered { Databases } Questions Click Here