Name two files used for network connection to a database.
Answers were Sorted based on User's Feedback
by issuing "alter tablespace begin backup;" what happens to tablespace?
how can you enable flashback feature?
What is a correlated sub-query? : sql server DBA
When a user process fails, what background process cleans up after it?
What are the steps you will take to improve performance of a poor performing query?
What are the recovery models for a database? : 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
How can we know the exact updation date of a particular database?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
What are the different ways you can create databases in sql server? : sql server DBA
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
What is transparent data encryption? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)