What is transparent data encryption? : sql server DBA
what is rebuild index??
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
Compare and contrast TRUNCATE and DELETE for a table.
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.
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
Explain what partitioning is and what its benefit is.
what is the difference between hot backup n rman backup?
What is the dataguard background process??
How many packages we have in db
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
How can you control the amount of free space in your index pages? : sql server DBA