DBA > Interview Resource

DataBase Administrator (DBA) Interview Questions and Answers

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51 

(Continued from previous part...)

298. What is strip sources generate options?

Removes the source code from the library file and generates a library files that contains only pcode. The resulting file can be used for final deployment, but can not be subsequently edited in the designer.ex. f45gen module=old_lib.pll userid=scott/tiger strip_source YES output_file


299. What is the basic data structure that is required for creating an LOV?

Record Group.


300. What is the Maximum allowed length of Record group Column?

Record group column names cannot exceed 30 characters.


301. Which parameter can be used to set read level consistency across multiple queries?

Read only


302. What are the different types of Record Groups?

Query Record Groups NonQuery Record Groups State Record Groups


303. From which designation is it preferred to send the output to the printed?

Previewer


304. what are difference between post database commit and post-form commit?

Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.


305. What are the different display styles of list items?

Pop_list Text_list Combo box


306. Which of the above methods is the faster method?

performing the calculation in the query is faster.


307. With which function of summary item is the compute at options required?

percentage of total functions.

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  46  47  48  49  50  51