Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what are the benefits of flashback feature?
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?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
A 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?
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 do you find out from the RMAN catalog if a particular archive log has been backed-up?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Name three advisory statistics you can collect.
what is the use of ocr?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How would you go about verifying the network name that the local_listener is currently using?
What is dbcc? : sql server DBA