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

What is the maximum size of the page ?

2 7139

Which of the packaged procedure is UNRESTRICTED ?

1 5587

What is SQL FORMS ?

CCIL,

1 4302

Name the two files that are created when you generate a form ?

1 4009

What is a trigger?

3 6077

Explain ERASE packaged procedure ?

1 3556

when All datafiles related to a Tablespace are removed ?

1910

How the size of the table space can be increased?

1 5051

when A set of Dictionary tables are created ?

2 14772

What is a DATABLOCK ?

2 4704

Can A column defined as PRIMARY KEY can have NULL values ?

2 4956

where a Database Procedure is stored ?

1 4505

What is Dedicated server configuration ?

2 4384

Which factors does not affect the size of the SGA ?

TCS,

3 9913

What does a COMMIT statement do to a CURSOR?

Microsoft, Oracle,

1 22312

Un-Answered Questions { Databases }

Explain the use of control file?

1126

how do you tune the slow running queries in oracle db , explain the methodology

2873

What is log ldf?

1001

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2279

How do I manually uninstall oracle client?

1101

Is mongodb a language?

How do you know if sql server is running on your local system?

1057

Explain the index key?

803

What is the use of “join” in sql server?

1115

What is t sql used for?

1028

What is ole activation style property?

What is it unwise to create wide clustered index keys?

1023

List out some of the requirements to set up a sql server failover cluster?

1042

Are semicolons required at the end of sql statements in sql server 2005?

1007

How to convert times to characters in oracle?

1043

For More Un-Answered { Databases } Questions Click Here