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 4007

Can the User set Archive file name formats ?

1 5958

Which parameters are optional in init.ora parameter file?

2159

What is the use of NOARCHIEVELOG parameter in Database?

1 5365

Are Constraints exported through Export command?

1 4665

How the status of the Rollback segment can be viewed ?

1 4611

Can we assign Explicitly transaction to a rollback segment

1 4786

What file is read by ODBC to load drivers ?

Oracle,

1 9441

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 179215

How do you start and stop MySQL on Windows?

3 7563

How do you start MySQL on Linux?

3 6935

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 36084

What?s the default port for MySQL Server?

Yahoo,

4 9683

What does tee command do in MySQL?

1 9046

Can you save your connection settings to a conf file?

1 4657

Un-Answered Questions { Databases }

Explain how dts is used to extract, transform and consolidate data?

950

What is oracle archived redo log?

550

How to upsert (update or insert into a table)?

963

Does mysql need a server?

866

What are slow queries?

859

How to call a stored function with parameters?

979

What is a join in sql?

1032

What are the parts of microsoft access?

852

What are key constraints?

935

How can you hide the sql server instances?

979

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

566

How many rows mysql can handle?

891

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

589

How do I change the order of columns in postgresql?

837

How do I keep my database up to date?

884

For More Un-Answered { Databases } Questions Click Here