Apex Tech

1. Which of the following objects hold the trigger definition of a databasetriggera. User_objectsb. User_sourcec. User_triggersd. User_tables
2. Which of the following is not an advantage of using packages
a. Modularityb. Information hidingc. Efficient storaged. Better performance
3. A packaged function can assert maximum purity levels by specifying one of the
following in PRAGMA_RESTRICT_REFERENCES
a. RNDS, RNPS, WNPSb. WNDS, RNDS, RNPSc. WNPS, RNDS, RNPSd. RNPS, RNDS, WNPS
4. Package P1 refers another package P2. The specification of P2 has beenchanged and compiled. P1 is not recompiled. What will happen if we try toexecute P1
a. The error is existing state of package is discardedb. The package P1 is automatically compiledc. The timestamp of package P2 has been changed
5. What built-in package should be used to schedule batch jobs automatically
a. DBMS_JOBb. DBMS_SQL_JOBc. DBMS_SCHEDULEd. DBMS_JOB_SCHEDULE
6. What should be added in the following trigger definition to make it insert arow in t2 table for every insertion in t1 table
CREATE OR REPLACE TRIGGER Test_TrigBEFORE INSERT ON T1BEGININSERT INTO T2 VALUES (:old.col1) ;END ;
a. for each rowb. for every rowc. for all rowsd. nothing needs to be added
7. How do you add a value to a Check constraint of a column
a. alter table t1 modify constraint con1 add value('M') ;b. alter table t1 modify con1 add value ('M') ;c. alter constraint con1 add value('M') ;d. It is not possible to add a value without dropping the existing constraint.
8. Which statement would you use to remove the EMP_NO_PK Primary key constraint
and all depending constraints from the EMP table
a. ALTER TABLE emp DROP PRIMARY KEY CASCADEb. ALTER TABLE emp DELETE PRIMARY KEY CASCADE.c. MODIFY TABLE emp DROP CONSTRAINT emp_no_pk CASCADE.D. ALTER TABLE emp DROP PRIMARY KEY emp_no_pk CASCADE.
9. Review the following SQL Statement and find errors if any .SQL> create table emp12 ( empno number(4) constraint emp_no_pk primary key,3 ename varchar2(30) not null,4 sal number(7,2),5 deptno number(2) references dept(deptno)6 )disable primary key
Note: Dept table already exists with deptno column as a primary Key.
a. Error in line 2b. Error in line 5c. Error in line 6d. No Error in the Statement . Executes successfully
10. What is the result of the query ?
SELECT * FROM EMP WHERE ROWNUM > 5
a. All the rows apart from the first 5 rows are displayedb. All rows are fetched from the tablec. SQL error will occur saying Invalid column named. No rows will be selected

11. How can you get a detail block name in a form which has a Master-Detailsblockusing relations
a. GET_BLOCK_PROPERTYb. GET_FORM_PROPERTYc. GET_RELATION_PROPERTYd. GET_RELATION_BLOCK_PROPERTYe. GET_APPLICATION_PROPERTY
12. What is the datatype used in forms to declare a canvas variable
a. Viewgroupb. Viewidc. Viewportd. Varchar2e. Canvas.
13. Which following package is used to load data into the table from the flatfiles
a. TOOLS_IOb. ORA_FFIc. DBMS_OUTPUTd. TEXT_IOe. UTIL_FILE
14. Consider the following trigger
CREATE OR REPLACE TRIGGER emp_countAFTER DELETE ON EMPFOR EACH ROWDECLAREN INTEGER ;BEGINSELECT COUNT(*) INTO n FROM EMP ;DBMS_OUTPUT.PUT_LINE('There are now ' n 'employees') ;END ;
What happens if the SQL statement is issued
DELETE FROM EMP WHERE EMPNO = 7499
a. Integrity constraint violated - Parent key not foundb. Table EMP is mutating trigger / function may not see itc. Cannot execute EMP from within stored procedured. No errors
15. Why does this statement fail when executed
CREATE OR REPLACE TRIGGER CALC_TEAM_AVGAFTER INSERT ON PLAYERBEGININSERT INTO PLAYER_BAT_STAT(PLAYER_ID, SEASON_YEAR, AT_BATS, HITS)VALUES(:NEW.ID, 1997, 0, 0) ;END ;
a. This is a row level trigger and therefore cannot reference :newb. This is a statement level trigger and therefore cannot reference :newc. This is a row level trigger and therefore cannot perform data manipulationstatementd. This is a statement level trigger and therefore cannot perform datamanipulation statements.

