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 is the maximum size of the page ?

2 7237

Which of the packaged procedure is UNRESTRICTED ?

1 5639

What is SQL FORMS ?

CCIL,

1 4359

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

1 4064

What is a trigger?

3 6202

Explain ERASE packaged procedure ?

1 3616

when All datafiles related to a Tablespace are removed ?

1946

How the size of the table space can be increased?

1 5115

when A set of Dictionary tables are created ?

2 14865

What is a DATABLOCK ?

2 4779

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

2 5026

where a Database Procedure is stored ?

1 4575

What is Dedicated server configuration ?

2 4474

Which factors does not affect the size of the SGA ?

TCS,

3 10002

What does a COMMIT statement do to a CURSOR?

Microsoft, Oracle,

1 22377

Un-Answered Questions { Databases }

What is pg_catalog in postgres?

968

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2398

what are date and time data types? : Sql dba

1028

What does REVERT do in SQL Server 2005?

1013

Can I install mysql on mac?

1031

What is a table in oracle?

1024

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

1045

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1034

How to check if microsoft access database engine 2010 redistributable is installed?

917

How to create trigger in mysql phpmyadmin?

1186

How to start sql server browser service?

1183

What do you mean by sga and how is it different from pga?

Explain the the update statement in sql?

1106

What are the acid properties?

1059

What is the purpose of -> in the mysql terminal?

1175

For More Un-Answered { Databases } Questions Click Here