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 will you optimize a stored procedure optimization?

1053

What are the disadvantages of using the stored procedures?

1119

Distinguish between commit and rollback?

968

Explain subquery and state its properties?

1055

What do you understand by a stored procedure?

1099

What is coalesce and check constraint in sql server?

1135

What are the purposes of floor and sign functions?

992

What is a virtual table in sql?

1008

Explain cdc and sql injection?

997

State the difference between local and global temporary tables?

1128

Explain cross join or cartesian product in sql?

898

What is sql server agent and what are the two modes of authentication in sql server?

1069

Explain tablesample?

1005

Differentiate between truncate vs delete in mssql?

1098

How are the exceptions handled in sql server programming?

1074

Un-Answered Questions { Databases }

What is sql basics?

1050

Which is better stored procedure or query?

971

How to find related tables in sql server?

960

What is the unique index?

1064

What are rest-style architecture's?

172

what are myisam tables? : Sql dba

1044

How to select all records from the table?

1156

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

584

When is functional dependency said to be the fully functional dependency?

1124

How do I set a primary key in access 2007?

789

What is the maximum limit on the number of columns in a table?

1100

How does using a separate hard drive for several database objects improves performance right away?

946

Explain atomicity?

1065

What is mysql common?

923

Where is the myisam table stored?

975

For More Un-Answered { Databases } Questions Click Here