16. You have now created a view v1 on the table emp, now alter table emp and add
a column t, what will happen to the view
a. the new column t is not seen.b. the new column t is seen.c. view becomes invalidated.d. you cannot alter a table after the view is created.
17. You have a table emp, examine the following sql statement,
CREATE SEQUENCE EMP ;Will the above statement work.
a. Trueb. False
18. Which of the following cannot be defined in visual attribute
a. Font sizeb. Background colorc. Font Heightd. Font style


19. What is the advantage of having program units in a client side library
a. The library need not be recompiled in case any change is made to the programunitb. Modularityc. Easier accessd. All the abovee. None of the above
20. What is the order of firing of triggers written to a text item
a. KEY-NEXT-ITEM, WHEN-VALIDATE-ITEM, POST-TEXT-ITEMb. WHEN-VALIDATE-ITEM, KEY-NEXT-ITEM, POST-TEXT-ITEMc. POST-TEXT-ITEM, KEY-NEXT-ITEM, WHEN-VALIDATE-ITEMd. WHEN-VALIDATE-ITEM, POST-TEXT-ITEM, KEY-NEXT-ITEM
21. How will you determine the menu object's current value
a. Using COPY builtinb. Using Direct referencec. Using Name_In built ind. Using System variable
22. Which menu item type would you create with predefined functionality
a. Plainb. Checkc. Separatord. Magic
23. Choose the correct sequence of firing triggers given below
1. PRE_FORM2. WHEN_NEW_FORM_INSTANCE3. ON_LOGON4. WHEN_NEW_ITEM_INSTANCE
a. 2,1,3,4b. 2,1,4,3c. 1,2,3,4d. 1,2,4,3e. 3,1,2,4

24. When Modal is set to True, the one of the following property is ignored
a. Titleb. Window sizec. Window stated. Moveable
25. When editing a text item, how do you change the editor as WORDPAD?
a. In the property sheet of the text item change system editor toWordpad.b. Change FORMS45_EDITOR parameter in the oracle Environment.c. Using forms menu Tools -> Options -> Runtime Options.d. It is not possible to change the system editor.
26. Which built-in is used to find the user who has currently logged on to theapplication
a. Get_form_property()b. logon()c. Get_application_property()d. get_user()
27. You can pass parameter of a form when an application executes through
a. open_form, call_form, run_product, new_formb. open_form,go_form,call_form, new_form.c. open_form,call_form,go_form, new_form.
28. How do you refer a incremental value of sequence x in a form propertypalette ?
a. assign the default value as :sequence.x.nextvalb. assign the default value as :x.nextvalc. assign the default value as nextval.xd. assign the default value as x.nextvale. not possible
29. The Sales department requested a report to allow customers to enter a stocknumber and then display the number of items in inventory. You use an afterparameter form trigger to validate the stock number before the report executes.
If the trigger returns a false value what will happen ?
a. Execution of the report will halt.b. The customer will be returned to the parameter form.c. The report will execute but no data will be displayed.
30. You are developing a product report to list the name and the picture of allthe products in the PRODUCT table. The Layout of each item is a repeating framethat contains one fixed field and an image. You anchor the image to the namefield. Which pagination property should you select to keep the name field andthe image on the same logical page ?
a. Page protect on the image.b. Page protect on the name field.c. Keep with Anchoring Object property on the imaged. Keep with Anchoring Object property on the name field.
31. You need to execute the employee report in REPORTS Ver 2.5 from theOperating System in the batch mode. Which executable should You use toaccomplish this task?
a. R25RUNb. R25DESc. R25CONVd. R25MREP
32. After you retrieve the cause of a detail report failure using theSRW.GETERR_RUN function, which function or procedure will you use to display the
error on the screen?
a. SRW.BREAKb. SRW.MESSAGEc. SRW.PROGRAM_ABORTd. SRW.DISPLAY_ERROR
33. You create an inventory report using the master/detail group left layoutstyle. In the layout model editor, which setting should you use to ensure thatobjects within the master repeating frame can not be moved outside their parent?
a. Flex Mode onb. Flex Mode offc. Confine mode ond. Confine mode off
34. You are modifying the sales report and need to alter the default page widthsetting. In which window will you make the change to the report?
a. Layout Editorb. Tools Optionc. Object Navigatord. Reports Properties
35. You execute two reports . The first report id currently running. How couldyou delete the second report from the queue without terminating the firstreport?
a. Delete the report from the reports.log file.b. Select Actions -> Show Log in the reports server window.c. Select Actions -> Remove Job in the reports server window.d. Click the cancel report button on the reports progress dialog box.
36. Which built-in in a form calls another form in a new session
a. OPEN_FORMb. NEW_FORMc. CALL_FORMd. SESSION_FORMe. RUN_PRODUCT
37. Which database object called as the duplicate of the database objectsresiding in a remote place
a. Viewsb. Public Synonymsc. Snapshotsd. Aliasese. Clusters
38. What is the necessary condition to build a block (in forms) based on astored procedure
a. It should not have an order by clauseb. It should be a single record blockc. It is not possible to create a block based on a stored procedured. It should have atleast one OUT variable of type Pl/Sql table or REFCURSOR
39. What built-in package should be used to create tables dynamically
a. DBMS_SQLb. DBMS_DDLc. DBMS_PIPEd. DBMS_JOB


