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 go about verifying the network name that the local_listener is currently using?
what is a crs resource?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Why would you call update statistics? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you get actual data change values from previous transactions in oracle?
What are the different types of indexes available in sql server? : sql server DBA
what is the use of ocr?
how does an oracle clusterware manage crs resources?
What is the default port no on which sql server listens? : sql server DBA
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 the different topologies in which replication can be configured? : sql server DBA
Where would you look for errors from the database engine?
when does an alert gets signaled?