What are the operating modes in which database mirroring runs? : sql server DBA
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
which background process will run @ the time of creation of catalog database
What is the difference between dropping a database and taking a database offline? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Describe what redo logs are.
When creating a user, what permissions must you grant to allow them to connect to the database?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What authentication modes does sql server support? : sql server DBA
You have just compiled a PL/SQL package but got errors, how would you view the errors?