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 18257

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

 2 9744

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

 2 10498

Where would you look for errors from the database engine?

IBM,

2354

Compare and contrast TRUNCATE and DELETE for a table.

 7 13692

Give the reasoning behind using an index.

 2 7654

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

 2 6621

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

 1 3271

Give two examples of referential integrity constraints.

 2 7573

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?

 1998

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

 5 22375

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

 2 4216

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

 1 2696

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

 3 9055

How would you go about generating an EXPLAIN plan?

 2 7046

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What types of replication are supported in sql server? : sql server DBA

598

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

581

how can you schedule a job in database?

597

what are the benefits of flashback feature?

590

what is the role of dip user in our database?

2049




. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1979

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1336

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1545

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

1724

how can you enable flashback feature?

536

What the different topologies in which replication can be configured? : sql server DBA

657

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?

1998

What are the different ways you can create databases in sql server? : sql server DBA

599

how can you implement fine-grained auditing?

605

how does an oracle clusterware manage crs resources?

569

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