Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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,

2282

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

1976

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

1 4347

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.

1994

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

1 6707

How does Oracle guarantee data integrity of data changes?

SoftSol,

1 4359

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

2 4408

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

3 6579

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

2942

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

TCS,

2 6205

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

1887

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

2230

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

2440

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 3384

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

1 3513


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

how can you find out if a table can be redefined?

1014


What is the importance of a recovery model? : sql server DBA

1028


What is a system database and what is a user database? : sql server DBA

1231


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

4349


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2153


What are statistics, under what circumstances they go out of date, how do you update them?

2251


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

1089


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

1975


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

4427


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2113


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1046


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

1111


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

2549


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

1082


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

1205