What are the different types of database compression introduced in sql server 2008? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
by issuing "alter tablespace begin backup;" what happens to tablespace?
What is blocking and how would you troubleshoot it?
What happens on checkpoint? : sql server DBA
Name three advisory statistics you can collect.
Explain how you would restore a database using RMAN to Point in Time?
How to determine the service pack currently installed on SQL Server?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the operating modes in which database mirroring runs? : sql server DBA
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
What type of index should you use on a fact table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)