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 are the different ddl commands in sql?

1170

What are the different tcl commands in sql?

1176

What are the different dml commands in sql?

1177

What are sql constraints?

1175

What are aggregate functions in sql?

1162

What is the difference between rename and alias?

1344

List out the acid properties and explain?

953

What are the different types of sql commands?

1128

What are the popular database management systems in the it industry?

1000

Explain what is a database?

1087

Explain what is an index?

1057

What is the difference between unique and primary key constraints?

1071

What is the use of nvl function?

1198

How many types of privileges are available in sql?

1350

What is the difference between clustered and non-clustered indexes?

1093

Un-Answered Questions { Databases }

What is cold data?

964

Does view occupy space?

947

How to fetch alternate records from a table?

1244

What is 2NF?

841

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

2224

Who is the owner of mysql database?

1057

What parameters control copy latches?

594

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2160

What is a session in mysql?

971

Would you store your query in a ssrs report or a database server? State the reason why?

152

State and explain the different types of data models?

944

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2009

What is the difference between execution of triggers and stored procedures?

1116

What is sql injection and why is it a problem? : sql server security

1133

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1224

For More Un-Answered { Databases } Questions Click Here