DB Administration Interview Questions
Questions Answers Views Company eMail

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

Genpact,

2 7079

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 6023

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 3517

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

2137

what is logical system in sap basis

1339

what do you understand by flashback feature of oracle?

Oracle,

763

what is a crs resource?

Oracle,

837

how can you implement fine-grained auditing?

Oracle,

799

what do you understand by fine-grained auditing?

Oracle,

815

what is a user-defined lock?

Oracle,

753

how can you process messages in order asynchronously?

Oracle,

731

how can you record information about current session?

Oracle,

709

what is asm?

Oracle,

790

how can you schedule a job in database?

Oracle,

794

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

Oracle,

791


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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.

1714


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

776


What are the commands used in dcl? : sql server DBA

754


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

1944


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

4149


how can you communicate with operating system files from oracle?

764


Explain materialized views and how they are used.

2107


what do you understand by flashback feature of oracle?

763


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

1831


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

2946


How can you control the amount of free space in your index pages? : sql server DBA

968


What are the different sql server versions you have worked on? : sql server DBA

738


What are the different types of upgrades that can be performed in sql server? : sql server DBA

888


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

794


what is the diffrence between core dba and apps dba?

2299