How do you troubleshoot errors in a sql server agent job? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
What's the benefit of "dbms_stats" over "analyze"?
What is blocking and how would you troubleshoot it?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
What is checkpoint?
how will you see when the database was started using sql prompt?
what is a user-defined lock?
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 does Oracle guarantee data integrity of data changes?
what is the use of ocr?
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 are the types of connection load-balancing?
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)