40. You used the TRUNCATE command on EMP table. Which two results are true ?
a. The TRUNCATE command can be rolled back.b. The EMP table definition still exists.c. The EMP table definition does not exixts.d. All EMP table constraints have been dropped.e. All EMP table constraints have been disabled.f. The storage space held by the EMP table was released. ..
set2
Oracle /Dev 2000 Test - 2.

1. A stored program unit needs to write its output to a text file. Which of thefollowing oracle packages can be used to accomplish this
a. DBMS_OUTPUTb. UTL_FILEc. TEXT_IOd. DBMS_PIPE
2. Procedures P1 and P2 call another stored procedure P3. If P3 is altered andcompiled what happens to procedures P1 & P2
a. P1 & P2 are still validb. P1 & P2 are marked invalid immediatelyc. P1 & P2 becomes invalid when they are first executed next timed. P1 & P2 become invalid when P3 is executed next time
3. What is the word which needs to be added to a database function to invoke itfrom SQL*Plus
a. PRAGMA_EXECPTION_INITb. PRAGMA_RESTRICT_REFERENCESc. PRAGMA_FUNCTION_INITd. PRAGMA_FUNCTION_REFERENCES
4. What is the necessary condition to build a block (in forms) based on a stored
procedure
a. It should not have an order by clauseb. It should be a single record blockc. It is not possible to create a block based on a stored procedured. It should have atleast one OUT variable of type Pl/Sql table or REFCURSOR
5. What built-in package should be used to create tables dynamically
a. DBMS_SQLb. DBMS_DDLc. DBMS_PIPEd. DBMS_JOB


6. You used the TRUNCATE command on EMP table. Which two results are true ?
a. The TRUNCATE command can be rolled back.b. The EMP table definition still exists.c. The EMP table definition does not exixts.d. All EMP table constraints have been dropped.e. All EMP table constraints have been disabled.f. The storage space held by the EMP table was released.

