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 18212

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

 2 9719

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

 2 10471

Where would you look for errors from the database engine?

IBM,

2340

Compare and contrast TRUNCATE and DELETE for a table.

 7 13654

Give the reasoning behind using an index.

 2 7631

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

 2 6604

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

 1 3255

Give two examples of referential integrity constraints.

 2 7552

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?

 1987

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

 5 22347

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

 2 4201

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

 1 2672

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

 3 9021

How would you go about generating an EXPLAIN plan?

 2 7025

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What are the different types of indexes available in sql server? : sql server DBA

566

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3787

how can you record information about current session?

483

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

641

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

532




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

585

how can you connect from 10g user to 11g user??

1674

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3925

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

1709

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

590

Explain about your sql server dba experience? : sql server DBA

535

How would you extract DDL of a table without using a GUI tool?

2037

How to start SQL Server in minimal configuration mode?

6917

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1823

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1510

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