DataBase Administrator (DBA) Interview Questions and Answers
(Continued from previous part...)
279. What are Most Common types of Complex master-detail relationships?
There are three most common types of complex master-detail relationships: master with dependent details master with independent details detail with two masters
280. What is a text list?
The text list style list item appears as a rectangular box which displays the fixed number of values. When the text list contains values that can not be displayed, a vertical scroll bar appears, allowing the operator to view and select values that are not displayed.
281. What is term?
The term is terminal definition file that describes the terminal form which you are using r20run.
282. What is use of term?
The term file which key is correspond to which oracle report functions.
283. What is pop list?
The pop list style list item appears initially as a single field (similar to a text item field). When the operator selects the list icon, a list of available choices appears.
284. What is the maximum no of chars the parameter can store?
The maximum no of chars the parameter can store is only valid for char parameters, which can be up to 64K. No parameters default to 23 Bytes and Date parameter default to 7 Bytes.
285. What are the default extensions of the files created by library module?
The default file extensions indicate the library module type and storage format .pll - pl/sql library module binary
286. What are the Coordination Properties in a Master-Detail relationship?
The coordination properties are Deferred Auto-Query These Properties determine when the population phase of block coordination should occur.
287. What is an index and How it is implemented in Oracle database?
INDEX is a one which provides quick access to a row.
(Continued on next part...)