Sample Database Administration Interview Questions and Practice Test Questions for Oracle Database Administrator’s Job Test and Technical Interviews

What do you understand by a deadlock.

Explain a database instance.

Is it possible to reduce the Datafile size?

Where do we use lookup table?

What are the contents of a control file?

When a user is created in DBA, which datafile has the user?

Where do we use the redo log information?

Tell about a Schema.

What will be the result if you change the same tableand commit when a cursor is open on the table?

Define a segment.

What do you mean by clusters?

Explain the benefit of control file.

Explain the method to know all tables built by a user?

Can we simply disable the connection sys as sysdba?

What do you mean by a lookup table?

What do you understand by redo log?

What are the various types of table join.

Explain the method of table sorting.

Define an index. How will you implement an index in oracle database?

What do you mean by Data Block?

Explain the benefits of rollback segment.

Describe the various built-in functions which are used in SQL queries.

Explain the public and private database links.

List the various basic elements in oracle database for base configuration.

What do you know about Cluster Key?

What is a parallel server?

Information regarding implementation of locking.

Is a commit required after DDL Statements?

Explain the various features of data files.

Should we force an index after selecting most of the table entries?

Define cluster key.

Explain the various basic elements of Base configuration of an oracle database.

What do you understand by Parallel Server?

Explain the points of difference between Oracle and Database Administration.

Explain error or exception handling in case of stored procedures.

Describe the various types of database links.

What do you mean by database link?

Where is the hash cluster required?

What do you understand by a datafile?

Describe the DDL, DML.

Explain the various types of segments.

Explain the rule optimizations which are allowed in SQL query tuning.

Define an extent.

Explain row chaining.

Describe th network database link.

What method is used for definition of data block size?
What do you know about index cluster and where is it required?

Where are clusters used in oracle?

What do you know about index updates?

Define an oracle index.

Where do we use synonyms?

Is there any data contained in a oracle view?

Describe a Oracle table.

Explain the temporary segment.

Why do we need cursors?

Explain the various types of cursors.

What do you understand by rollback segment?

What do you understand by index segment?

Are there any objects from different schemes in a tablespace?

Is it possible to have objects of a schema in different tablespaces?

Describe the schema objects.

How are database, data file and tablespace related to each other?

When do we create a SYSTEM tablespace?

What is meant by tablespace?

Exlain the various components of logical database structure of oracle database.

Explain the various physical structure components of oracle database.

Is it possible to resize the redolog files?

Does a redolog file have anything after a table is deleted?

Explain the public and private synonyms. What is the difference between these?

Describe the various types of synonyms.

What do you know about oracle sequence?

What are various benefits of views?

What is the difference between buffer busy wait and free list?

What do you mean by ORA-1555?

Explain the difference between views, indexes and synonyms.

Describe a deadlock.