Where in the Oracle directory tree structure are audit
traces placed?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How would you force a log switch?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what is the difference between hot backup n rman backup?
What is the default port no on which sql server listens? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what are the types of connection load-balancing?
What would you use to improve performance on an insert statement that places millions of rows into that table?
How do you resize a data file?
What are the commands used in dcl? : sql server DBA