Give two methods you could use to determine what DDL changes
have been made.
Answers were Sorted based on User's Feedback
Answer / santo
DDL statements will be recorded in Alert log files?
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / monal
IN SQL 2005:
YOU CAN CREATE DDL TRIGGER TO TRACK CHANGES MADE WITH DDL
STATEMENTS.
| Is This Answer Correct ? | 5 Yes | 4 No |
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?
any body know about orawaves do they really provide placements in their unique placement program
what is logical system in sap basis
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
why Datapump is faster than traditional export and import
What happens on checkpoint? : sql server DBA
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What are the steps you will take, if you are tasked with securing an SQL Server?
What column differentiates the V$ views to the GV$ views and how?
how will you see when the database was started using sql prompt?
what do you understand by flashback feature of oracle?
Can you redefine a table online?
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)