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

Can the SNAPSHOTS be refreshed automatically ?

1 4211

Can the User set Archive file name formats ?

1 6150

Which parameters are optional in init.ora parameter file?

2275

What is the use of NOARCHIEVELOG parameter in Database?

1 5534

Are Constraints exported through Export command?

1 4863

How the status of the Rollback segment can be viewed ?

1 4786

Can we assign Explicitly transaction to a rollback segment

1 4937

What file is read by ODBC to load drivers ?

Oracle,

1 9610

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 184598

How do you start and stop MySQL on Windows?

3 7858

How do you start MySQL on Linux?

3 7230

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36791

What?s the default port for MySQL Server?

Yahoo,

4 10023

What does tee command do in MySQL?

1 9228

Can you save your connection settings to a conf file?

1 4794

Un-Answered Questions { Databases }

Can we write ddl in trigger?

970

what are all the different normalizations? : Sql dba

1120

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

What are the disadvantage in file processing system?

1024

What is a derived table?

992

Why is normalisation important?

989

How do I create a sql script?

1142

In which language mysql has been written?

1391

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1194

What is mutating table error?

1240

How do I start a pgadmin server?

910

What is the syntax for encrypting a column in SQL Server?

1175

Is sql easier than java?

1069

what does the t-sql command ident_current does? : Transact sql

1048

What happens when shared and exclusive locks are applied on data item?

1087

For More Un-Answered { Databases } Questions Click Here