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

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1084

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1088

how to run 'mysql' commands from a batch file? : Sql dba

1139

what are the differences between char and nchar? : Sql dba

1129

when is the use of update_statistics command? : Sql dba

1071

what are the differences between char and varchar? : Sql dba

1091

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1091

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

970

what are different types of collation sensitivity? : Sql dba

1087

what is a constraint? : Sql dba

1199

what are the different type of sql's statements ? : Sql dba

937

explain advantages of innodb over myisam. : Sql dba

1150

how to create a new table in mysql? : Sql dba

1009

how to concatenate two character strings? : Sql dba

1128

what is the difference between primary key and unique key? : Sql dba

1052

Un-Answered Questions { Databases }

What skills should a dba have?

595

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2953

How does the report manager work in SSRS?

154

What is a dba certification?

608

What is pg_toast?

828

What is the difference between view and stored procedure?

976

Which database stores information about replication?

1087

What are different types of schemas?

965

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2082

What are the benefits and tasks of object explorer? : sql server management studio

1214

How do we use % when performing a search query?

932

What are properties of the transaction?

1018

How to execute stored procedure in select statement sql server?

1081

What are SSL and TSL protocols?

1015

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7715

For More Un-Answered { Databases } Questions Click Here