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

Can the SNAPSHOTS be refreshed automatically ?

1 4001

Can the User set Archive file name formats ?

1 5952

Which parameters are optional in init.ora parameter file?

2158

What is the use of NOARCHIEVELOG parameter in Database?

1 5363

Are Constraints exported through Export command?

1 4657

How the status of the Rollback segment can be viewed ?

1 4604

Can we assign Explicitly transaction to a rollback segment

1 4783

What file is read by ODBC to load drivers ?

Oracle,

1 9438

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 179065

How do you start and stop MySQL on Windows?

3 7552

How do you start MySQL on Linux?

3 6922

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36051

What?s the default port for MySQL Server?

Yahoo,

4 9662

What does tee command do in MySQL?

1 9037

Can you save your connection settings to a conf file?

1 4650

Un-Answered Questions { Databases }

Explain about SQLOS?

955

How to run sql commands in sql*plus?

1097

Why is a primary key important?

973

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

982

What is the purpose of a secondary key?

908

What are the purposes of floor and sign functions?

934

How many types of auditing in Oracle?

986

What do you understand by hotfixes and patches in sql server?

919

How to run the anonymous block again?

1072

What are different types of tables in sql?

943

Query to retrieve record for a many to many relationship ?

2463

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1996

Can you edit the .rdl code associated with a linked report?

153

Does mysql support nosql?

855

How to use subqueries with the exists operator in oracle?

976

For More Un-Answered { Databases } Questions Click Here