Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
when does an alert gets signaled?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the recovery models for a database? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Which autogrowth database setting is good? : sql server DBA
what do you understand by flashback feature of oracle?
How do you trace the traffic hitting a sql server? : sql server DBA
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?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How can you control the amount of free space in your index pages? : sql server DBA
internal architecture
What are the different sql server versions you have worked on? : sql server DBA