Set - 3

Question 36 :

What are the built-ins used for finding Object ID function?

Answer :

FIND_GROUP(function)
FIND_COLUMN(function)


Question 37 :

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Answer :

False


Question 38 :

Use the Add_group_row procedure to add a row to a static record group 1. true or false?

Answer :

False


Question 39 :

What third party tools can be used with Oracle EBU/ RMAN? (for DBA)

Answer :

The following Media Management Software Vendors have integrated their media management software packages with Oracle Recovery Manager and Oracle7 Enterprise Backup Utility. The Media Management Vendors will provide first line technical support for the integrated backup/recover solutions.
Veritas NetBackup
EMC Data Manager (EDM)
HP OMNIBack II
IBM's Tivoli Storage Manager - formerly ADSM
Legato Networker
ManageIT Backup and Recovery
Sterling Software's SAMS:Alexandria - formerly from Spectralogic
Sun Solstice Backup


Question 40 :

Why and when should one tune? (for DBA)

Answer :

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons:
The speed of computing might be wasting valuable human time (users waiting for response); Enable your system to keep-up with the speed business is conducted; and Optimize hardware usage to save money (companies are spending millions on hardware). Although this FAQ is not overly concerned with hardware issues, one needs to remember than you cannot tune a Buick into a Ferrari.