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

What do you mean by adaptive server enterprise?

963

What data types does sybase support?

900

Explain asa, asa ultralite.

877

Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

847

Explain 'forcing an index' concept.

935

What do you mean by deferred update in sybase?

947

There is no space in file system and you need to take a back up. What will you do?

860

What will you do if a replication thread goes down?

1000

How do you view log files in sybase?

952

List the types of locking?

1026

List the merits of index covering.

900

Explain data cache?

957

How would you lock a table in sybase? What text command will you use for it?

898

The secondary truncation point is on. How would you clear the logsegment?

881

Differentiate between ltm and repagent?

1003

Un-Answered Questions { Databases }

What is mongoose in mongodb?

What to check if a User database is locked?

1090

What is primary key in ms access 2007?

858

How can you fix a poorly performing query?

1205

Does creating an index lock the table?

806

what is the role of profiler in mongodb?

What has stored procedures in sql?

1075

What is the disk migration? what is the steps involved in oracle disk migration?

1237

How do I find the size of a mysql database?

934

Is sql free?

986

Use of an integrity constraint is better to validate data. Explain

1057

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

966

What is the unique index?

1066

What is named query? : sql server analysis services, ssas

976

What is the sql case statement?

1022

For More Un-Answered { Databases } Questions Click Here