What are statistics, under what circumstances they go out of date, how do you update them?
what is the diffrence between core dba and apps dba?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is a correlated sub-query? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is a user-defined lock?
what are the benefits of flashback feature?
What the different components in replication and what is their use? : sql server DBA
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.
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Why would you use sql agent? : sql server DBA
What is dcl? : sql server DBA