Give two methods you could use to determine what DDL changes
have been made.
Answer Posted / santo
DDL statements will be recorded in Alert log files?
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Why does Oracle not permit the use of PCTUSED with indexes?
what is logical system in sap basis
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between dropping a database and taking a database offline? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what are the differences of where and if in SAS?
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 can you create a user-defined lock?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is the diffrence between core dba and apps dba?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).