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

Oracle (3253)
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

What are the factors causing the reparsing of SQL statements in SGA?

1 4497

how to dispaly a particular row details from a given table

2 6287

What is a transaction and what are ACID properties?

3 7918

Explain different isolation levels?

4 11060

What's the maximum size of a row?

IBM,

4 11936

Explain Active/Active and Active/Passive cluster configurations?

1 5019

Explain the architecture of SQL Server?

ABC, HP, Oracle,

2 37488

What is lock escalation?

1 7204

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 19402

Explain the storage models of OLAP?

1 7450

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

Accenture,

2414

What are constraints? Explain different types of constraints?

Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

26 140470

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

IBM,

1 4374

What are statistics, under what circumstances they go out of date, how do you update them?

2312

What is RAID and what are different types of RAID configurations?

1 5455

Un-Answered Questions { Databases }

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2746

Can we rename database in mysql?

1002

Why do we use %rowtype & %type in plsql?

1100

What is load plan and types of load plans in ODI?

673

How are the unique and primary key constraints different?

1129

What are built in functions?

1071

How do I change the max connections in mysql?

953

How can I see mysql database?

953

Is mongodb better than mysql?

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

982

State three differences between Dbms and Rdbms?

1121

What does truncate table do?

867

What is a static data dictionary in oracle?

1193

What is the contrast amongst drop and truncate?

1081

What is indexing in sql server with example?

1044

For More Un-Answered { Databases } Questions Click Here