Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

Oracle 11g new features?

2 Answers  


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  


Name two files used for network connection to a database.

5 Answers  


What the different components in replication and what is their use? : sql server DBA

0 Answers  


why we use cursors

1 Answers  






How would you extract DDL of a table without using a GUI tool?

0 Answers  


Hot backup procedure?

2 Answers  


What command would you use to encrypt a PL/SQL application?

1 Answers  


i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  


What is fill factor? : sql server DBA

0 Answers  


How would you go about verifying the network name that the local_listener is currently using?

0 Answers  


Categories