Name three advisory statistics you can collect.
Answer / chowdary
Buffer Cache Advice, Segment Level Statistics and Timed
Statistics
| Is This Answer Correct ? | 4 Yes | 0 No |
how can you record information about current session?
how can you process messages in order asynchronously?
How do you open a cluster administrator? : sql server DBA
Explain the concept of the DUAL table.
What is fill factor? : sql server DBA
What are the steps you will take, if you are tasked with securing an SQL Server?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the different sql server versions you have worked on? : sql server DBA
I lost one datafile i dont have backup how can you recover that???
What would you use to improve performance on an insert statement that places millions of rows into that table?
what is the use of recording information about current session?
Oracle (3253)
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)