What is dbcc? : sql server DBA
mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What type of index should you use on a fact table?
what is rebuild index??
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How can you control the amount of free space in your index pages? : sql server DBA
what is the use of ocr?
How would you determine the time zone under which a database was operating?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
why Datapump is faster than traditional export and import
If we issue alter database begin backup. What happens to database?