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

How free extents are managed in Ver 6.0 and Ver 7.0 ?

IBM,

1 5061

What are the advantages of VIEW?

5 34255

How many LONG columns are allowed in a table?

CTS,

6 24712

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 16899

Is it possible to access the current value in a session before accessing next value?

1 6529

What is Referential Integrity?

IBM,

3 13018

What are the data types allowed in a table?

3 7675

What is an Integrity Constraint?

4 9690

Explain Connect by Prior?

2 11927

What are the types of SQL Statement?

3 21031

What is a transaction?

5 9339

How to access the current value and next value from a sequence?

6 13254

What is CYCLE/NO CYCLE in a Sequence?

2 9997

What is a database link?

3 8723

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 14624

Un-Answered Questions { Databases }

Can an access database be used online?

897

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1287

When will data be on more than one shard?

Should I use pdo or mysqli?

912

What is a function in oracle pl sql?

1037

What is the format trigger?

What happens if variable names collide with table/column names?

1191

What is a behavioral trigger?

972

Is there a google equivalent to microsoft access?

809

How to call a stored function with parameters?

1042

Explain the purpose of %type and %rowtype data types with the example?

994

What is the purpose of the partition table?

1049

What is the return type of mysqli_query?

869

How do I rename a mysql database?

953

What do you think about pl/sql?

1029

For More Un-Answered { Databases } Questions Click Here