Answer Posted / suman
we have 8 packages in our database that is
1.procedures
2.triggers
3.tables
4.indexes
5.synonyms
6.views
Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
How would you best determine why your MVIEW couldn't FAST REFRESH?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you process messages in order asynchronously?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How can you control the amount of free space in your index pages? : sql server DBA
What is dbcc? : sql server DBA
What purpose does the model database server? : sql server DBA
what functionality does oracle provide to secure sensitive information?
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.
what is the use of recording information about current session?
Where would you look for errors from the database engine?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Why does Oracle not permit the use of PCTUSED with indexes?