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

Database Management Interview Questions

Questions Answers Views Company eMail

when All datafiles related to a Tablespace are removed ?

1896

How the size of the table space can be increased?

1 5024

when A set of Dictionary tables are created ?

2 14743

What is a DATABLOCK ?

2 4674

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

2 4935

where a Database Procedure is stored ?

1 4484

What is Dedicated server configuration ?

2 4353

Which factors does not affect the size of the SGA ?

TCS,

3 9884

What does a COMMIT statement do to a CURSOR?

Microsoft, Oracle,

1 22284

Explain what is an Exception ?

1 3625

Explain about User_Defined Exceptions?

1 3516

Is it possible to open a cursor which is in a Package in another database?

CTS,

1 9763

Is it possible to use Transactional control statements in Database ?

2 5110

Is it possible to Enable or Disable a Database trigger ?

1 4046

PL/SQL supports which datatypes?

2 5039

Post New Database Management Questions

Un-Answered Questions { Database Management }

Define b-trees.

908

How is the pattern matching done in the sql?

1160

What is openedge translation manager?

1075

What is dbms with example?

1032

How to retrive a single data from a database

1193

What are stand-alone procedures?

954

Explain a tp monitor?

968

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2121

Explain bcnf (boyce-codd normal form)?

1017

Is the server accepting tcp ip connections on port 5432?

889

What is the normal procedure followed by a java client to access the db?

823

Explain 3nf?

949

Which software is best for database?

883

What is environment of openedge?

917

State some commands of ddl in dbms?

1020

For More Un-Answered { Database Management } Questions Click Here