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
Explain about your sql server dba experience? : sql server DBA
Query processing is slow(eg select query)how will u solve that
What is a correlated sub-query? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the commands used in dcl? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what is a crs resource?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How would you extract DDL of a table without using a GUI tool?
What are statistics, under what circumstances they go out of date, how do you update them?
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 is fill factor? : sql server DBA
how can you communicate with operating system files from oracle?
What is the default fill factor value? : sql server DBA