Why would you use sql agent? : sql server DBA
Answer / Rahul G. Momin
SQL Agent is used in SQL Server to automate scheduled tasks such as database backups, job execution, and data movement. It provides a centralized platform for scheduling and monitoring these tasks, helping DBAs maintain the integrity of their databases.
| Is This Answer Correct ? | 0 Yes | 0 No |
You're getting high "busy buffer waits" - how can you find what's causing it?
How to make a replica of existing oracle server to another server?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What command would you use to encrypt a PL/SQL application?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
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?
Explain the use of table functions.
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you initialize log miner?
What are the recovery models for a database? : sql server DBA
What questions might be they ask in managerial round in capgemini.
deleted of control file how will u recover control file?
Oracle (3253)
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)