Database True or False questions: 1- In an Oracle database with standard configu

Question

Database True or False questions:

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. (T/F)

2- Common row oriented storage is ideal for DML (Data Manipulation Language) functions (like inserts) but are usually less efficient than column oriented storage when retrieving only a few columns on a large data set. (T/F)

3- 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. (T/F)

Explanation / Answer

1) No as per transaction level read consistency T2 need not to wait for T1 , as both are just read operations and there are no write operation in T1.

2) Yes row oriented storage are less efficient when we requirement is just to retrieve value of few colums and data set is very large as if we go for row oriented method it will get values of all colums which are not even required and take extra time.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.