Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3239)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3312)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1391)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Mention the 3 ways to get a count of the number of records in a table.

549

Mention a few common trace flags used with sql server?

540

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

518

What do you understand by coalesce in sql server?

493

What do you understand by mirroring and mention the advantages of the mirroring?

575

Mention the differences between local and global temporary tables.

560

What do you understand by check constraint in sql server?

476

What is the tcp/ip port on which sql server runs?

561

What do you understand by intent locks?

571

Explain log shipping and mention its advantages.

589

Explain log shipping?

579

What do you understand by the analysis services in sql server?

532

What are the steps you must follow to hide sql server instances?

536

What are the advantages of mirroring?

566

What do you understand by user-defined function in the sql server?

484

Un-Answered Questions { Databases }

What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

521

What is difference between createstatement and preparedstatement?

536

What is the stuff?

523

How can i Relate Tables in SSIS

573

What is the fastest way to permanently delete a 1 million row table named customers?

597

What is structural independence and why is it important?

542

How do I know if localdb is running?

507

How to retrieve error messages using mssql_get_last_message()?

525

Explain about query and reporting.

1682

What is primary key in db?

515

Tell me what is de-normalization and what are some of the examples of it?

563

How do I start postgresql in linux?

430

Can we rollback after truncate?

557

What is pl sql record in oracle?

563

What is data control language (dcl)?

598

For More Un-Answered { Databases } Questions Click Here