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 ?

1855

How the size of the table space can be increased?

1 4925

when A set of Dictionary tables are created ?

2 14597

What is a DATABLOCK ?

2 4556

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

2 4811

where a Database Procedure is stored ?

1 4387

What is Dedicated server configuration ?

2 4217

Which factors does not affect the size of the SGA ?

TCS,

3 9717

What does a COMMIT statement do to a CURSOR?

Microsoft, Oracle,

1 22174

Explain what is an Exception ?

1 3525

Explain about User_Defined Exceptions?

1 3428

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

CTS,

1 9687

Is it possible to use Transactional control statements in Database ?

2 4987

Is it possible to Enable or Disable a Database trigger ?

1 3962

PL/SQL supports which datatypes?

2 4898

Post New Database Management Questions

Un-Answered Questions { Database Management }

What is the difference between internal and external schema?

850

What are some disadvantages of a standard language such as sql?

843

Describe a subquery.

972

Which two can be implemented as a centrally located logical architecture?

882

Define b-trees.

850

What is tuple in rdbms?

1019

What the default privileges which get assigned ?

881

Explain the concept of acid properties in dbms?

1042

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1851

Enlist some commands of dcl?

885

What is rdms?

886

What is progress apama?

977

How to create a database from my program?

1033

What is difference between database and dbms?

923

What is db dialect?

964

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