When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
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 what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the commands used in dcl? : sql server DBA
by issuing "alter tablespace begin backup;" what happens to tablespace?
How do you resize a data file?
What are statistics, under what circumstances they go out of date, how do you update them?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
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?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?