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

How would you force a log switch?

 4 12005

Give two methods you could use to determine what DDL changes have been made.

 2 10605

What does coalescing a tablespace do?

 1 14609

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

 2 6058

Name a tablespace automatically created when you create a database.

 5 10547

When creating a user, what permissions must you grant to allow them to connect to the database?

 3 7639

How do you add a data file to a tablespace?

 3 6601

How do you resize a data file?

 2 13007

What view would you use to look at the size of a data file?

 3 7443

What view would you use to determine free space in a tablespace?

 3 8306

How would you determine who has added a row to a table?

 4 9688

How can you rebuild an index?

 6 11683

Explain what partitioning is and what its benefit is.

 2 6372

You have just compiled a PL/SQL package but got errors, how would you view the errors?

 3 8370

How can you gather statistics on a table?

 3 16460

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is dbcc? : sql server DBA

779

how can a session indicate its interest in receiving alerts?

567

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

559

how can you get actual data change values from previous transactions in oracle?

619

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1643




Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1848

what is logical system in sap basis

1145

what is the use of recording information about current session?

574

what functionality does oracle provide to secure sensitive information?

559

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1509

what is ora 24313?what is the procedure to exclude that error?

2107

what is a user-defined lock?

590

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

575

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

1839

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1563

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