DB Administration Interview Questions
Questions Answers Views Company eMail

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

Genpact,

2 7092

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 6032

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 3532

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

2141

what is logical system in sap basis

1349

what do you understand by flashback feature of oracle?

Oracle,

766

what is a crs resource?

Oracle,

839

how can you implement fine-grained auditing?

Oracle,

801

what do you understand by fine-grained auditing?

Oracle,

821

what is a user-defined lock?

Oracle,

756

how can you process messages in order asynchronously?

Oracle,

731

how can you record information about current session?

Oracle,

712

what is asm?

Oracle,

793

how can you schedule a job in database?

Oracle,

797

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

Oracle,

792


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2223


What is fill factor? : sql server DBA

869


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.

1416


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

796


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

798


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

2401


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

2617


what are the differences of where and if in SAS?

1874


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

769


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.

1953


how can you connect from 10g user to 11g user??

1891


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

763


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

812


What are the operating modes in which database mirroring runs? : sql server DBA

840


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

766