1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
DB Administration Interview Questions
Questions Answers Views Company eMail

How do you switch from an init.ora file to a spfile?

TCS,

4 18285

Explain the difference between a data block, an extent and a segment.

 2 9763

Give two examples of how you might determine the structure of the table DEPT.

 2 10519

Where would you look for errors from the database engine?

IBM,

2356

Compare and contrast TRUNCATE and DELETE for a table.

 7 13719

Give the reasoning behind using an index.

 2 7664

Give the two types of tables involved in producing a star schema and the type of data theyhold.

 2 6636

What type of index should you use on a fact table?

 1 3277

Give two examples of referential integrity constraints.

 2 7582

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

 2004

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

 5 22407

What command would you use to create a backup control file?

 2 4230

Give the stages of instance startup to a usable state where normal users may access it.

 1 2706

What column differentiates the V$ views to the GV$ views and how?

 3 9073

How would you go about generating an EXPLAIN plan?

 2 7056

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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?

2180

what is the diffrence between core dba and apps dba?

2094

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1239

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1848

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2395




how can you schedule a job in database?

603

what functionality does oracle provide to secure sensitive information?

558

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

1968

Which autogrowth database setting is good? : sql server DBA

581

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

711

What is dbcc? : sql server DBA

779

What is the difference between clustered and non-clustered index? : sql server DBA

549

How do you open a cluster administrator? : sql server DBA

581

how can you process messages in order asynchronously?

557

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2037

For More Un-Answered { DB Administration } Questions Click Here