7. Which option in the CREATE INDEX command may substantially reduce the timerequired to create a large index.
a. RECOVERABLEb. CLUSTERc. UNRECOVERABLEd. PARALLEL
8. SELECT sal * 1.10 "Salary", sal * 1.10 + comm "Total Compensation" FROM EMP ;
What is the result of this statement
a. Only the new salary of all employees is displayedb. The new salary and total compensation for each employee is displayedc. The total compensation value is not displayed for employees that do notreceive a commissiond. A zero total compensation value is displayed for employees that do notreceive a commission
9. Which one is not the pseudocolumn used in select statement ?
a. ROWIDb. ROWNUMc. LEVELd. UNIQUEe. CURRVAL
10. Which of the following is suited correctly to eliminate the duplicate rows
a. Using update & rownumb. Using rowid & updatec. Using delete & rowidd. All the abovee. None of the above
11. How can you replace the oracle defined server error messages with your ownmessages in forms
a. Using ON_ERROR Trigger irselfb. Using Error_code & Error_text built-inc. Using SQLCODE & SQLERRM builtinsd. Using Prama_Exeception_Init built-in
12. Which built-in in a form calls another form in a new session
a. OPEN_FORMb. NEW_FORMc. CALL_FORMd. SESSION_FORMe. RUN_PRODUCT

13. Which database object called as the duplicate of the database objectsresiding in a remote place
a. Viewsb. Public Synonymsc. Snapshotsd. Aliasese. Clusters
14. To recompile a trigger manually, the command used is
a. Alter trigger trigger_name compile ;b. Alter trigger trigger_name recompile ;c. Alter trigger trigger_name ;d. None of the above
15. You need to restrict the DML operations on a view by
a. by using grant option.b. force conditionc. no force conditiond. with_option_check

