Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 are the advantages of log shipping?

1054

Why are views required in the sql server or in any other database?

1012

List the different index configurations possible for a table?

988

Where sql server usernames and passwords are stored in a sql server?

1045

List the various tools available for performance tuning?

938

What is a heap?

1093

Can we take the full database backup in log shipping?

1001

What are the 2 types of classifications of constraints in the sql server?

1187

What is an execution plan?

1254

What are the different types of columns types constraints in the sql server?

1148

What is the stored procedure?

1059

What are the advantages of the mirroring?

1158

What are the common performance issues in sql server?

982

What are the purposes of using enum and set data types?

983

Describe mysql transaction properties.

1076

Un-Answered Questions { Databases }

Which language is used in sql?

1127

What is a rownum?

1072

What is a partition in oracle?

1211

What is the powerful database utility that can be used for building, executing and processing queries upon PostgreSQL databases?

1662

Can you index views?

946

How to change the name of a database user?

1020

What will be objects between two dates in mongodb?

What plvcmt and plvrb does in pl/sql?

1370

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1649

How to drop a stored function?

1193

Do you know sql server 2008 introduces automatic auditing?

1065

What is the current limitation of the size of SQL Azure DB?

129

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1597

What is the maximum size of an access database?

922

what are constraints? : Sql server database administration

1138

For More Un-Answered { Databases } Questions Click Here