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 4114

Can the User set Archive file name formats ?

1 6066

Which parameters are optional in init.ora parameter file?

2211

What is the use of NOARCHIEVELOG parameter in Database?

1 5453

Are Constraints exported through Export command?

1 4766

How the status of the Rollback segment can be viewed ?

1 4706

Can we assign Explicitly transaction to a rollback segment

1 4862

What file is read by ODBC to load drivers ?

Oracle,

1 9543

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 181886

How do you start and stop MySQL on Windows?

3 7745

How do you start MySQL on Linux?

3 7097

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36444

What?s the default port for MySQL Server?

Yahoo,

4 9852

What does tee command do in MySQL?

1 9143

Can you save your connection settings to a conf file?

1 4728

Un-Answered Questions { Databases }

What are drillthrough reports?

155

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2221

How do I configure identities in sybase?

859

What does <> sql mean?

1089

How to list all indexes in mongodb?

How to export data to a csv file?

1304

What happens if null values are involved in boolean operations?

987

Explain various On-Delete options in a DB table. Which is the default option?

1466

Explain table and field in sql?

1062

How is rman better than user-managed backup recovery process?

What is merge statement used for?

1024

Explain having clause?

965

What is bcp? When does it used?

976

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2493

what are bind variables?

1087

For More Un-Answered { Databases } Questions Click Here