Give the two types of tables involved in producing a star schema and the type of data theyhold.
2 7606A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
2489Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
5 24427Post New DB Administration Questions
What are the different types of indexes available in sql server? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
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?
What is the default port no on which sql server listens? : sql server DBA
What happens on checkpoint? : sql server DBA
What is the importance of a recovery model? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you process messages in order asynchronously?
What are the recovery models for a database? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
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.