database oracle 5 questions, computer science homework help

in /by

database oracle 5 questions, computer science homework help

  1. An Oracle package contains 2 stored procedures and 1 function. When the function is called for the first time, the whole package (procedures and function) is loaded into memory.

True

False

Question 2

  1. Common row oriented storage is ideal for DML functions (like inserts) but are usually less efficient than column oriented storage when retrieving only a few columns on a large data set.

True

False

Question 3

  1. What is the function of the Global System Catalog in a DDBMS?

Question 4

  1. Explain why splitting a large heavily used table across devices on separate physical disks can improve performance.

Question 5

  1. In an Oracle database with standard configuration, if transaction T1 is reading a row of data, and transaction T2 wants to read the entire table (the table that includes the row T1 is reading), T2 waits.

True

False

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper