DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Administration Interview Questions

Questions Answers Views Company eMail

how do see how much space is used and free in a tablespace

Genpact,

2 7649

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

Genpact,

2 6573

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 3874

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2419

what is logical system in sap basis

1587

what do you understand by flashback feature of oracle?

Oracle,

953

what is a crs resource?

Oracle,

1124

how can you implement fine-grained auditing?

Oracle,

1075

what do you understand by fine-grained auditing?

Oracle,

1022

what is a user-defined lock?

Oracle,

998

how can you process messages in order asynchronously?

Oracle,

940

how can you record information about current session?

Oracle,

990

what is asm?

Oracle,

1005

how can you schedule a job in database?

Oracle,

1055

how can you generate profile of pl/sql applications to identify performance bottlenecks?

Oracle,

1030

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1090

Where would you look for errors from the database engine?

2803

What is transparent data encryption? : sql server DBA

1131

How do you open a cluster administrator? : sql server DBA

1043

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

7779

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

2450

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.

1674

What is fill factor? : sql server DBA

1187

what is grd?

1054

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2627

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1923

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

1036

How would you go about verifying the network name that the local_listener is currently using?

3167

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2375

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

4302

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