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
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is the diffrence between core dba and apps dba?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Which autogrowth database setting is good? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is asm?
Where would you look for errors from the database engine?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are the recovery models for a database? : sql server DBA
Can you redefine a table online?
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?
What is the difference between clustered and non-clustered index? : sql server DBA
