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

How can you stop stored procedures from recompiling?

920

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1005

What is a livelock?

985

What are alternate keys?

997

What does it mean to normalize a database and why would you do it?

992

‘Order by’ is not allowed in a view how can you sort information from a view?

1098

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

964

How do you use a subquery to find records that exist in one table and do not exist in another?

1061

Can a cursor be updated? If yes, how you can protect which columns are updated?

1141

What is xdr?

1001

How can you set the threshold at which sql server will generate keysets asynchronously?

1008

Which table keeps information about stored procedures?

959

How is a full-text index updated?

966

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

961

How can you find out how many rows returned in a cursor?

1045

Un-Answered Questions { Databases }

Can a table have multiple primary keys?

917

Does postgresql run on the cloud?

1167

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1033

What is a system database and what is a user database? : sql server DBA

1252

Explain about various levels of constraint.

959

How to how to convert numeric expression data types using the convert() function??

1067

When you use CKM?

593

sparse lookup and where its options we find in OCI and db2?

2239

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1027

What is merge statement?

1096

Is sql pronounced sequel or sql?

1287

Is it possible to use primary key of one table as a primary key in many other tables?if yes, how?

785

What is an oracle report?

1094

Can files be stored in a database?

956

What are the advantages of microsoft access?

910

For More Un-Answered { Databases } Questions Click Here