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 to set a database state to offline in ms sql server?

1055

How to list all triggers in the database with sys.triggers in ms sql server?

1098

How to verify a user name with sqlcmd tool?

1092

How to use go command in "sqlcmd"?

1219

How to enter comments in transact-sql statements?

954

How to loop through result set objects using mssql_fetch_array()?

1096

How to use user defined functions in expressions?

1112

How to use group functions in the select clause in ms sql server?

1072

How to list all dsn entries on your local machine using odbc_data_source()?

1050

How to count rows with the count(*) function in ms sql server?

1029

What happens if the update subquery returns multiple rows in ms sql server?

1136

What happens if the update subquery returns no rows in ms sql server?

1134

How to change the name of a database user?

972

What is the security principal at the database level that represents your session?

952

How to loop through result set objects using odbc_fetch_row()?

997

Un-Answered Questions { Databases }

What is second normal form?

937

What is the difference function and stored procedure?

1072

What is a candidate key in dbms?

1085

Can mysql scale horizontally?

998

what is cte? : Mysql dba

954

Can you explain various data region available in ssrs with their use?

991

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

1096

What is composite data type in pl sql?

1126

By using Macromedia Director How to fetch the data from Microsoft Excel?

2252

What are the different column comparison operators in mysql?

957

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1096

Explain triggers in sql?

963

What is a directory object?

1106

What is the drawbacks of normalization?

977

Can we rollback delete command?

1003

For More Un-Answered { Databases } Questions Click Here