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 7119

Which of the packaged procedure is UNRESTRICTED ?

1 5570

What is SQL FORMS ?

CCIL,

1 4293

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

1 3993

What is a trigger?

3 6058

Explain ERASE packaged procedure ?

1 3540

when All datafiles related to a Tablespace are removed ?

1897

How the size of the table space can be increased?

1 5033

when A set of Dictionary tables are created ?

2 14752

What is a DATABLOCK ?

2 4689

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

2 4944

where a Database Procedure is stored ?

1 4493

What is Dedicated server configuration ?

2 4366

Which factors does not affect the size of the SGA ?

TCS,

3 9893

What does a COMMIT statement do to a CURSOR?

Microsoft, Oracle,

1 22300

Un-Answered Questions { Databases }

How do I run a pl sql program?

1133

Does aws have mongodb?

How is data stored in dbms?

965

What is the chart in report?

161

What is dbms_output put_line?

912

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?

2081

How do you open tables in pgadmin?

809

What are sql data types?

1034

What is join view in sql?

949

Can I concurrently access a firebird database with embedded and with regular server?

943

How do I set user privileges in mysql?

890

Is primary key auto increment?

951

What is a .db file?

992

what does it mean to have quoted_identifier on? : Sql dba

1147

How big is google's database?

920

For More Un-Answered { Databases } Questions Click Here