16. Examine the following sql statement and find if there is an error and if soin which line
1 create or replace force view t12 as select deptno, avg(Sal) avg from emp3 group by deptno4 having avg(SAl) >= 10005 order by deptno
a. 1b. 2c. 3d. 4e. 5
17. Which of the following cannot be placed in an object group in Forms 4.5
a. Triggerb. Program Unitsc. Property Classesd. Visual attributes
18. If we have a program unit with the same as a backend procedure, what willtake precedence in a call to the procedure in a form
a. Server procedure takes precedenceb. Local procedure takes precedencec. Cannot create a program unit with the same name as a backend procedured. The server procedure gets invalidated
19. In a when-validate-trigger of an item, the following code is written. Whatis the error
DECLAREV_dummy VARCHAR2(1) ;BEGINV_dummy := 2 ;SELECT 'Y' INTO V_dummy FROM DUAL ;GO_BLOCK('BLOCK1') ;END ;
a. V_dummy has been assigned twiceb. Cannot assign number to VARCHAR fieldc. GO_BLOCK cannot be used in When-validate-Itemd. No Exception has been handled.
20. Can a form have more than one menu attached to it at the same time
a. Yesb. Noc. Sometimes
21. Which menu item type would you create to group menu claims
a. Plainb. Checkc. Magicd. Separator
22. Which button property does not allow the navigation to its own block
a. Set Navigable to Falseb. Set Mouse Navigate to Falsec. Set Next Navigation to Falsed. Set Previous Navigation to False
23. How do you change the alert style at Runtime
a. SET_ALERT_PROPERTYb. Property Classc. Visual Attributed. Not possible to change the alert style
24. You want to simulate a spreadsheet. Which combination should you consider to
create this form, so that it will be easy to read and use
a. One window with one stacked canvasb. One canvas with one content canvasc.One window with one content canvas and one stacked canvasd.Two windows, one for the content canvas and one for the stacked canvas
25. You have a folder with a set of icon files. How do you make forms recognizethe path of your folder to search for icon files.
a. Add the path in FORMS45_ICON parameter in oracle environment.b. In the forms property sheet,add the path of your folder.c. Add the path in the TK23_ICON parameter in oracle environment.d. Move all the icons from the folder to the oracle bin folder.
26. How do you find the nls_language used in your Applicationa. get_nls_language()b. get_application_property()c. find_language()e. user_nls_language()
27. How do you delete a dynamically created parameter list
a. destroy_parameter_list(listname)b. delete_parameter_list(listname)c. drop_parameter_list(listname)
28. Form parameters are variables of type
a. char, number, dateb. char, number, boolean
29. You are creating the sales report to be run in both bitmapped and charactermode environments. What should you do before selecting the default layout ?
a. Modify the report page size .b. Modify the MODE system parameterc. Define the character mode settings.d. Remove any borders, buttons or graphics.
30. You create a single query group above salary report using the followingquery:
SELECT empno,ename,deptno,sal FROM empWHERE hiredate < TO_DATE('January 1, 2000','Month dd, YYYY');
You need to modify the report to add a summary column for the salary values ineach department. Using the data model editor, how could you accomplish thistask?
a. Add a formula column outside the groups and create a PL/SQL function tocompute the resultsb. Add a summary column to the master group, select sal as the source column ,use the sum function and reset the value by g_deptnoc. Add a summary column outside the groups, select the sal as the source column,
use the sum function and reset the value by g_deptno.d. Add a placeholder column outside the groups, select sal as the source column,
use the sum function and reset the value by g_deptno.
31. Your goal is to reduce the amount of network traffic generated by the salesapplication in your client server environment . which design issue will youconsider when creating the inventory report for the sales application ?
a. Remove unused frames.b. Use transparent fillc. Minimize the number of queriesd. Remove unnecessary format triggers
32. You are creating an application for the Spanish users, but prefer to develop
using English. Which NLS variable should you set when testing to ensure theruntime messages output in Spanish.
a. NLS_LANGb. USER_NLS_LANGc. NLS_TERRITORYd. DEVELOPER_NLS_LANG
33. The oracle server will be shutdown today between 5PM and 6PM for hardwaremaintenance. You need to review the reports that are scheduled to run duringthis hour. How would you view jobs that are scheduled to run at a future time?
a. Use the current jobs icon in the Queue Manager.b. Use the Scheduled jobs icon in the Queue Managerc. Use the R30CLI command line with the SCHEDULE parameter.d. You cannot view a job until it has been executed.
34. You are preparing to create an inventory report for your application. TheApplication will be run on three different platforms. Which of the followingfile types should you use when creating the report definition.
a. .rexb. .repc. .rdfd. .rdx
35. You created a procedure and stored it as a report level program unit withinthe sales report. What is the best way to reuse the procedure within the report?
a. Copy the code into a PL/SQL Library.b. Copy the code into an Object Library.c. Reference the code to the report level program unit.d. Use the PL/SQL Editor to copy the code by cutting and pasting.
36. You create a function to change the color of a value in the Salary Column of
the employee report if the value is greater than 2500 . Which component of theSRW package will apply the format mask to the salary column.
a. SRW.SET_ATTRb. SRW.ATTR.MASKc. SRW.ATTR.STYLEd. SRW.ATTR.GCOLOR
37. A packaged function can assert maximum purity levels by specifying one ofthe following in PRAGMA_RESTRICT_REFERENCES
a. RNDS, RNPS, WNPSb. WNDS, RNDS, RNPSc. WNPS, RNDS, RNPSd. RNPS, RNDS, WNPS
38. How do you add a value to a Check constraint of a column
a. alter table t1 modify constraint con1 add value('M') ;b. alter table t1 modify con1 add value ('M') ;c. alter constraint con1 add value('M') ;d. It is not possible to add a value without dropping the existing constraint.
39. How can you get a detail block name in a form which has a Master-Detailsblockusing relations
a. GET_BLOCK_PROPERTYb. GET_FORM_PROPERTYc. GET_RELATION_PROPERTYd. GET_RELATION_BLOCK_PROPERTYe. GET_APPLICATION_PROPERTY
40.What is the datatype used in forms to declare a canvas variable
a. Viewgroupb. Viewidc. Viewportd. Varchar2e. Canvas.

AnswersSET 1
1. c2. c3. b4. c5. a6. a7. b8. a9. b10. d11. c12. c13. d14. b15. b16. a17. a18. c19. d20. a21. c22. d23. c24. d25. b26. c27. a28. a29. b30. c31. a32. b33. c34. d35. c36. a37. c38. d39. a40. b,fSET II
1. A2. B3. B4. D5. A6. B, F7. C8. C9. D10. C11. D12. A13. C14. A15. D16. E17. B18. B19. C20. B21. D22. B23. B24. C25. C26. B27. A28. A29. C30. B31. C32. B33. B34. C35. C36. A37. B38. B39. C40. A