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

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

Infosys,

1742

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

 1488

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

 1 3624

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.

 1496

Explain how you would restore a database using RMAN to Point in Time?

 1 5933

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 3619

Which environment variables are absolutely critical in order to run the OUI?

 2 3496

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

 3 5310

Why does Oracle not permit the use of PCTUSED with indexes?

 2315

What would you use to improve performance on an insert statement that places millions of rows into that table?

TCS,

2 5167

What would you do with an "in-doubt" distributed transaction?

 1411

What are the commands you'd issue to show the explain plan for "select * from dual"?

 1720

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

 1937

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

 1 2583

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

 1 2782

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Where do you find the default index fill factor and how to change it? : sql server DBA

544

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

644

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1937

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

603

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

1628




Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

571

What is the default port no on which sql server listens? : sql server DBA

549

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2093

how to restore files with rman?

1738

how can you process messages in order asynchronously?

549

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

648

Query processing is slow(eg select query)how will u solve that

6485

who owns the operating system files created by the utl_file package?

553

What purpose does the model database server? : sql server DBA

615

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

1514

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