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 4124

Can the User set Archive file name formats ?

1 6070

Which parameters are optional in init.ora parameter file?

2215

What is the use of NOARCHIEVELOG parameter in Database?

1 5458

Are Constraints exported through Export command?

1 4772

How the status of the Rollback segment can be viewed ?

1 4708

Can we assign Explicitly transaction to a rollback segment

1 4869

What file is read by ODBC to load drivers ?

Oracle,

1 9545

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 182018

How do you start and stop MySQL on Windows?

3 7751

How do you start MySQL on Linux?

3 7111

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36465

What?s the default port for MySQL Server?

Yahoo,

4 9857

What does tee command do in MySQL?

1 9149

Can you save your connection settings to a conf file?

1 4728

Un-Answered Questions { Databases }

At what levels can data validation be done in microsoft access database?

1035

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1080

Which function is used to find the largest integer less than or equal to aspecific value?

565

How to produce such kind of file?

1107

What is %s in sql?

1032

Why do we use partitions in sql?

1055

Does postgres support json?

864

What is crud in mongodb?

Does google have something like access?

828

What are the Advantages of using CTE in sql server?

1119

What do you know about normalization and de- normalization?

931

Define join and name different types of joins?

1008

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1256

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

576

What is cursor and its types?

1076

For More Un-Answered { Databases } Questions Click Here