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

How to set a database state to offline in ms sql server?

1109

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

1142

How to verify a user name with sqlcmd tool?

1124

How to use go command in "sqlcmd"?

1274

How to enter comments in transact-sql statements?

991

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

1146

How to use user defined functions in expressions?

1163

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

1127

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

1093

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

1067

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

1175

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

1184

How to change the name of a database user?

1016

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

997

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

1050

Un-Answered Questions { Databases }

What operating systems are supported by oracle database 10g xe?

1092

What happens when transaction log is full?

997

What are commit, rollback, and savepoint?

1051

What steps server process has to take to execute an update statement?

1022

Can we rollback truncate?

1055

What is difference between data and database?

1170

What is timestamp in mysql?

1054

Explain the uses of database trigger.

1180

What are packages in pl sql and also explain its advantages?

1125

Explain the index key?

843

How does rowid help in running a query faster?

1478

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1213

What is the use of oracle?

1082

What extended events?

1068

Can you move the resources after pausing the node? : sql server database administration

1171

For More Un-Answered { Databases } Questions Click Here