DB Administration Interview Questions
Questions Answers Views Company eMail

what r the types of backup?

CSC,

5 5531

how will u see whether the dabase is in archive log mode or not?

CSC,

2 3406

by issuing "alter tablespace begin backup;" what happens to tablespace?

CSC, Logica CMG,

5 7541

which background process will run @ the time of creation of catalog database

CSC,

1 3776

What is the difference between Datapump & export/import?

2 10984

Can we take incremental backups in datapump?

1 10676

Datapump backup steps?

1 4401

How will u copy the objects of one schema to another schema in datapump & export/import?

1 4495

What is checkpoint?

Accenture,

3 4552

Oracle 11g new features?

2 10883

Hot backup procedure?

2 3976

If we issue alter database begin backup. What happens to database?

2 6256

deleted of control file how will u recover control file?

CTS,

4 7297

What is the difference between LMT & DLT?

CTS,

1 6635

why we use cursors

1 2927


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1227


What are the steps you will take to improve performance of a poor performing query?

2411


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

544


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

1638


what is logical system in sap basis

1124






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

593


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

567


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2221


What authentication modes does sql server support? : sql server DBA

688


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

550


what are the differences of where and if in SAS?

1656


what is the use of ocr?

588


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

605


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

591


Explain materialized views and how they are used.

1880