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

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

981

Explain for xml explicit mode?

994

How can you check the level of fragmentation on a table?

1058

Explain an automatic checkpoint

984

If no size is defined while creating the database, what size will the database have?

1006

How you would rewrite the sql query to return the customerid sorted numerically?

1017

What you can do to delete a table without the delete trigger firing?

986

What is the difference between insensitive and scroll cursor?

1178

Why transaction is important?

987

in the physical file layout, where should the transaction log be stored in relation to the data file?

1011

What are the approximate numeric data types?

955

What is a partitioned view?

1022

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1047

What is a derived table?

942

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1217

Un-Answered Questions { Databases }

Which sql server is best?

1012

What storage engines are used in MySQL?

1068

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3778

What is a constraint? Tell me about its various levels.

1188

Which query operators in sql is used for pattern matching?

985

What are the functions of mysql?

952

What, if a table has one column defined as TIMESTAMP?

1022

How can you access different databases temporarily?

How do I find the database name in oracle?

1051

How is super key different from a candidate key?

920

What is the use of mongodb sort()?

What is the order in which the sql query is executed?

951

Will ms access be discontinued?

817

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

545

Is mysql a distributed database?

983

For More Un-Answered { Databases } Questions Click Here