Oracle
This is Just a MODEL Questions will be asked on C, C++, Oracle, RDBMS ,Java and data structuresC--1. The expression 1= 30*1000+2768; evaluates to A)32768 B) -32768 C) 113040 D) 0 2. Which is wrong A) mess=123.56; B) con='T'*'A'; C) this='T"*20; D)3+a=b
3) What is the output of Ptograms Main(){ int a=500,b,c;if(a>400)b=300; c=2--; printf("\n%d%d",b,c);}4) Identify the error in Main(){char c1='a',c2='Z';if (c1=='a'or c2=='z') printf("welcome");}5) What will the following program print Main(){inti; for(i=0;i<=10;i++); printf("%d\n",i);}6) What will be the values of x,y,& zMain(){int x=10,y,a'y=--X;z=x--;printf(%d%d%d\n",x,y,z);}7) What will be the output ofMain(){int i;int marks[]={100,90,75,90,80};for (i=0,i<4;i++)disp(&marks[i]);disp(int i="&arr[1];J=" deptno="10;END;Which">4) How would you declare a PL/SQL table of records toholdthe rows selectd from the EMP table ?5) Which statement about Implicit cursor is true ?a) Implicit cursors are declared implicitly only fromDML b) Implicit cursors are dclared implicitly for all theDML and SELECT statements c) Programmers needs to close all implicit cursorsbefore the end of PL/SQL programsd) Programmers can declare Implicit cursors by usingcursor type in declaraion section 6) Evaluate this PL/SQL Block Declare V_Result number(2)BEGIN DELETE FROM EMPLOYEESWHERE department id (20,30,80);V_result:=SQL%ROWTYPE;COMMIT;END;/What will be the value of v_result if no rows areselected a) 0 b) 1 c) TRUE d) NULL 7) Which two conditions in a PL/SQL block cause anexception error to occur ? ( Choose 2 ) a) Select statement does not return a rowb) select stmt returns more than one rowc) select statement contaains a group by claused) seelct statenent donot have where clausee) data type in the select list are inconsistent whithdata types in the into clause DBMS/ RDBMS-----------1)You are requested to use the HIERARCHIAL DATABSEmodel for the Human Resource DBMS System . Since yourentity relationship model for the system reveal thatmost of the entities have many-o-many relationshipsbetween them, you do not approve TOm'srequest.Referring to the above scenario,what is theREASON behind your decision ?<>
2) Which one of the following mechanisms in aRDBMSensure a) 1 Constraints b) Locking c) Views d) Indexes3) How does a data base stor information that isrelated to the location of its tablesa) 1 by relationships b) By normalisation c) By a data dictionary d) by data banking e) By entity modeling 4) Two tables A & B would be givenYou are asked to mintain a relationship between TableA & B. Referring to the gien table, which field willyou choose as the primary key for Table A <>
5) You have been asked to remove all aggregatefunctions from your SQL statements refering to thescenario above. WHich one of the following do you needto remove ?a) 1 SUM b) COUNT c) AVG d) MAX e) ROUND Data structures--------------- 1) What will be the output of the gien program int m,n=10,top=0,stack[11],item ,current;main(){puts ("enter number of elements <11 top="1;top<=" m="top;m">0;--m)printf("%d\n",stack[m]);}2)Questions on BINARY TRESS and LINKED LISTS ( 4 or 5 options would be given ) 3) What are the THREE MODES OF traversal of a BINARYTREE?
1. Three beauty pageant finalists-Cindy, Amy and Linda-The winner was musician. The one who was not last or first was a math major. The one who came in third had black hair. Linda had red hair. Amy had no musical abilities. Who was first? (A) Cindy (B) Amy (C) Linda (D) None of these
2. Two twins have certain peculiar characteristics. One of them always lies on Monday, Wednesday, Friday. The other always lies on Tuesdays, Thursday and Saturdays. On the other days they tell the truth. You are given a conversation. Person A- today is Sunday, my name is Anil Person B-today is Tuesday, my name is Bill What day is today? (A) Sunday (B) Tuesday (C) Monday (D) Thursday
3. The difference of a number and its reciprocal is 1/2.The sum of their squares is (A) 9/4 (B) 4/5 (C) 5/3 (D) 7/4
4. The difference of a number and its square is 870.What is the number? (A) 42 (B) 29 (C) 30 (D) 32
5. A trader has 100 Kg of wheat, part of which he sells at 5% profit and the rest at 20% profit. He gains 15% on the whole. Find how much is sold at 5% profit? (A) 60 (B) 50 (C) 66.66 (D) 33.3
6. Which of the following points are collinear? (A) (3,5) (4,6) (2,7) (B) (3,5) (4,7) (2,3) (C) (4,5) (4,6) (2,7) (D) (6,7) (7,8) (2,7)
7. A man leaves office daily at 7pm.a driver with car comes from his home to pick him from office and bring back home. One day he gets free at 5.30 and instead of waiting for driver he starts walking towards home. In the way he meets the car and returns home on car. He reaches home 20 minutes earlier than usual. In how much time does the man reach home usually? (A) 1 hr 20 min (B) 1 hr (C) 1 hr 10 min (D) 55 min
8. If m:n = 2:3,the value of 3m+5n/6m-n is (A) 7/3 (B) 3/7 (C) 5/3 (D) 3/5
9. A dog taken four leaps for every five leaps of hare but three leaps of the dog is equal to four leaps of the hare. Compare speed? (A) 12:16 (B) 19:20 (C) 16:15 (D) 10:12
10. A watch ticks 90 times in 95 seconds. And another watch ticks 315 times in 323 secs. If they start together, how many times will they tick together in first hour? (A) 100 times (B) 101 times (C) 99 times (D) 102 times
11. The purpose of defining an index is (A) Enhance Sorting Performance (B) Enhance Searching Performance (C) Achieve Normalization (D) All of the above
12. A transaction does not necessarily need to be (A) Consistent (B) Repeatable (C) Atomic (D) Isolated
13. To group users based on common access permission one should use (A) User Groups (B) Roles (C) Grants (D) None of the above
14. PL/SQL uses which of the following (A) No Binding (B) Early Binding (C) Late Binding (D) Deferred Binding
15. Which of the constraint can be defined at the table level as well as at the column level (A) Unique (B) Not Null (C) Check (D) All the above
16. To change the default date format in a SQLPLUS Session you have to (A) Set the new format in the DATE_FORMAT key in the windows Registry. (B) Alter session to set NLS_DATE-FORMAT. (C) Change the Config.ora File for the date base. (D) Change the User Profile USER-DATE-FORMAT.
17. Which of the following is not necessarily an advantages of using a package rather than independent stored procedure in data base. (A) Better performance. (B) Optimized memory usage. (C) Simplified Security implementation. (D) Encapsulation.
18. Integrity constrains are not checked at the time of (A) DCL Statements. (B) DML Statements. (C) DDL Statements. (D) It is checked all the above cases.
19. Roll Back segment is not used in case of a (A) DCL Statements. (B) DML Statements. (C) DDL Statements. (D) all of the above.
20. An Arc relationship is applicable when (A) One child table has multiple parent relation, but for anyone instance of a child record only one of the relations is applicable. (B) One column of a table is related to another column of the same table. (C) A child table is dependent on columns other than the primary key columns of the parent table. (D) None of the above.
21. What is true about the following C functions? (A) Need not return any value. (B) Should always return an integer. (C) Should always return a float. (D) Should always return more than one value.
22. enum number { a=-1, b=4, c,d,e,} what is the value of e? (A) 7 (B) 4 (C) 5 (D) 3
23. Which of the following about automatic variables within a function is correct? (A) Its type must be declared before using the variable. (B) They are local. (C) They are not initialized to zero. (D) They are global.
24. Consider the following program segment int n, sum=5; switch(n) { case 2:sum=sum-2; case 3:sum*=5; break; default:sum=0; } if n=2, what is the value of the sum? (A) 0 (B) 15 (C) 3 (D) None of these.
25. Which of the following is not an infinite loop? (A) x=0; (B) # define TRUE 0.... do{ While(TRUE){....} /*x unaltered within the loop*/ (C) for(;;) {....} ....} While(x==0); (D) While(1) {....}
26. Output of the following program is main() { int i=0; for(i=0;i<20;i++) i="3;" i="func(i);" i="func(i);" g1="First String" g1="g();" b="&a[2];" ab="x;" b =" (a+b)/(a-b)a*b" href="mailto:a@b">a@b = a/b – b/a (implies subtracting the smaller of the two from the other one )a#b = a/b + b/a
16) Find (((a@b) + (a#b)) * 1)/ 1, where a=5.91 and b= 17.73
1. 35 2. 18/17 3.17/18 4.None of these
17) State which of the following is/are true I. 7@(a*b) is undefined if a = bII. [(a/b)/1 * [(b/a)/1. = (a@b) x (a#b)
1.I only 2. II only 3. Both I and II 4. Neither I or II
18) What is the maximum area that can be enclosed by a wire 44cm long ?
1. 77 2. 154 3. 308 4.None of these
19) If A(2,3) ,B(-2,-3) and C(1,2) are three vertices of a triangle ,which among the following is the largest angle ?
1. ABC 2. BCA 3. CAB 4. All three angles are equal20) f(x) = 2(x*x) +1 when x<0>=0 What is f(f(f(2))) ?
1. 66 2. –33 3. 33 4. None of these
21) One sells 30 kg rice with cost Rs.22.87/kg at 20% profit and 50kg rice with cost price Rs 20.92/kg at 30% profit .What is the total percentage profit ?
1. 26.25% 2. 24.72% 3. 26.5% 4. 28%
22) Ravi buys 100 5% shares of face value Rs.100 at Rs.15000 .If he sells them off after a year at Rs 155 a share ,what is his yield ?
1. 8.33% 2. 6.67% 3. 5% 4. 3.33%
23) Amit and Meghna went to New York for a 63 day holiday .Each day ,Amit spent as many as hundred dollar bills as the remaining number of days in the trip (excluding the current day ) ,and Meghna spent as many as hundred dollar bills as the number of days already spent (including current day). How much per day would they have spent together during the holiday ?
1. $12,600 2. $10000 3. $6300 4. $5000
24) Bacteria reproduce in such a manner that every hour their number doubles In a controlled experiment that started with a certain number of bacteria in a jar at 12noon on Tuesday ,30 million were found at 12noon on Wednesday .At what time were there 15 million bacteria ? 1. Midnight ,Tuesday 2. 6a.m on Wednesday 3. 10 a.m Wednesday 4. None of these
25) Take a number ‘x’ and follow these steps :1. Find the sum of its digit 2. If the sum has only one digit , STOP3. Else , go back to step 1 with the new number.If x = 1684 ,what is the end result ?
1. 19 2. 10 3. 1 4. None of these
26) A number consisting of five digits 5,6,7,8 and 9 each coming once but not necessarily in that order is taken ,and an algorithm specified in the previous question is run on it .How many different end results are possible ?
1. One 2.Three 3.Five 4. Nine
Directions for questions 27 and 28 :Each question is followed by two statements A and B. Mark 1. If statement A alone is sufficient to answer the question 2. If statement B alone is sufficient to answer the question3. If both statements A and B are required to answer the question4. If neither A or B are sufficient to answer the question
27) What is the height of the tower ? A. A man standing at a distance of 1km from the bottom of the tower makes an angle 300 degrees with the top of the tower .B. An insect starts from the bottom of the tower and reaches the top in 25sec.
28) Distance between A and B isA. A and B two points on the circumference of the circle with center O and radius 5.2 cmB. Angle AOB = 450
Additional instructions for questions 29 and 30:
For any activity , X, year Ao dominates year Bo if organized retail business in activity X in year Ao is greater than organized retails business in activity X is year Bo .For any two activities in the organized retail business ,A and B ,year Xo dominates year Yo ifa. The organized retail business in activity A ,in the year Xo is greater than equal to the organized retail business activity A in the year Yo: and b. The organized retail business in activity B ,in the year Yo is less than or equal to the organized retail business in activity B in the year Xo.
29) For the organized retail business activity in children’s clothing ,which one of the following is true ?
1. 1994-95 dominates 1995-962. 1995-96 dominates 1994-953. 1997-98 dominates 1996-974. 1998-99 dominates 1997-98
30) For the organized retail business activity in children ‘s clothing and footwear ,which of the following is true ?
1. 1995-96 dominates 1994-952. 1994-95 dominates 1995-963. 1996-97 dominates 1995-964. None of these
SQL AND SQL*Plus
1. Which of the following statements contains an error?
A. SELECT * FROM emp WHERE empid = 493945;B. SELECT empid FROM emp WHERE empid= 493945;C. SELECT empid FROM emp;D. SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';
2. Which of the following correctly describes how to specify a column alias?
A. Place the alias at the beginning of the statement to describe the table.B. Place the alias after each column, separated by white space, to describe the column.C. Place the alias after each column, separated by a comma, to describe the column.D. Place the alias at the end of the statement to describe the table.
3. The NVL function
A. Assists in the distribution of output across multiple columns.B. Allows the user to specify alternate output for non-null column values.C. Allows the user to specify alternate output for null column values.D. Nullifies the value of the column output.
4. Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?
PLAY_TABLE-------------------------------------"Midsummer Night's Dream", SHAKESPEARE"Waiting For Godot", BECKETT"The Glass Menagerie", WILLIAMS
A. SELECT play_name author FROM plays;B. SELECT play_name, author FROM plays;C. SELECT play_name', ' author FROM plays;D. SELECT play_name', ' author PLAY_TABLE FROM plays;
5. Issuing the DEFINE_EDITOR="emacs" will produce which outcome?
A. The emacs editor will become the SQL*Plus default text editor.B. The emacs editor will start running immediately.C. The emacs editor will no longer be used by SQL*Plus as the default text editor.D. The emacs editor will be deleted from the system.
6. The user issues the following statement. What will be displayed if the EMPID selected is 60494?
SELECT DECODE(empid,38475, "Terminated",60494, "LOA", "ACTIVE") FROM emp;
A. 60494B. LOAC. TerminatedD. ACTIVE
7. SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID")) FROM DUAL is a valid SQL statement.
A. TRUEB. FALSE
8. The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is
A. EMPB. The table containing the column valuesC. DUALD. An Oracle-defined table
9. Which of the following is not a group function?
A. avg( ) B. sqrt( )C. sum( )D. max( )
10. Once defined, how long will a variable remain so in SQL*Plus?
A. Until the database is shut downB. Until the instance is shut downC. Until the statement completesD. Until the session completes
11. The default character for specifying runtime variables in SELECT statements is
A. AmpersandB. EllipsesC. Quotation marksD. Asterisk
12. A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?
A. select e.empid, d.head from emp e, dept d;B. select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;C. select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);D. select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;
13. Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?
A. A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU.B. A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER.C. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.D. A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.
14. User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?
A. INSERT INTO employee VALUES (59694,'HARRIS', NULL);B. INSERT INTO employee VALUES (59694,'HARRIS');C. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,'HARRIS');D. INSERT INTO employee (SELECT 59694 FROM 'HARRIS');
15. Which three of the following are valid database datatypes in Oracle? (Choose three.)
A. CHARB. VARCHAR2C. BOOLEAND. NUMBER
16. Omitting the WHERE clause from a DELETE statement has which of the following effects?
A. The delete statement will fail because there are no records to delete.B. The delete statement will prompt the user to enter criteria for the deletionC. The delete statement will fail because of syntax error.D. The delete statement will remove all records from the table.
17. Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.
A. TRUEB. FALSE
18. Dropping a table has which of the following effects on a nonunique index created for the table?
A. No effect.B. The index will be dropped.C. The index will be rendered invalid.D. The index will contain NULL values.
19. To increase the number of nullable columns for a table,
A. Use the alter table statement.B. Ensure that all column values are NULL for all rows.C. First increase the size of adjacent column datatypes, then add the column.D. Add the column, populate the column, then add the NOT NULL constraint.
20. Which line of the following statement will produce an error?
A. CREATE TABLE goodsB. (good_no NUMBER,C. good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),D. CONSTRAINT pk_goods_01E. PRIMARY KEY (goodno));F. There are no errors in this statement.
21. MAXVALUE is a valid parameter for sequence creation.
A. TRUEB. FALSE
22. Which of the following lines in the SELECT statement below contain an error?
A. SELECT DECODE(empid, 58385, "INACTIVE", "ACTIVE") empid B. FROM empC. WHERE SUBSTR(lastname,1,1) > TO_NUMBER('S')D. AND empid > 02000E. ORDER BY empid DESC, lastname ASC;F. There are no errors in this statement.
23. Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?
A. SQRTB. DECODEC. NEW_TIMED. ROWIDTOCHAR
24. Which two of the following orders are used in ORDER BY clauses? (choose two)
A. ABSB. ASCC. DESCD. DISC
25. You query the database with this command
SELECT nameFROM employeeWHERE name LIKE ‘_a%’;
Which names are displayed?
A. Names starting with “a”B. Names starting with “a” or “A”C. Names containing “a” as second characterD. Names containing “a” as any letter except the first
PL/SQL
26. Which of the following statements is true about implicit cursors?
A. Implicit cursors are used for SQL statements that are not named.B. Developers should use implicit cursors with great care.C. Implicit cursors are used in cursor for loops to handle data processing.D. Implicit cursors are no longer a feature in Oracle.
27. Which of the following is not a feature of a cursor FOR loop?
A. Record type declaration.B. Opening and parsing of SQL statements.C. Fetches records from cursor.D. Requires exit condition to be defined.
28. A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?
A. Use employee.lname%type.B. Use employee.lname%rowtype.C. Look up datatype for EMPLOYEE column on LASTNAME table and use that.D. Declare it to be type LONG.29. Which three of the following are implicit cursor attributes?
A. %foundB. %too_many_rowsC. %notfoundD. %rowcountE. %rowtype
30. If left out, which of the following would cause an infinite loop to occur in a simple loop?
A. LOOPB. END LOOPC. IF-THEND. EXIT
31. Which line in the following statement will produce an error?
A. cursor action_cursor isB. select name, rate, actionC. into action_recordD. from action_table;E. There are no errors in this statement.
32. The command used to open a CURSOR FOR loop is
A. openB. fetchC. parse D. None, cursor for loops handle cursor opening implicitly.
33. What happens when rows are found using a FETCH statement
A. It causes the cursor to closeB. It causes the cursor to openC. It loads the current row values into variablesD. It creates the variables to hold the current row values
34. CREATE OR REPLACE PROCEDURE find_cpt(v_movie_id {Argument Mode} NUMBER, v_cost_per_ticket {argument mode} NUMBER)ISBEGIN IF v_cost_per_ticket > 8.5 THENSELECT cost_per_ticketINTO v_cost_per_ticketFROM gross_receiptWHERE movie_id = v_movie_id; END IF;END;
Which mode should be used for V_COST_PER_TICKET?
A. INB. OUTC. RETURND. IN OUT
35. CREATE OR REPLACE TRIGGER update_show_gross {trigger information} BEGIN {additional code} END;
The trigger code should only execute when the column, COST_PER_TICKET, is greater than $3.75. Which trigger information will you add?
A. WHEN (new.cost_per_ticket > 3.75)B. WHEN (:new.cost_per_ticket > 3.75C. WHERE (new.cost_per_ticket > 3.75)D. WHERE (:new.cost_per_ticket > 3.75)
36. What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?
A. Only oneB. All that applyC. All referencedD. None
37. For which trigger timing can you reference the NEW and OLD qualifiers?
A. Statement and RowB. Statement onlyC. Row onlyD. Oracle Forms trigger38. CREATE OR REPLACE FUNCTION get_budget(v_studio_id IN NUMBER)RETURN number IS
v_yearly_budget NUMBER;
BEGIN SELECT yearly_budget INTO v_yearly_budget FROM studio WHERE id = v_studio_id;
RETURN v_yearly_budget;END;
Which set of statements will successfully invoke this function within SQL*Plus?
A. VARIABLE g_yearly_budget NUMBEREXECUTE g_yearly_budget := GET_BUDGET(11);B. VARIABLE g_yearly_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);C. VARIABLE :g_yearly_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);D. VARIABLE g_yearly_budget NUMBER:g_yearly_budget := GET_BUDGET(11);
39.CREATE OR REPLACE PROCEDURE update_theater(v_name IN VARCHAR2, v_theater_id IN NUMBER) ISBEGIN UPDATE theater SET name = v_name WHERE id = v_theater_id;END update_theater;
When invoking this procedure, you encounter the error:ORA-00001: Unique constraint(SCOTT.THEATER_NAME_UK) violated.
How should you modify the function to handle this error?
A. An user defined exception must be declared and associated with the error code and handled in the EXCEPTION section.B. Handle the error in EXCEPTION section by referencing the error code directly.C. Handle the error in the EXCEPTION section by referencing the UNIQUE_ERROR predefined exception.D. Check for success by checking the value of SQL%FOUND immediately after the UPDATE statement.
40.CREATE OR REPLACE PROCEDURE calculate_budget ISv_budget studio.yearly_budget%TYPE;BEGIN v_budget := get_budget(11); IF v_budget < yearly_budget =" v_new_budget" id =" v_studio_id;" s1="{" i="1;ifile://Ans: i work for oracle
3.void main() { int i,j,k; for(i=0;i<3;i++) k="sum(i,i);" href="file://Ans/">file://Ans: 6
4.void main() { int i; clrscr(); for(i=1;i<6;++i) href="file://Ans/">file://Ans: 1,4,6
5.Which of the storage class(es) becomes the globalvariables for the =entire Program (A) Extern (B) Static (C) Auto (D) Register
ANSWER : A
6.//What is the output of the program void main() { char s[]="oracle is the best"; char t[40]; char *ss,*tt; while(*tt++=*ss++); printf("%s",t); getch(); } // A. oracle is the best // B. Core dump // c. Error Message // D. Goes into infinite loop // Ans: B. core dump (Garbage value)
7.//What is the output of the program void main() { int j[10]={9,7,5,3,1,2,4,6,9}; int i=1; clrscr(); for(;i<9;i++) n="5;" i="5;i">0;i--) { j=1i=100; strcpy(str1->st1,"Welcome to Oracle"); printf(" %d%s\n",str1->i,str1->st1); getch(); } // A. core dump // B. will not compile // c. 100,Welcome to Oracle // D. None of these // Ans: C
13.//What is the output of the program void main() { int i,j,k; i=2; j=4; k=i++>j&2; printf("%d\n",k); if(++k &&amp; ++i<--j i++) { j=++k; } printf(" %d %d %d",i,-j--,k); getch(); } // A. 4,-3,2 // B. 5,-3,2 // c. 4,-2,2 // D. 5,-2,2 // Ans: D 14.Which of the following is not true incase ofCommand line arguments A.The argc parameter is used to hold the numberof arguments in the =command line and is an integer B. The argv parameter is a pointer to an array ofa character =pointer and each one points to command linearguments C. The argv[1] always point to program name D. None of above Ans: C 15. A function without any return type declaresreturn=20 A. Integer B. Float C. Void D. Syntax Error Ans: A 16.//What is the output of the program #include #include #define sqr(a) a*a void main() { int a=10,b=1,c; c=sqr(10+1); printf("Sqr Root of (10+1)is %d",c ); getch(); } // A. 121 // B. 21 // c. 13 // D. Syntax Error // Ans: B
17.//What is the output of the program #include #include void main() { int i,j=20; clrscr(); for(i=1;i<3;i++)> #include void main() { int i=1*4/3-27%3^2+100*0.5-(4>3?1:2); clrscr(); printf("%d",i); getch(); } // A. 49 // B. compile error // c. 51 // D. 48 // Ans: b
19.What is the output of the program #include #include void main() { char *st1[3]= {"Hello","World","Oracle"}; *st1=st1[2]; st1[1]=*st1; free(st1[0]); free(st1[1]); clrscr(); printf("%s %s %s",st1,st1[1],st1[2]); getch(); } // A. Garbage Garbage Oracle // B. oracle oracle oracle // c. Hello World Oracle // D. Core Dump:cannot Print after freeing thememory // Ans: D
20.Consider the following structure =20 Struct { int data; struct node *prev; struct node *next; }NODE;
NULL <-- 5 --> 8 --> 10 --> NULL p <-- q <-- r=20 WHAT WILL BE THE VALUE OF r-->prev-->-->next-->data? A. 8 B. Null C. 5 D. 10 Ans: 10
21. what will be the output of the fallowing SELECTstatement ? SELECT count(*) FROM emp Where exist (select 'X' From dept where dept_name ='Stores' and dept.dept_id=emp.dept_id)
A. select total number of employees belonging todepartment " stores " B. select all employees belonging to department "X" C. select all employees belonging to department"stores" D. select total number of employees belonging todepartment "X"
22. Denormalisation is done to=20 A. Check for Data Integrity B. Reduce Data Redundancy C. Intoduce Security Check D. Increase Query performance .
23. How many columns are retrived from this query: SELECT address1 ',' address2 ','address2 "Address" FROM =employee;
A. 3 B. 2 C. 1 D. 0
24. What is the is the result of the fallowing CodePiece=20 Insert into table A value(a1): CREATE TABLE B AS SELECT * FROM A; ROLLBAACK ; A. Table B gets created with the row inserted in thefirst statement. B. Table B is not created C. Table B gets created , but no row gets insertedinto Table A D. Rollback throws up an exception .
25. The key word used in Oracle for string searchingis=20
A. SOUNDEX B. DECODE C. LIKE D. HAVING
26. What does the ROLLBACK statement wil do in thefool segment of =code PROGRAM STARTS HERE ........ SOME DML STAT. ...SAVEPOINT1 SOME DML STAT. ...SAVEPOINT2 SOME DML STAT. ...ROLLBACK A. Rollback Dml changes to savepoint 1 B. Rollback Dml changes to savepoint 2 C. Rollback Dml changes of the last DMLststs. just before =ROllback stats D. Rollback DML changes to the place whre theprogram starts
27. Which clause u use to exclude the rows beforegrouping them? A. Group By B. Having C. Where D. Minus
28. Which of the following statements is not trueabout views? A. u can create a index on views B. Views donot have permanent data C. Views can be based on one or more tables D. Views can be dropped without droppingtables
29 How many JION conditions are needed in JOIN queryto avoid a =Cartesian Product? A. No of tables + 1 B. No of tables - 1 C. No of colums + 1 D. No of colums - 1
30. "An item could be either a component or spare ".How can u =represent this scenerio in a E-R=20 A. Subtype Relation B. Arc Relation C. Recursive Relation D. Many to Many Relationscription
The questions asked to me in Oracle Interview are:
1st interviewer(one hour 10 minutes) ______________________________________
1. There is dual switch bulb,we have to write the truth table and also FSM for that dual switch bulb.
2. Write a program to check whether the given comments are nested comments are or not(/*ajsd/*asdh*/asd*/ is nested comment but /*asd*/ /*kjasdh*/ is not a nested comment)-you can write program in any language...
3.Check whether the trees are structurally similar or not....program using linked list
4. What is virtual functions and some question on virtual functions....
5.What are the statemnets beging with # mean in C language and how they can be handled by macroprocessor and if it comes in the middle of program how it will be handled..
6.Write a program for finding the factorial of a given number..
2nd interviewer(one hour 20 minutes) _________________________________________
1. Write a program to find whether a linked list is circular or not
2. Write a program to reverse a linked list...
3.Write a program to find the mirror image of the given binary tree.
4.Tell something about genetic algorithms and explain ur M.Tech project....
3rd interviewer(one hour 10 minutes) ______________________________________
1. What is a process and a thread
2.Write a algorithm for deletinga node in an binary search tree...
3.What is inheritance,virtual function,singleton class and pure virtual function...
4.Write a unix network program to implement the ftp protocol,,
5. write a algorithm to find a loop ina linked lsit.
6.he concentrated mainly in unix.. what is socket and what is binding and how is client server thing works.....
4th interviewer(one hour ) _________________________________________
1. What are the various scheduling algorithms and explain the algorithms
2. Write what will happen when you run a program that contains many functions... you have to tell what is stored in stack and what is stored in the heap and other steps how a program is executed...
3. Write a program for quicksort and also merge sort
4.What is the process control block and explain the structure with a diagram...
5.Write a program to insert nodes in a linked list and print them and some modifications after writing the program to write functions for addnode....
6.he concentrated mainly in Operating systems...
1. #include#define sqr(x) (x*x)int main(){ int x=2; printf("value of x=%d",sqr(x+1));} What is the value of x?a)4 b)5 c)None d)can not compileAns: 5 2. what is the wrong in the following program?#define LBRACKET {#define RBRACKET }#define MAIN mainint MAIN()LBRACKET int x=2; printf("%d",x);RBRACKET a) This program will compileb) compilation error 3.#include int main(){ int x=4; { { { int x=2; printf("%d",x); } } }}a) 4 b)2 c)Nesting not allowed d)dependent on the compiler4. Go through the following code sinippet char a[20]; a="Hello Orcale Test"; will this compile? a) Compilation Error b) Strings are allowed in c but cannot be assigned directly. c) dependent on compiler d) will work fine.5. the expression a+b*c should be conveted to +a*bc. Using tree structure, Which traversal is the correct one? a) Postfix traversal b) prefix traversal c) infix traversal d)None6. what about brk, sbrk a) system calls b) function calls c) user defined functions 7. Why the use of alloca() is discouraged?8. Macros support multiple arguments ?9. the header file a) contains only compiler directives and extern variables b) contail only structures and unitions c) a & b10. what about "char *(*(*a[])())();"
1. An index is automatically generated with the following constraints. a. Check b. Not null c. Primary key d. Foreign key 2. Select mod(16,3) from emp; a. 1 b. 2 c. 3 d. Error in the stmt 3. The data dictionary view to see the list of constraints enabled on a table is a. user_tables b. user_table_constraints c. user_constraints d. There is no dictionary view available for the same 4. Identify the pseudocolumns a. rowid b. sysdate c. rowval d. dual 5. select deptno, count(empno) from emp where count(empno)>=5 group by deptno; identify the line no which contains the error a. 1 b. 2 c. 3 d. 1,3 6. choose the group function that can be used with any data type a. sum() b. min() c. avg() d. all 7. which of the following sequence is true a. WHERE,HAVING,GROUPBY,ORDERBY b. GROUPBY, WHERE, HAVING, ORDERBY c. ORDERBY,GROUPBY,WHERE,HAVING d. NONE OF THE ABOVE 8. which of the proper keyword to deallocate memory a. free b. delete c. clear d. remove 9. what is the index no of the last element of an array with 29 elements a. 29 b. 28 c. 0 d. programmer defined
10. what is the final value of x when the code for(int x=0;x<10;x++)> void main() { char buffer[10]={"Genesis"}; printf("%d",&buffer[4]-(buffer)); } a. 3 b. 4 c. 0 d. illegal pointer subtraction 14. what is the output for #include main() { static int a[]={5,10,15,20}; int * ptr=a; int ** ptr_ptr=&ptr; printf("\n %d",**ptr_ptr++); } a. 5 b. 10 c. 15 d. 6 15. what is the value of expr.. 1+2/3*4+1 a. 2 b. 3 c. 4 d. 4.666666 e. 5 16. identify the relationship between the many employees working in a dept.. a. one to one b. one to many c. many to one d. many to many 17.there was a table given and it was asked which normal form does it follows.. 18. the process of including some controlled redundancy for the sake of performance is known as a. normalization b. Cartesian product c. Denormalization d. None 19. in a doubley linked list a. the last node contains the address of the first node b. each node contains the address of previous and next node c. each node contains the address of previous node d. none 20. in a queue each node contains a. the address of previous node b. address of next node c. address of both the previous and next node d. none of the above
1. given a square matrix which consists only of 1 and 0......find which rows,which cols and which diagonals consist entirely of 1's. 2. given an array of integers find all possible combinations of the numbers whose sum equal to 90..... ans : knapsack problem (in data structures - aho ullman) Note : for them solution was not the criteria.......but the approach was important......the solution should be generalised and optimized........optimization was given the top priority........ here is the techincal paper : plz try to solve them urself by trying on comp. 1. const int MAX=10; main() {enum a {a,b,MAX}; print MAX; } 2. enum object is a const which can only be assigned a value at initialization or a variable which can be assigned any value in the middle of the program? 3. void *p; what operation cannot be performed on p? ans : arithmetic operation unless it is properly typecasted 4. char **p="Hello"; print p,*p,**p 5. main() {char str[]="Geneius"; print (str); } print(char *s) {if(*s) print(++s); printf("%c",*s); } 6. what does the function fcloseall() does ? 7. main() {printf("Genius %d",fun(123)); } fun(int n) {return (printf("%d",n)); } 8. difference between definition and declaration. 9. find the error? fun() {int i=10; if(i<10) a="9,b=" c="3,d;" d="(b-c)<(c-a)" 1="?" i="4;" i="i/4);" cols="?"> 4. Mention basic concepts of OOP. 5. What are messages in OOP?. 6. What is garbase collection?. 7.what is object?. 8. what is a class?.
section 4: 1. expand the following: a.SEI b. ISO 2. what are different levels of SEI?. 3. What is significance of ISO?> 4. Expand the following: a. WWW b. HTTP c. HTML d. TCP/IP 5. what is Black box testing?. 6. explain the following: 1. white box testing 2. white box testing 3. boundary testing 4 stress 5. negative 6. system 7. unit 8.module 9.destructive
1. what are the macros other than C macros (the macrosin word,excel) A macro in MS-word is used to group a sequenceof jobs and make it as a button or keyboard shortcut.Suppose, if you need always to draw a table containing2 rows and 5 cols, you can start,record a macro andmake it as a button and put in taskbar, sothat whenyou press it, you will be provided with a fixed table.
2. can you delete a column from a table. In oracle 9i, you can do it by the statementALTER TABLE table1 DROP COLUMN column1; In oracle8,you can't.
3. can you store a image in oracle and by whichdatatype? Yes, you can and it can be acheived by usinga BLOB (binary large object) type and store upto 4GBin a single column.
4. have you used reports and forms in oracle?
5. have you written applications to retrieve storedimages in a table?
6. some DOS commands and UNIX.
7. project desription (both academic andminiprojects,if any)
8. some situation questions like what would you do ifyour company is burning,etc.
English:analogy questions around ( you can refer to GRE book)fill the sentence with appropriate word..(multiple choices given)sentence correction..
Aptitude:arithmetic questions..some of the questions:Q:1/3th of the passengers gotdown at first stop and 30 people got into the bus, 1/4th of the passengers gotdown at second stop and 12 people got into the bus.in last stop 84 people got down from the bus.What is the initial capacity of the bus?
Q:one person is running around a 180 sq yard filed, first 1/4 his speed was 10KMPH second 1/4 20KMPH third 1/4 30 KMPH and the fourth 1/4 40 KMPH.what is the average speed?
NOTE: there was a question on milk ,water ratio..
logical deductions..Q: is x+y a prime? a. x is prime b. y is prime
options: 1. only "a" correct 2. only "b" correct 3. both are correct 4. both are wrong.
C,C++,JAVA
Q: There were 2 or 3 C programs and the question is to point error in the program or to predict the answer
Q:Which one of the following is not a storage type:1. static 2. register 3. stack 4.autoanswer: stack
Q:what is the type of the second parameter of fopen() function?
Q:Which of the following is correct about constructor?OPTIONS: 1.void type 2. return nothing 3..... 4.....answer 2
Q:how do we store a constant value in java?multiple choices given..answer: using "final"
SQL:please be thorough with SQL, PL/SQL
There were some questions where they gave query and asked whether it is correct or wrong if wrong what is wrong...
Q: create table...........;{table creation query)Roll back;what will be the output?options ....
1. how compiler treats variables of recursive functions2. what is orthogonal matrix?3. given two tables and asked 2 qns on those table , one is on join and another is on NOT IN4. given some qns on pointers( pretty easy)5. given five qns on data structures like , lifo, fifo 6. qtn on primary key 7. how NULL in sql is treated?8. given a doubly linked list and asked r->left->right->data ans: r->data9:explain const char *ptr and char *const ptr
1)declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end;What will be the output ?(a) equal(b) not equal(c) else(d) No outputCorrect Answer : (c)
2)declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=numto_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ? (a)12 (b)12345 (c)123 (d)Wrong assignmentCorrect Answer : (c)
1. question on bubble sore2. quick sort complexity3. heap sort SPACE complexity.
4. char *p = "Oracle India"; p[5] == 'l' ? printf("Orcle") : printf("India")
5. main(){ int i=5; recursive(i);}recursive(int u){ if(u > 0 ) recursive(u-1); printf("%d", u);}
6. question on function pointer. char *(*(*x())[])()7. GRANT command question8. about MINUS set operator.
Java
9. RandomAccessFile10. super class base class simple question11. what is overridden12. StringBUffer question
part 1: apptitute test -30question (20min)part 2: technical Test -30question (20min)
part 1:
1)find the range of x*x -5x+6>0X<=2 ; X >=3
2)if 5x*x+14*x+k=0 having two reciprocal roots find the value of k.
3&4)two sentence are given ,in between four sentence are given in change order . (like between 1 & 6 ,abcd four sentence are given 1 a b c d 6)
Find the correct order?
5)if first term of AP is 5 .16th term is 45.find the sum of first 16 terms.
6)x,y and z are odd no. not necessarly in sequence.then y=? (1)mean of x and z is 114. (2)mean of y and z is 113. Ans: 115
7)ram is 27 year old then mohan.after 7 year ram age is thrice as mohan age .find ram age?Ans : 67/2
8)if three tapes are filling a tank of capacity of 500lit with speed of 30lit/sec,48lit/sec and 36lit/sec. Find after how long time tank will fill?Ans : 500/114
9)find the root of given eq x-2/(x-1)=1-2/(x-2) if possible.Ans : x = 0
10)find the point of intersection of \ 15x+9y=15 5x+3y=21 Ans : NO
11)suppose in a pot 20 cards are there label 1-20 on that. find the probability of getting two prime.
Ans : 8/20 = 2 / 5
12)in an island three persons are there Jam ,Dam and Sam .sam having pencil,dam having cap and Jam having book .we have find who is author among them if. (1)Sam says ,Jam is author but author wearing cap. (2)Dam says ,I am author ,but author not having cap. (3)Sam says, I am author ,but author having note book. Find who is author? Ans : jam
13)Jo ,Do and So are three person.(1) So says Jo is football player, I also football player.(2) Do says Jo is football player, I also football player.(3) Jo says Do is football player, I also football player.Find the football player player among them.
Ans : jo
14-16)question based analogy . like LION:CUB find the pair in given choice.
17)in a basket 3 mangos,4 apples and 4 bananas are there. Find no of ways we select randomly 3 fruit from basket?
18) if a^x=b^y=c^z and b^2=ac then find x+z/xz=? Ans : 2/y
19)(loga)^2-(logb)^2 = ?
ans :- logab-loga/b
20)in a 60 liters of mixture of spirit and water is 7 %. in order to make water 19%,how much water should be added.(some thing like this)
21-25)A one and half page length passage will be given and 4 to 5 questions will be asked based on this passage.
26)
technical part:-==================pattern: 1) pl/sql--->7 quest 2) java--->5 quest 3) c & pointers--->9 quest 4) dbms and dfd's--->5 quest 5) ds--->4 quest
some quest are here:-
1.what is not a c- storage class
Ans.stack
2.if dba creates one user what are the privilages the user will get?
3. which keyword is used to const in java Ans. final
4.char *array[4]={"some string"}printf("%d",&array[4]-(array));
Ans.4
5.remote object will be in the package
Ans.java.net (verity it)
6.#define sq(a) (a*a)printf ("%d",sq (3+2));
Ans.11
7.#define max 20printf ("%d", ++max);
Ans.lvalue required --- error
8.printf ("%d",sizeof (2>3?4?:4:3?4:2));(some thing like this)
Ans.syntax error
9. what is important of free().
10.property of constructor in java program.
11.impotance of macro.
12.underfolw condition of stack.
(1)empty,2)push,3)pop,4)none)====================
1)Which of the following is not a storage class in C?
Static Register Extern Stack
2)Which of the following 'return' statement is correct?
return, return; return(1, 2, 3); return(return 4); (return 5, return 6);
3)The second argument to fopen() function is?
char const char * int * FILE *
4)What is the output of the program?
#include
void main() { char buffer[10] = {"Genesis"}; printf(" %d ", &buffer[4]- (buffer)); }
3 4 0 Illegal pointer subtraction 4
5)If "arr" is an array of 5 x 5 dimension, arr[2][4] is same as
**(a+3+4) *(a+3)+*(a+4) **(a+3)+4 *(*(a+2)+4)
-----------------------------------------------------APTITUDE 30 questions
Log37 1: ------- = ? ( Log67 ) 1 + Log32
2: log(a-b) = log a - log b; then a = ? (b/(b2+1));
3: 3 black 7 white balls ......... prob of drawing 2 white balls ? (7/15)
4: In a lock of 4 rings there r five characters howmany unsuccessful attempts can be made ? (624)...
5: sqrt(6+sqrt(6+sqrt (6 + .................))))) = ? 3
6: a solution is prepared by mixing two solution with sprit 20% & 60%...In what ration they should be mixed to get the 50% spritin resultant solution .(1:3)
7: X2 - (A-3)X +(A+3) = 0for what value of A the sum of square of roots will beleast ? (A=2);
8: 'a' number of persons work daily 'b' hours toproduce 'c' items. If 'd' persons walks away from the group what will be thenumber of hours to produce 'c' items. ? (ab/(a-d))
9: - 13 Passage
14 - 18 venn diagram.
19-22 picking based (VERBAL);
23-25 picking odd once out (words )
26: m = ax , n = ay mxny = a2(x+y) find 1/x + 1/y? (1)
27 xy - 2y - 6 =0;x <> 2 x >2 ...y is always postive.
28 The diameter of circle can be determined from 1.area.2.circumference.
Ans either of them..
29:
sum of 2 no. is 7 & product s 10 fnd larger number.
30:
--------------------------------------------------------
TECHNCAL :
It will be really tough. They will manly concentrate on PL/SQLJava.C.
1. Output of the following program is
main(){ int i=0; for(i=0;i<20;i++) g1="FirstString" g1="g();" file="export.dmp" indexfile="newrite.sql." ratio =" (Logical" log_archive_format =" arch" log_archive_dest =" path." name =" ''" item =" PARAMETER" module="old_lib.pll" userid="scott/tiger">> if fvar is null then <<>> svar := svar + 5 end if; End;
What will be the value of svar after the execution ? a] Error b] 10 c] 5 d] None of the above
Ans : A
52. Which of the following is not correct about an Exception ? a] Raised automatically / Explicitly in response to an ORACLE_ERROR b] An exception will be raised when an error occurs in that block c] Process terminates after completion of error sequence. d] A Procedure or Sequence of statements may be processed.
Ans : C
53. Which of the following is not correct about User_Defined Exceptions ? a] Must be declared b] Must be raised explicitly c] Raised automatically in response to an Oracle error d] None of the above
Ans : C
54. A Stored Procedure is a a] Sequence of SQL or PL/SQL statements to perform specific function b] Stored in compiled form in the database c] Can be called from all client environmets d] All of the above
Ans : D
55. Which of the following statement is false a] Any procedure can raise an error and return an user message anderror number b] Error number ranging from 20000 to 20999 are reserved for userdefined messages c] Oracle checks Uniqueness of User defined errors d] Raise_Application_error is used for raising an user defined error.
Ans : C
56. Is it possible to open a cursor which is in a Package in anotherprocedure ? a] Yes b] No
Ans : A
57. Is it possible to use Transactional control statements in DatabaseTriggers ? a] Yes b] No
Ans : B
58. Is it possible to Enable or Disable a Database trigger ? a] Yes b] No
Ans : A
59. PL/SQL supports datatype(s) a] Scalar datatype b] Composite datatype c] All of the above d] None of the above
Ans C
60. Find the ODD datatype out a] VARCHAR2 b] RECORD c] BOOLEAN d] RAW
Ans : B
61. Which of the following is not correct about the "TABLE" datatype ? a] Can contain any no of columns b] Simulates a One-dimensional array of unlimited size c] Column datatype of any Scalar type d] None of the above
Ans : A
62. Find the ODD one out of the following a] OPEN b] CLOSE c] INSERT d] FETCH
Ans C
63. Which of the following is not correct about Cursor ? a] Cursor is a named Private SQL area b] Cursor holds temporary results c] Cursor is used for retrieving multiple rows d] SQL uses implicit Cursors to retrieve rows
Ans : B
64. Which of the following is NOT VALID in PL/SQL ? a] Select ... into b] Update c] Create d] Delete
Ans : C
65. What is the Result of the following 'VIK'NULL'RAM' ? a] Error b] VIK RAM c] VIKRAM d] NULL
Ans : C
66. Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a <> ( Select count(*) from Emp E2 where E1.SAL > E2.SAL ) will retrieve a] 3500,5000,2500 b] 5000,2850 c] 2850,5750 d] 5000,5750
Ans : A
72. Is it possible to modify a Datatype of a column when column containsdata ? a] Yes b] No
Ans B
73. Which of the following is not correct about a View ? a] To protect some of the columns of a table from other users b] Ocuupies data storage space c] To hide complexity of a query d] To hide complexity of a calculations
Ans : B
74. Which is not part of the Data Definiton Language ? a] CREATE b] ALTER c] ALTER SESSION
Ans : C
75. The Data Manipulation Language statements are a] INSERT b] UPDATE c] SELECT d] All of the above
Ans : D
76. EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH A500 BALAJI 5750
Using the above data Select count(sal) from Emp will retrieve a] 1 b] 0 c] 3 d] None of the above
Ans : C
77. If an UNIQUE KEY constraint on DATE column is created, will it acceptthe rows that are inserted with SYSDATE ? a] Will b] Won't
Ans : B
78. What are the different events in Triggers ? a] Define, Create b] Drop, Comment c] Insert, Update, Delete d] All of the above
Ans : C79. What built-in subprogram is used to manipulate images in image items ? a] Zoom_out b] Zoom_in' c] Image_zoom d] Zoom_image
Ans : C
80. Can we pass RECORD GROUP between FORMS ? a] Yes b] No
Ans : A
81. SHOW_ALERT function returns a] Boolean b] Number c] Character d] None of the above
Ans : B
82. What SYSTEM VARIABLE is used to refer DATABASE TIME ? a] $$dbtime$$ b] $$time$$ c] $$datetime$$ d] None of the above
Ans : A
83. :SYSTEM.EFFECTIVE.DATE varaible is a] Read only b] Read & Write c] Write only d] None of the above
Ans : C
84. How can you CALL Reports from Forms4.0 ? a] Run_Report built_in b] Call_Report built_in c] Run_Product built_in d] Call_Product built_in
Ans : C
85. When do you get a .PLL extension ? a] Save Library file b] Generate Library file c] Run Library file d] None of the above
Ans : A
86. What is built_in Subprogram ? a] Stored procedure & Function b] Collection of Subprogram c] Collection of Packages d] None of the above
Ans : D
87. GET_BLOCK property is a a] Restricted procedure b] Unrestricted procedure c] Library function d] None of the above
Ans : D
88. A CONTROL BLOCK can sometimes refer to a BASETABLE ? a] TRUE b] FALSE
Ans : B
89. What do you mean by CHECK BOX ? a] Two state control b] One state control c] Three state control d] none of the above
Ans : C - Please check the Correcness of this Answer ( The correct answeris 2 )
90. List of Values (LOV) supports a] Single column b] Multi column c] Single or Multi column d] None of the above
Ans : C
91. What is Library in Forms 4.0 ? a] Collection of External field b] Collection of built_in packages c] Collection of PL/SQl functions, procedures and packages d] Collection of PL/SQL procedures & triggers
Ans : C
92. Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger ? a] Yes b] No
Ans : B
93. Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ? a] Yes b] No
Ans : B
94. What type of file is used for porting Forms 4.5 applications to variousplatforms ? a] .FMB file b] .FMX file c] .FMT file d] .EXE file
Ans : C
95. What built_in procedure is used to get IMAGES in Forms 4.5 ? a] READ_IMAGE_FILE b] GET_IMAGE_FILE c] READ_FILE d] GET_FILE
Ans A
96. When a form is invoked with CALL_FORM does Oracle forms issuesSAVEPOINT ? a] Yes b] No
Ans : A
97. Can we attach the same LOV to different fields in Design time ? a] Yes b] No
Ans : A
98. How do you pass values from one form to another form ? a] LOV b] Parameters c] Local variables d] None of the above
Ans : B
99. Can you copy the PROGRAM UNIT into an Object group ? a] Yes b] No
Ans : B
100. Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ? a] Yes b] No
Ans : A
101. When is a .FMB file extension is created in Forms 4.5 ? a] Generating form b] Executing form c] Save form d] Run form
Ans : C
102. What is a Built_in subprogram ? a] Library b] Stored procedure & Function c] Collection of Subprograms d] None of the above
Ans : D
103. What is a RADIO GROUP ? a] Mutually exclusive b] Select more than one column c] Above all TRUE d] Above all FALSE
Ans : A
104. Identify the Odd one of the following statements ? a] Poplist b] Tlist c] List of values d] Combo box
Ans : C
105. What is an ALERT ? a] Modeless window b] Modal window c] Both are TRUE d] None of the above
Ans : B
106. Can an Alert message be changed at runtime ? a] Yes b] No
Ans : A
107. Can we create an LOV without an RECORD GROUP ? a} Yes b] No
Ans : B
108. How many no of columns can a RECORD GROUP have ? a] 10 b] 20 c] 50 d] None of the above
Ans D
109. Oracle precompiler translates the EMBEDDED SQL statemens into a] Oracle FORMS b] Oracle REPORTS c] Oracle LIBRARY d] None of the above
Ans : D
110. Kind of COMMENT statements placed within SQL statements ? a] Asterisk(*) in column ? b] ANSI SQL style statements(...) c] C-Style comments (/*......*/) d] All the above
Ans : D
111. What is the appropriate destination type to send the output to aprinter ? a] Screen b] Previewer c] Either of the above d] None of the above
Ans : D
112. What is TERM ? a] TERM is the terminal definition file that describes the terminalfrom which you are using R20RUN ( Reports run time ) b] TERM is the terminal definition file that describes the terminalfrom which you are using R20DES ( Reports designer ) c] There is no Parameter called TERM in Reports 2.0 d] None of the above
Ans : A
113. If the maximum records retrieved property of a query is set to 10,then a summary value will be calculated a] Only for 10 records b] For all the records retrieved c] For all therecords in the referenced table d] None of the above
Ans : A
114. With which function of a summary item in the COMPUTE AT optionrequired ? a] Sum b] Standard deviation c] Variance d] % of Total function
Ans : D
115. For a field in a repeating frame, can the source come from a columnwhich does not exist in the datagroup which forms the base of the frame ? a] Yes b] No
Ans : A
116. What are the different file extensions that are created by OracleReports ? a] .RDF file & .RPX file b] .RDX file & .RDF file c] .REP file & .RDF file d] None of the above
Ans : C
117. Is it possible to Disable the Parameter form while running the report? a] Yes b] No
Ans : A
118.What are the SQL clauses supported in the link property sheet ? a] WHERE & START WITH b] WHERE & HAVING c} START WITH & HAVING d] WHERE, START WITH & HAVING
Ans : D
119. What are the types of Calculated columns available ? a] Summary, Place holder & Procedure column b] Summary, Procedure & Formula columns c] Procedure, Formula & Place holder columns d] Summary, Formula & Place holder columns
Ans.: D
120. If two groups are not linked in the data model editor, what is thehierarchy between them? a] There is no hierarchy between unlinked groups b] The group that is right ranks higher than the group that is to theleft c] The group that is above or leftmost ranks higher than the groupthat is to right or below it d] None of the above
Ans : C
121. Sequence of events takes place while starting a Database is a] Database opened, File mounted, Instance started b] Instance started, Database mounted & Database opened c] Database opened, Instance started & file mounted d] Files mounted, Instance started & Database opened
Ans : B
122. SYSTEM TABLESPACE can be made off-line a] Yes b] No
Ans : B
123. ENQUEUE_RESOURCES parameter information is derived from a] PROCESS or DDL_LOCKS & DML_LOCKS b] LOG BUFFER c] DB_BLOCK_SIZE d] DB_BLOCK_BUFFERS
Ans : A
124. SMON process is used to write into LOG files a] TRUE b] FALSE
Ans : B
125. EXP command is used a] To take Backup of the Oracle Database b] To import data from the exported dump file c] To create Rollback segments d] None of the above
Ans : A
126. SNAPSHOTS cannot be refreshed automatically a] TRUE b] FALSEAns : B127. The User can set Archive file name formats a] TRUE b] FALSE
Ans : A
128. The following parameters are optional in init.ora parameter fileDB_BLOCK_SIZE, PROCESS a} TRUE b] FALSE
Ans : B129. NOARCHIEVELOG parameter is used to enable the database in Archievemode a] TRUE b] FALSE
Ans : B
130. Constraints cannot be exported through Export command? a] TRUE b] FALSE
Ans : B
131. It is very difficult to grant and manage common priveleges needed bydifferent groups of database users using roles a] TRUE b] FALSE
Ans : B
132. The status of the Rollback segment can be viewed through a] DBA_SEGMENTS b] DBA_ROLES c] DBA_FREE_SPACES d] DBA_ROLLBACK_SEG
Ans : D
133. Explicitly we can assign transaction to a rollback segment a] TRUE B] FALSE
Ans : A
134. What file is read by ODBC to load drivers ? a] ODBC.INI b] ODBC.DLL c] ODBCDRV.INI d] None of the above
Ans : A
1. precedence of PL/SQL2.in an employee table consisting of empid and supid to get supervisor id for employee (something like this related to ans. self join) we would useIntersectunionjoin subquery3.The order of execution in corelated queriesInner query executes first then outer query Outer query executes first then inner query each row of inner query is evaluated with outer queryeach row of outer query is evaluated with inner query4.declare i Number j Number k Numberbegin i:=0 for j = 1..5 i:=i+1; j:=j+1;k:=i+j+k;..........5.function of ROLLUP and CUBE6.Based on Group by clause rule that it should contain column found in select clause7.Can procedure in a package be overloaded8.public void static main(String []args){String s1=new String("test");String s2=new String("test");if(s1==s2)System.out.println("Both are equal");Boolean b1=new Boolean("true");Boolean b2=new Boolean("false");if(b1.equals(b2))System.out.println("some message");}output=?9.x=7;y=0;if(x=y)y=7;elsey=5;what is the value of y10.Threading in java a prg was given in which it had no exceptions and run function had string as its parametera.runtime errorb.compile time errorc.d.
11.what fuction can be repeated instead of comment....{public void aMethod(String S,int i);//here....}a.public void aMethod(int i ,String S);b.public void aMethod(String myobj,int j);c.public int aMethod(String S,int i);d.public void AMethod(String S,int i);12.Encapsulation is implemented bya.private variables and public methodsb.private variables and private methodsc.public variables and public methodsd.protected members13.Based on scope of a variable14.Recursive fuction are used to a.call itselfb.call other functionsc.return integersd....15.int a[]={0,1,2,3,4,5}int *pa=a;which of the following is not the correct way to accessa.a[5]b.*(a+5)c.*(pa+5)d.*(*pa+5)16.struct{char emp[12];int mpno;}e;struct e a[2]={{jack,2},{raj,8},{jill,2}}struct e *p;*p=a;p+=2......17.AVL tree is a balanced binary search tree18.order of B+tree19.Disadvantage of indexed sequential file20.queue can be called as full even if its capacity is'nt
3) What is the output of Ptograms Main(){ int a=500,b,c;if(a>400)b=300; c=2--; printf("\n%d%d",b,c);}4) Identify the error in Main(){char c1='a',c2='Z';if (c1=='a'or c2=='z') printf("welcome");}5) What will the following program print Main(){inti; for(i=0;i<=10;i++); printf("%d\n",i);}6) What will be the values of x,y,& zMain(){int x=10,y,a'y=--X;z=x--;printf(%d%d%d\n",x,y,z);}7) What will be the output ofMain(){int i;int marks[]={100,90,75,90,80};for (i=0,i<4;i++)disp(&marks[i]);disp(int i="&arr[1];J=" deptno="10;END;Which">4) How would you declare a PL/SQL table of records toholdthe rows selectd from the EMP table ?5) Which statement about Implicit cursor is true ?a) Implicit cursors are declared implicitly only fromDML b) Implicit cursors are dclared implicitly for all theDML and SELECT statements c) Programmers needs to close all implicit cursorsbefore the end of PL/SQL programsd) Programmers can declare Implicit cursors by usingcursor type in declaraion section 6) Evaluate this PL/SQL Block Declare V_Result number(2)BEGIN DELETE FROM EMPLOYEESWHERE department id (20,30,80);V_result:=SQL%ROWTYPE;COMMIT;END;/What will be the value of v_result if no rows areselected a) 0 b) 1 c) TRUE d) NULL 7) Which two conditions in a PL/SQL block cause anexception error to occur ? ( Choose 2 ) a) Select statement does not return a rowb) select stmt returns more than one rowc) select statement contaains a group by claused) seelct statenent donot have where clausee) data type in the select list are inconsistent whithdata types in the into clause DBMS/ RDBMS-----------1)You are requested to use the HIERARCHIAL DATABSEmodel for the Human Resource DBMS System . Since yourentity relationship model for the system reveal thatmost of the entities have many-o-many relationshipsbetween them, you do not approve TOm'srequest.Referring to the above scenario,what is theREASON behind your decision ?<>
2) Which one of the following mechanisms in aRDBMSensure a) 1 Constraints b) Locking c) Views d) Indexes3) How does a data base stor information that isrelated to the location of its tablesa) 1 by relationships b) By normalisation c) By a data dictionary d) by data banking e) By entity modeling 4) Two tables A & B would be givenYou are asked to mintain a relationship between TableA & B. Referring to the gien table, which field willyou choose as the primary key for Table A <>
5) You have been asked to remove all aggregatefunctions from your SQL statements refering to thescenario above. WHich one of the following do you needto remove ?a) 1 SUM b) COUNT c) AVG d) MAX e) ROUND Data structures--------------- 1) What will be the output of the gien program int m,n=10,top=0,stack[11],item ,current;main(){puts ("enter number of elements <11 top="1;top<=" m="top;m">0;--m)printf("%d\n",stack[m]);}2)Questions on BINARY TRESS and LINKED LISTS ( 4 or 5 options would be given ) 3) What are the THREE MODES OF traversal of a BINARYTREE?
1. Three beauty pageant finalists-Cindy, Amy and Linda-The winner was musician. The one who was not last or first was a math major. The one who came in third had black hair. Linda had red hair. Amy had no musical abilities. Who was first? (A) Cindy (B) Amy (C) Linda (D) None of these
2. Two twins have certain peculiar characteristics. One of them always lies on Monday, Wednesday, Friday. The other always lies on Tuesdays, Thursday and Saturdays. On the other days they tell the truth. You are given a conversation. Person A- today is Sunday, my name is Anil Person B-today is Tuesday, my name is Bill What day is today? (A) Sunday (B) Tuesday (C) Monday (D) Thursday
3. The difference of a number and its reciprocal is 1/2.The sum of their squares is (A) 9/4 (B) 4/5 (C) 5/3 (D) 7/4
4. The difference of a number and its square is 870.What is the number? (A) 42 (B) 29 (C) 30 (D) 32
5. A trader has 100 Kg of wheat, part of which he sells at 5% profit and the rest at 20% profit. He gains 15% on the whole. Find how much is sold at 5% profit? (A) 60 (B) 50 (C) 66.66 (D) 33.3
6. Which of the following points are collinear? (A) (3,5) (4,6) (2,7) (B) (3,5) (4,7) (2,3) (C) (4,5) (4,6) (2,7) (D) (6,7) (7,8) (2,7)
7. A man leaves office daily at 7pm.a driver with car comes from his home to pick him from office and bring back home. One day he gets free at 5.30 and instead of waiting for driver he starts walking towards home. In the way he meets the car and returns home on car. He reaches home 20 minutes earlier than usual. In how much time does the man reach home usually? (A) 1 hr 20 min (B) 1 hr (C) 1 hr 10 min (D) 55 min
8. If m:n = 2:3,the value of 3m+5n/6m-n is (A) 7/3 (B) 3/7 (C) 5/3 (D) 3/5
9. A dog taken four leaps for every five leaps of hare but three leaps of the dog is equal to four leaps of the hare. Compare speed? (A) 12:16 (B) 19:20 (C) 16:15 (D) 10:12
10. A watch ticks 90 times in 95 seconds. And another watch ticks 315 times in 323 secs. If they start together, how many times will they tick together in first hour? (A) 100 times (B) 101 times (C) 99 times (D) 102 times
11. The purpose of defining an index is (A) Enhance Sorting Performance (B) Enhance Searching Performance (C) Achieve Normalization (D) All of the above
12. A transaction does not necessarily need to be (A) Consistent (B) Repeatable (C) Atomic (D) Isolated
13. To group users based on common access permission one should use (A) User Groups (B) Roles (C) Grants (D) None of the above
14. PL/SQL uses which of the following (A) No Binding (B) Early Binding (C) Late Binding (D) Deferred Binding
15. Which of the constraint can be defined at the table level as well as at the column level (A) Unique (B) Not Null (C) Check (D) All the above
16. To change the default date format in a SQLPLUS Session you have to (A) Set the new format in the DATE_FORMAT key in the windows Registry. (B) Alter session to set NLS_DATE-FORMAT. (C) Change the Config.ora File for the date base. (D) Change the User Profile USER-DATE-FORMAT.
17. Which of the following is not necessarily an advantages of using a package rather than independent stored procedure in data base. (A) Better performance. (B) Optimized memory usage. (C) Simplified Security implementation. (D) Encapsulation.
18. Integrity constrains are not checked at the time of (A) DCL Statements. (B) DML Statements. (C) DDL Statements. (D) It is checked all the above cases.
19. Roll Back segment is not used in case of a (A) DCL Statements. (B) DML Statements. (C) DDL Statements. (D) all of the above.
20. An Arc relationship is applicable when (A) One child table has multiple parent relation, but for anyone instance of a child record only one of the relations is applicable. (B) One column of a table is related to another column of the same table. (C) A child table is dependent on columns other than the primary key columns of the parent table. (D) None of the above.
21. What is true about the following C functions? (A) Need not return any value. (B) Should always return an integer. (C) Should always return a float. (D) Should always return more than one value.
22. enum number { a=-1, b=4, c,d,e,} what is the value of e? (A) 7 (B) 4 (C) 5 (D) 3
23. Which of the following about automatic variables within a function is correct? (A) Its type must be declared before using the variable. (B) They are local. (C) They are not initialized to zero. (D) They are global.
24. Consider the following program segment int n, sum=5; switch(n) { case 2:sum=sum-2; case 3:sum*=5; break; default:sum=0; } if n=2, what is the value of the sum? (A) 0 (B) 15 (C) 3 (D) None of these.
25. Which of the following is not an infinite loop? (A) x=0; (B) # define TRUE 0.... do{ While(TRUE){....} /*x unaltered within the loop*/ (C) for(;;) {....} ....} While(x==0); (D) While(1) {....}
26. Output of the following program is main() { int i=0; for(i=0;i<20;i++) i="3;" i="func(i);" i="func(i);" g1="First String" g1="g();" b="&a[2];" ab="x;" b =" (a+b)/(a-b)a*b" href="mailto:a@b">a@b = a/b – b/a (implies subtracting the smaller of the two from the other one )a#b = a/b + b/a
16) Find (((a@b) + (a#b)) * 1)/ 1, where a=5.91 and b= 17.73
1. 35 2. 18/17 3.17/18 4.None of these
17) State which of the following is/are true I. 7@(a*b) is undefined if a = bII. [(a/b)/1 * [(b/a)/1. = (a@b) x (a#b)
1.I only 2. II only 3. Both I and II 4. Neither I or II
18) What is the maximum area that can be enclosed by a wire 44cm long ?
1. 77 2. 154 3. 308 4.None of these
19) If A(2,3) ,B(-2,-3) and C(1,2) are three vertices of a triangle ,which among the following is the largest angle ?
1. ABC 2. BCA 3. CAB 4. All three angles are equal20) f(x) = 2(x*x) +1 when x<0>=0 What is f(f(f(2))) ?
1. 66 2. –33 3. 33 4. None of these
21) One sells 30 kg rice with cost Rs.22.87/kg at 20% profit and 50kg rice with cost price Rs 20.92/kg at 30% profit .What is the total percentage profit ?
1. 26.25% 2. 24.72% 3. 26.5% 4. 28%
22) Ravi buys 100 5% shares of face value Rs.100 at Rs.15000 .If he sells them off after a year at Rs 155 a share ,what is his yield ?
1. 8.33% 2. 6.67% 3. 5% 4. 3.33%
23) Amit and Meghna went to New York for a 63 day holiday .Each day ,Amit spent as many as hundred dollar bills as the remaining number of days in the trip (excluding the current day ) ,and Meghna spent as many as hundred dollar bills as the number of days already spent (including current day). How much per day would they have spent together during the holiday ?
1. $12,600 2. $10000 3. $6300 4. $5000
24) Bacteria reproduce in such a manner that every hour their number doubles In a controlled experiment that started with a certain number of bacteria in a jar at 12noon on Tuesday ,30 million were found at 12noon on Wednesday .At what time were there 15 million bacteria ? 1. Midnight ,Tuesday 2. 6a.m on Wednesday 3. 10 a.m Wednesday 4. None of these
25) Take a number ‘x’ and follow these steps :1. Find the sum of its digit 2. If the sum has only one digit , STOP3. Else , go back to step 1 with the new number.If x = 1684 ,what is the end result ?
1. 19 2. 10 3. 1 4. None of these
26) A number consisting of five digits 5,6,7,8 and 9 each coming once but not necessarily in that order is taken ,and an algorithm specified in the previous question is run on it .How many different end results are possible ?
1. One 2.Three 3.Five 4. Nine
Directions for questions 27 and 28 :Each question is followed by two statements A and B. Mark 1. If statement A alone is sufficient to answer the question 2. If statement B alone is sufficient to answer the question3. If both statements A and B are required to answer the question4. If neither A or B are sufficient to answer the question
27) What is the height of the tower ? A. A man standing at a distance of 1km from the bottom of the tower makes an angle 300 degrees with the top of the tower .B. An insect starts from the bottom of the tower and reaches the top in 25sec.
28) Distance between A and B isA. A and B two points on the circumference of the circle with center O and radius 5.2 cmB. Angle AOB = 450
Additional instructions for questions 29 and 30:
For any activity , X, year Ao dominates year Bo if organized retail business in activity X in year Ao is greater than organized retails business in activity X is year Bo .For any two activities in the organized retail business ,A and B ,year Xo dominates year Yo ifa. The organized retail business in activity A ,in the year Xo is greater than equal to the organized retail business activity A in the year Yo: and b. The organized retail business in activity B ,in the year Yo is less than or equal to the organized retail business in activity B in the year Xo.
29) For the organized retail business activity in children’s clothing ,which one of the following is true ?
1. 1994-95 dominates 1995-962. 1995-96 dominates 1994-953. 1997-98 dominates 1996-974. 1998-99 dominates 1997-98
30) For the organized retail business activity in children ‘s clothing and footwear ,which of the following is true ?
1. 1995-96 dominates 1994-952. 1994-95 dominates 1995-963. 1996-97 dominates 1995-964. None of these
SQL AND SQL*Plus
1. Which of the following statements contains an error?
A. SELECT * FROM emp WHERE empid = 493945;B. SELECT empid FROM emp WHERE empid= 493945;C. SELECT empid FROM emp;D. SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';
2. Which of the following correctly describes how to specify a column alias?
A. Place the alias at the beginning of the statement to describe the table.B. Place the alias after each column, separated by white space, to describe the column.C. Place the alias after each column, separated by a comma, to describe the column.D. Place the alias at the end of the statement to describe the table.
3. The NVL function
A. Assists in the distribution of output across multiple columns.B. Allows the user to specify alternate output for non-null column values.C. Allows the user to specify alternate output for null column values.D. Nullifies the value of the column output.
4. Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?
PLAY_TABLE-------------------------------------"Midsummer Night's Dream", SHAKESPEARE"Waiting For Godot", BECKETT"The Glass Menagerie", WILLIAMS
A. SELECT play_name author FROM plays;B. SELECT play_name, author FROM plays;C. SELECT play_name', ' author FROM plays;D. SELECT play_name', ' author PLAY_TABLE FROM plays;
5. Issuing the DEFINE_EDITOR="emacs" will produce which outcome?
A. The emacs editor will become the SQL*Plus default text editor.B. The emacs editor will start running immediately.C. The emacs editor will no longer be used by SQL*Plus as the default text editor.D. The emacs editor will be deleted from the system.
6. The user issues the following statement. What will be displayed if the EMPID selected is 60494?
SELECT DECODE(empid,38475, "Terminated",60494, "LOA", "ACTIVE") FROM emp;
A. 60494B. LOAC. TerminatedD. ACTIVE
7. SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID")) FROM DUAL is a valid SQL statement.
A. TRUEB. FALSE
8. The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is
A. EMPB. The table containing the column valuesC. DUALD. An Oracle-defined table
9. Which of the following is not a group function?
A. avg( ) B. sqrt( )C. sum( )D. max( )
10. Once defined, how long will a variable remain so in SQL*Plus?
A. Until the database is shut downB. Until the instance is shut downC. Until the statement completesD. Until the session completes
11. The default character for specifying runtime variables in SELECT statements is
A. AmpersandB. EllipsesC. Quotation marksD. Asterisk
12. A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?
A. select e.empid, d.head from emp e, dept d;B. select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;C. select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);D. select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;
13. Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?
A. A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU.B. A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER.C. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.D. A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.
14. User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?
A. INSERT INTO employee VALUES (59694,'HARRIS', NULL);B. INSERT INTO employee VALUES (59694,'HARRIS');C. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,'HARRIS');D. INSERT INTO employee (SELECT 59694 FROM 'HARRIS');
15. Which three of the following are valid database datatypes in Oracle? (Choose three.)
A. CHARB. VARCHAR2C. BOOLEAND. NUMBER
16. Omitting the WHERE clause from a DELETE statement has which of the following effects?
A. The delete statement will fail because there are no records to delete.B. The delete statement will prompt the user to enter criteria for the deletionC. The delete statement will fail because of syntax error.D. The delete statement will remove all records from the table.
17. Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.
A. TRUEB. FALSE
18. Dropping a table has which of the following effects on a nonunique index created for the table?
A. No effect.B. The index will be dropped.C. The index will be rendered invalid.D. The index will contain NULL values.
19. To increase the number of nullable columns for a table,
A. Use the alter table statement.B. Ensure that all column values are NULL for all rows.C. First increase the size of adjacent column datatypes, then add the column.D. Add the column, populate the column, then add the NOT NULL constraint.
20. Which line of the following statement will produce an error?
A. CREATE TABLE goodsB. (good_no NUMBER,C. good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),D. CONSTRAINT pk_goods_01E. PRIMARY KEY (goodno));F. There are no errors in this statement.
21. MAXVALUE is a valid parameter for sequence creation.
A. TRUEB. FALSE
22. Which of the following lines in the SELECT statement below contain an error?
A. SELECT DECODE(empid, 58385, "INACTIVE", "ACTIVE") empid B. FROM empC. WHERE SUBSTR(lastname,1,1) > TO_NUMBER('S')D. AND empid > 02000E. ORDER BY empid DESC, lastname ASC;F. There are no errors in this statement.
23. Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?
A. SQRTB. DECODEC. NEW_TIMED. ROWIDTOCHAR
24. Which two of the following orders are used in ORDER BY clauses? (choose two)
A. ABSB. ASCC. DESCD. DISC
25. You query the database with this command
SELECT nameFROM employeeWHERE name LIKE ‘_a%’;
Which names are displayed?
A. Names starting with “a”B. Names starting with “a” or “A”C. Names containing “a” as second characterD. Names containing “a” as any letter except the first
PL/SQL
26. Which of the following statements is true about implicit cursors?
A. Implicit cursors are used for SQL statements that are not named.B. Developers should use implicit cursors with great care.C. Implicit cursors are used in cursor for loops to handle data processing.D. Implicit cursors are no longer a feature in Oracle.
27. Which of the following is not a feature of a cursor FOR loop?
A. Record type declaration.B. Opening and parsing of SQL statements.C. Fetches records from cursor.D. Requires exit condition to be defined.
28. A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?
A. Use employee.lname%type.B. Use employee.lname%rowtype.C. Look up datatype for EMPLOYEE column on LASTNAME table and use that.D. Declare it to be type LONG.29. Which three of the following are implicit cursor attributes?
A. %foundB. %too_many_rowsC. %notfoundD. %rowcountE. %rowtype
30. If left out, which of the following would cause an infinite loop to occur in a simple loop?
A. LOOPB. END LOOPC. IF-THEND. EXIT
31. Which line in the following statement will produce an error?
A. cursor action_cursor isB. select name, rate, actionC. into action_recordD. from action_table;E. There are no errors in this statement.
32. The command used to open a CURSOR FOR loop is
A. openB. fetchC. parse D. None, cursor for loops handle cursor opening implicitly.
33. What happens when rows are found using a FETCH statement
A. It causes the cursor to closeB. It causes the cursor to openC. It loads the current row values into variablesD. It creates the variables to hold the current row values
34. CREATE OR REPLACE PROCEDURE find_cpt(v_movie_id {Argument Mode} NUMBER, v_cost_per_ticket {argument mode} NUMBER)ISBEGIN IF v_cost_per_ticket > 8.5 THENSELECT cost_per_ticketINTO v_cost_per_ticketFROM gross_receiptWHERE movie_id = v_movie_id; END IF;END;
Which mode should be used for V_COST_PER_TICKET?
A. INB. OUTC. RETURND. IN OUT
35. CREATE OR REPLACE TRIGGER update_show_gross {trigger information} BEGIN {additional code} END;
The trigger code should only execute when the column, COST_PER_TICKET, is greater than $3.75. Which trigger information will you add?
A. WHEN (new.cost_per_ticket > 3.75)B. WHEN (:new.cost_per_ticket > 3.75C. WHERE (new.cost_per_ticket > 3.75)D. WHERE (:new.cost_per_ticket > 3.75)
36. What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?
A. Only oneB. All that applyC. All referencedD. None
37. For which trigger timing can you reference the NEW and OLD qualifiers?
A. Statement and RowB. Statement onlyC. Row onlyD. Oracle Forms trigger38. CREATE OR REPLACE FUNCTION get_budget(v_studio_id IN NUMBER)RETURN number IS
v_yearly_budget NUMBER;
BEGIN SELECT yearly_budget INTO v_yearly_budget FROM studio WHERE id = v_studio_id;
RETURN v_yearly_budget;END;
Which set of statements will successfully invoke this function within SQL*Plus?
A. VARIABLE g_yearly_budget NUMBEREXECUTE g_yearly_budget := GET_BUDGET(11);B. VARIABLE g_yearly_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);C. VARIABLE :g_yearly_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);D. VARIABLE g_yearly_budget NUMBER:g_yearly_budget := GET_BUDGET(11);
39.CREATE OR REPLACE PROCEDURE update_theater(v_name IN VARCHAR2, v_theater_id IN NUMBER) ISBEGIN UPDATE theater SET name = v_name WHERE id = v_theater_id;END update_theater;
When invoking this procedure, you encounter the error:ORA-00001: Unique constraint(SCOTT.THEATER_NAME_UK) violated.
How should you modify the function to handle this error?
A. An user defined exception must be declared and associated with the error code and handled in the EXCEPTION section.B. Handle the error in EXCEPTION section by referencing the error code directly.C. Handle the error in the EXCEPTION section by referencing the UNIQUE_ERROR predefined exception.D. Check for success by checking the value of SQL%FOUND immediately after the UPDATE statement.
40.CREATE OR REPLACE PROCEDURE calculate_budget ISv_budget studio.yearly_budget%TYPE;BEGIN v_budget := get_budget(11); IF v_budget < yearly_budget =" v_new_budget" id =" v_studio_id;" s1="{" i="1;i
3.void main() { int i,j,k; for(i=0;i<3;i++) k="sum(i,i);" href="file://Ans/">file://Ans: 6
4.void main() { int i; clrscr(); for(i=1;i<6;++i) href="file://Ans/">file://Ans: 1,4,6
5.Which of the storage class(es) becomes the globalvariables for the =entire Program (A) Extern (B) Static (C) Auto (D) Register
ANSWER : A
6.//What is the output of the program void main() { char s[]="oracle is the best"; char t[40]; char *ss,*tt; while(*tt++=*ss++); printf("%s",t); getch(); } // A. oracle is the best // B. Core dump // c. Error Message // D. Goes into infinite loop // Ans: B. core dump (Garbage value)
7.//What is the output of the program void main() { int j[10]={9,7,5,3,1,2,4,6,9}; int i=1; clrscr(); for(;i<9;i++) n="5;" i="5;i">0;i--) { j=1
13.//What is the output of the program void main() { int i,j,k; i=2; j=4; k=i++>j&2; printf("%d\n",k); if(++k &&amp; ++i<--j i++) { j=++k; } printf(" %d %d %d",i,-j--,k); getch(); } // A. 4,-3,2 // B. 5,-3,2 // c. 4,-2,2 // D. 5,-2,2 // Ans: D 14.Which of the following is not true incase ofCommand line arguments A.The argc parameter is used to hold the numberof arguments in the =command line and is an integer B. The argv parameter is a pointer to an array ofa character =pointer and each one points to command linearguments C. The argv[1] always point to program name D. None of above Ans: C 15. A function without any return type declaresreturn=20 A. Integer B. Float C. Void D. Syntax Error Ans: A 16.//What is the output of the program #include
17.//What is the output of the program #include
19.What is the output of the program #include
20.Consider the following structure =20 Struct { int data; struct node *prev; struct node *next; }NODE;
NULL <-- 5 --> 8 --> 10 --> NULL p <-- q <-- r=20 WHAT WILL BE THE VALUE OF r-->prev-->-->next-->data? A. 8 B. Null C. 5 D. 10 Ans: 10
21. what will be the output of the fallowing SELECTstatement ? SELECT count(*) FROM emp Where exist (select 'X' From dept where dept_name ='Stores' and dept.dept_id=emp.dept_id)
A. select total number of employees belonging todepartment " stores " B. select all employees belonging to department "X" C. select all employees belonging to department"stores" D. select total number of employees belonging todepartment "X"
22. Denormalisation is done to=20 A. Check for Data Integrity B. Reduce Data Redundancy C. Intoduce Security Check D. Increase Query performance .
23. How many columns are retrived from this query: SELECT address1 ',' address2 ','address2 "Address" FROM =employee;
A. 3 B. 2 C. 1 D. 0
24. What is the is the result of the fallowing CodePiece=20 Insert into table A value(a1): CREATE TABLE B AS SELECT * FROM A; ROLLBAACK ; A. Table B gets created with the row inserted in thefirst statement. B. Table B is not created C. Table B gets created , but no row gets insertedinto Table A D. Rollback throws up an exception .
25. The key word used in Oracle for string searchingis=20
A. SOUNDEX B. DECODE C. LIKE D. HAVING
26. What does the ROLLBACK statement wil do in thefool segment of =code PROGRAM STARTS HERE ........ SOME DML STAT. ...SAVEPOINT1 SOME DML STAT. ...SAVEPOINT2 SOME DML STAT. ...ROLLBACK A. Rollback Dml changes to savepoint 1 B. Rollback Dml changes to savepoint 2 C. Rollback Dml changes of the last DMLststs. just before =ROllback stats D. Rollback DML changes to the place whre theprogram starts
27. Which clause u use to exclude the rows beforegrouping them? A. Group By B. Having C. Where D. Minus
28. Which of the following statements is not trueabout views? A. u can create a index on views B. Views donot have permanent data C. Views can be based on one or more tables D. Views can be dropped without droppingtables
29 How many JION conditions are needed in JOIN queryto avoid a =Cartesian Product? A. No of tables + 1 B. No of tables - 1 C. No of colums + 1 D. No of colums - 1
30. "An item could be either a component or spare ".How can u =represent this scenerio in a E-R=20 A. Subtype Relation B. Arc Relation C. Recursive Relation D. Many to Many Relationscription
The questions asked to me in Oracle Interview are:
1st interviewer(one hour 10 minutes) ______________________________________
1. There is dual switch bulb,we have to write the truth table and also FSM for that dual switch bulb.
2. Write a program to check whether the given comments are nested comments are or not(/*ajsd/*asdh*/asd*/ is nested comment but /*asd*/ /*kjasdh*/ is not a nested comment)-you can write program in any language...
3.Check whether the trees are structurally similar or not....program using linked list
4. What is virtual functions and some question on virtual functions....
5.What are the statemnets beging with # mean in C language and how they can be handled by macroprocessor and if it comes in the middle of program how it will be handled..
6.Write a program for finding the factorial of a given number..
2nd interviewer(one hour 20 minutes) _________________________________________
1. Write a program to find whether a linked list is circular or not
2. Write a program to reverse a linked list...
3.Write a program to find the mirror image of the given binary tree.
4.Tell something about genetic algorithms and explain ur M.Tech project....
3rd interviewer(one hour 10 minutes) ______________________________________
1. What is a process and a thread
2.Write a algorithm for deletinga node in an binary search tree...
3.What is inheritance,virtual function,singleton class and pure virtual function...
4.Write a unix network program to implement the ftp protocol,,
5. write a algorithm to find a loop ina linked lsit.
6.he concentrated mainly in unix.. what is socket and what is binding and how is client server thing works.....
4th interviewer(one hour ) _________________________________________
1. What are the various scheduling algorithms and explain the algorithms
2. Write what will happen when you run a program that contains many functions... you have to tell what is stored in stack and what is stored in the heap and other steps how a program is executed...
3. Write a program for quicksort and also merge sort
4.What is the process control block and explain the structure with a diagram...
5.Write a program to insert nodes in a linked list and print them and some modifications after writing the program to write functions for addnode....
6.he concentrated mainly in Operating systems...
1. #include
1. An index is automatically generated with the following constraints. a. Check b. Not null c. Primary key d. Foreign key 2. Select mod(16,3) from emp; a. 1 b. 2 c. 3 d. Error in the stmt 3. The data dictionary view to see the list of constraints enabled on a table is a. user_tables b. user_table_constraints c. user_constraints d. There is no dictionary view available for the same 4. Identify the pseudocolumns a. rowid b. sysdate c. rowval d. dual 5. select deptno, count(empno) from emp where count(empno)>=5 group by deptno; identify the line no which contains the error a. 1 b. 2 c. 3 d. 1,3 6. choose the group function that can be used with any data type a. sum() b. min() c. avg() d. all 7. which of the following sequence is true a. WHERE,HAVING,GROUPBY,ORDERBY b. GROUPBY, WHERE, HAVING, ORDERBY c. ORDERBY,GROUPBY,WHERE,HAVING d. NONE OF THE ABOVE 8. which of the proper keyword to deallocate memory a. free b. delete c. clear d. remove 9. what is the index no of the last element of an array with 29 elements a. 29 b. 28 c. 0 d. programmer defined
10. what is the final value of x when the code for(int x=0;x<10;x++)> void main() { char buffer[10]={"Genesis"}; printf("%d",&buffer[4]-(buffer)); } a. 3 b. 4 c. 0 d. illegal pointer subtraction 14. what is the output for #include
1. given a square matrix which consists only of 1 and 0......find which rows,which cols and which diagonals consist entirely of 1's. 2. given an array of integers find all possible combinations of the numbers whose sum equal to 90..... ans : knapsack problem (in data structures - aho ullman) Note : for them solution was not the criteria.......but the approach was important......the solution should be generalised and optimized........optimization was given the top priority........ here is the techincal paper : plz try to solve them urself by trying on comp. 1. const int MAX=10; main() {enum a {a,b,MAX}; print MAX; } 2. enum object is a const which can only be assigned a value at initialization or a variable which can be assigned any value in the middle of the program? 3. void *p; what operation cannot be performed on p? ans : arithmetic operation unless it is properly typecasted 4. char **p="Hello"; print p,*p,**p 5. main() {char str[]="Geneius"; print (str); } print(char *s) {if(*s) print(++s); printf("%c",*s); } 6. what does the function fcloseall() does ? 7. main() {printf("Genius %d",fun(123)); } fun(int n) {return (printf("%d",n)); } 8. difference between definition and declaration. 9. find the error? fun() {int i=10; if(i<10) a="9,b=" c="3,d;" d="(b-c)<(c-a)" 1="?" i="4;" i="i/4);" cols="?"> 4. Mention basic concepts of OOP. 5. What are messages in OOP?. 6. What is garbase collection?. 7.what is object?. 8. what is a class?.
section 4: 1. expand the following: a.SEI b. ISO 2. what are different levels of SEI?. 3. What is significance of ISO?> 4. Expand the following: a. WWW b. HTTP c. HTML d. TCP/IP 5. what is Black box testing?. 6. explain the following: 1. white box testing 2. white box testing 3. boundary testing 4 stress 5. negative 6. system 7. unit 8.module 9.destructive
1. what are the macros other than C macros (the macrosin word,excel) A macro in MS-word is used to group a sequenceof jobs and make it as a button or keyboard shortcut.Suppose, if you need always to draw a table containing2 rows and 5 cols, you can start,record a macro andmake it as a button and put in taskbar, sothat whenyou press it, you will be provided with a fixed table.
2. can you delete a column from a table. In oracle 9i, you can do it by the statementALTER TABLE table1 DROP COLUMN column1; In oracle8,you can't.
3. can you store a image in oracle and by whichdatatype? Yes, you can and it can be acheived by usinga BLOB (binary large object) type and store upto 4GBin a single column.
4. have you used reports and forms in oracle?
5. have you written applications to retrieve storedimages in a table?
6. some DOS commands and UNIX.
7. project desription (both academic andminiprojects,if any)
8. some situation questions like what would you do ifyour company is burning,etc.
English:analogy questions around ( you can refer to GRE book)fill the sentence with appropriate word..(multiple choices given)sentence correction..
Aptitude:arithmetic questions..some of the questions:Q:1/3th of the passengers gotdown at first stop and 30 people got into the bus, 1/4th of the passengers gotdown at second stop and 12 people got into the bus.in last stop 84 people got down from the bus.What is the initial capacity of the bus?
Q:one person is running around a 180 sq yard filed, first 1/4 his speed was 10KMPH second 1/4 20KMPH third 1/4 30 KMPH and the fourth 1/4 40 KMPH.what is the average speed?
NOTE: there was a question on milk ,water ratio..
logical deductions..Q: is x+y a prime? a. x is prime b. y is prime
options: 1. only "a" correct 2. only "b" correct 3. both are correct 4. both are wrong.
C,C++,JAVA
Q: There were 2 or 3 C programs and the question is to point error in the program or to predict the answer
Q:Which one of the following is not a storage type:1. static 2. register 3. stack 4.autoanswer: stack
Q:what is the type of the second parameter of fopen() function?
Q:Which of the following is correct about constructor?OPTIONS: 1.void type 2. return nothing 3..... 4.....answer 2
Q:how do we store a constant value in java?multiple choices given..answer: using "final"
SQL:please be thorough with SQL, PL/SQL
There were some questions where they gave query and asked whether it is correct or wrong if wrong what is wrong...
Q: create table...........;{table creation query)Roll back;what will be the output?options ....
1. how compiler treats variables of recursive functions2. what is orthogonal matrix?3. given two tables and asked 2 qns on those table , one is on join and another is on NOT IN4. given some qns on pointers( pretty easy)5. given five qns on data structures like , lifo, fifo 6. qtn on primary key 7. how NULL in sql is treated?8. given a doubly linked list and asked r->left->right->data ans: r->data9:explain const char *ptr and char *const ptr
1)declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end;What will be the output ?(a) equal(b) not equal(c) else(d) No outputCorrect Answer : (c)
2)declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=numto_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ? (a)12 (b)12345 (c)123 (d)Wrong assignmentCorrect Answer : (c)
1. question on bubble sore2. quick sort complexity3. heap sort SPACE complexity.
4. char *p = "Oracle India"; p[5] == 'l' ? printf("Orcle") : printf("India")
5. main(){ int i=5; recursive(i);}recursive(int u){ if(u > 0 ) recursive(u-1); printf("%d", u);}
6. question on function pointer. char *(*(*x())[])()7. GRANT command question8. about MINUS set operator.
Java
9. RandomAccessFile10. super class base class simple question11. what is overridden12. StringBUffer question
part 1: apptitute test -30question (20min)part 2: technical Test -30question (20min)
part 1:
1)find the range of x*x -5x+6>0X<=2 ; X >=3
2)if 5x*x+14*x+k=0 having two reciprocal roots find the value of k.
3&4)two sentence are given ,in between four sentence are given in change order . (like between 1 & 6 ,abcd four sentence are given 1 a b c d 6)
Find the correct order?
5)if first term of AP is 5 .16th term is 45.find the sum of first 16 terms.
6)x,y and z are odd no. not necessarly in sequence.then y=? (1)mean of x and z is 114. (2)mean of y and z is 113. Ans: 115
7)ram is 27 year old then mohan.after 7 year ram age is thrice as mohan age .find ram age?Ans : 67/2
8)if three tapes are filling a tank of capacity of 500lit with speed of 30lit/sec,48lit/sec and 36lit/sec. Find after how long time tank will fill?Ans : 500/114
9)find the root of given eq x-2/(x-1)=1-2/(x-2) if possible.Ans : x = 0
10)find the point of intersection of \ 15x+9y=15 5x+3y=21 Ans : NO
11)suppose in a pot 20 cards are there label 1-20 on that. find the probability of getting two prime.
Ans : 8/20 = 2 / 5
12)in an island three persons are there Jam ,Dam and Sam .sam having pencil,dam having cap and Jam having book .we have find who is author among them if. (1)Sam says ,Jam is author but author wearing cap. (2)Dam says ,I am author ,but author not having cap. (3)Sam says, I am author ,but author having note book. Find who is author? Ans : jam
13)Jo ,Do and So are three person.(1) So says Jo is football player, I also football player.(2) Do says Jo is football player, I also football player.(3) Jo says Do is football player, I also football player.Find the football player player among them.
Ans : jo
14-16)question based analogy . like LION:CUB find the pair in given choice.
17)in a basket 3 mangos,4 apples and 4 bananas are there. Find no of ways we select randomly 3 fruit from basket?
18) if a^x=b^y=c^z and b^2=ac then find x+z/xz=? Ans : 2/y
19)(loga)^2-(logb)^2 = ?
ans :- logab-loga/b
20)in a 60 liters of mixture of spirit and water is 7 %. in order to make water 19%,how much water should be added.(some thing like this)
21-25)A one and half page length passage will be given and 4 to 5 questions will be asked based on this passage.
26)
technical part:-==================pattern: 1) pl/sql--->7 quest 2) java--->5 quest 3) c & pointers--->9 quest 4) dbms and dfd's--->5 quest 5) ds--->4 quest
some quest are here:-
1.what is not a c- storage class
Ans.stack
2.if dba creates one user what are the privilages the user will get?
3. which keyword is used to const in java Ans. final
4.char *array[4]={"some string"}printf("%d",&array[4]-(array));
Ans.4
5.remote object will be in the package
Ans.java.net (verity it)
6.#define sq(a) (a*a)printf ("%d",sq (3+2));
Ans.11
7.#define max 20printf ("%d", ++max);
Ans.lvalue required --- error
8.printf ("%d",sizeof (2>3?4?:4:3?4:2));(some thing like this)
Ans.syntax error
9. what is important of free().
10.property of constructor in java program.
11.impotance of macro.
12.underfolw condition of stack.
(1)empty,2)push,3)pop,4)none)====================
1)Which of the following is not a storage class in C?
Static Register Extern Stack
2)Which of the following 'return' statement is correct?
return, return; return(1, 2, 3); return(return 4); (return 5, return 6);
3)The second argument to fopen() function is?
char const char * int * FILE *
4)What is the output of the program?
#include
void main() { char buffer[10] = {"Genesis"}; printf(" %d ", &buffer[4]- (buffer)); }
3 4 0 Illegal pointer subtraction 4
5)If "arr" is an array of 5 x 5 dimension, arr[2][4] is same as
**(a+3+4) *(a+3)+*(a+4) **(a+3)+4 *(*(a+2)+4)
-----------------------------------------------------APTITUDE 30 questions
Log37 1: ------- = ? ( Log67 ) 1 + Log32
2: log(a-b) = log a - log b; then a = ? (b/(b2+1));
3: 3 black 7 white balls ......... prob of drawing 2 white balls ? (7/15)
4: In a lock of 4 rings there r five characters howmany unsuccessful attempts can be made ? (624)...
5: sqrt(6+sqrt(6+sqrt (6 + .................))))) = ? 3
6: a solution is prepared by mixing two solution with sprit 20% & 60%...In what ration they should be mixed to get the 50% spritin resultant solution .(1:3)
7: X2 - (A-3)X +(A+3) = 0for what value of A the sum of square of roots will beleast ? (A=2);
8: 'a' number of persons work daily 'b' hours toproduce 'c' items. If 'd' persons walks away from the group what will be thenumber of hours to produce 'c' items. ? (ab/(a-d))
9: - 13 Passage
14 - 18 venn diagram.
19-22 picking based (VERBAL);
23-25 picking odd once out (words )
26: m = ax , n = ay mxny = a2(x+y) find 1/x + 1/y? (1)
27 xy - 2y - 6 =0;x <> 2 x >2 ...y is always postive.
28 The diameter of circle can be determined from 1.area.2.circumference.
Ans either of them..
29:
sum of 2 no. is 7 & product s 10 fnd larger number.
30:
--------------------------------------------------------
TECHNCAL :
It will be really tough. They will manly concentrate on PL/SQLJava.C.
1. Output of the following program is
main(){ int i=0; for(i=0;i<20;i++) g1="FirstString" g1="g();" file="export.dmp" indexfile="newrite.sql." ratio =" (Logical" log_archive_format =" arch" log_archive_dest =" path." name =" ''" item =" PARAMETER" module="old_lib.pll" userid="scott/tiger">> if fvar is null then <<>> svar := svar + 5 end if; End;
What will be the value of svar after the execution ? a] Error b] 10 c] 5 d] None of the above
Ans : A
52. Which of the following is not correct about an Exception ? a] Raised automatically / Explicitly in response to an ORACLE_ERROR b] An exception will be raised when an error occurs in that block c] Process terminates after completion of error sequence. d] A Procedure or Sequence of statements may be processed.
Ans : C
53. Which of the following is not correct about User_Defined Exceptions ? a] Must be declared b] Must be raised explicitly c] Raised automatically in response to an Oracle error d] None of the above
Ans : C
54. A Stored Procedure is a a] Sequence of SQL or PL/SQL statements to perform specific function b] Stored in compiled form in the database c] Can be called from all client environmets d] All of the above
Ans : D
55. Which of the following statement is false a] Any procedure can raise an error and return an user message anderror number b] Error number ranging from 20000 to 20999 are reserved for userdefined messages c] Oracle checks Uniqueness of User defined errors d] Raise_Application_error is used for raising an user defined error.
Ans : C
56. Is it possible to open a cursor which is in a Package in anotherprocedure ? a] Yes b] No
Ans : A
57. Is it possible to use Transactional control statements in DatabaseTriggers ? a] Yes b] No
Ans : B
58. Is it possible to Enable or Disable a Database trigger ? a] Yes b] No
Ans : A
59. PL/SQL supports datatype(s) a] Scalar datatype b] Composite datatype c] All of the above d] None of the above
Ans C
60. Find the ODD datatype out a] VARCHAR2 b] RECORD c] BOOLEAN d] RAW
Ans : B
61. Which of the following is not correct about the "TABLE" datatype ? a] Can contain any no of columns b] Simulates a One-dimensional array of unlimited size c] Column datatype of any Scalar type d] None of the above
Ans : A
62. Find the ODD one out of the following a] OPEN b] CLOSE c] INSERT d] FETCH
Ans C
63. Which of the following is not correct about Cursor ? a] Cursor is a named Private SQL area b] Cursor holds temporary results c] Cursor is used for retrieving multiple rows d] SQL uses implicit Cursors to retrieve rows
Ans : B
64. Which of the following is NOT VALID in PL/SQL ? a] Select ... into b] Update c] Create d] Delete
Ans : C
65. What is the Result of the following 'VIK'NULL'RAM' ? a] Error b] VIK RAM c] VIKRAM d] NULL
Ans : C
66. Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a <> ( Select count(*) from Emp E2 where E1.SAL > E2.SAL ) will retrieve a] 3500,5000,2500 b] 5000,2850 c] 2850,5750 d] 5000,5750
Ans : A
72. Is it possible to modify a Datatype of a column when column containsdata ? a] Yes b] No
Ans B
73. Which of the following is not correct about a View ? a] To protect some of the columns of a table from other users b] Ocuupies data storage space c] To hide complexity of a query d] To hide complexity of a calculations
Ans : B
74. Which is not part of the Data Definiton Language ? a] CREATE b] ALTER c] ALTER SESSION
Ans : C
75. The Data Manipulation Language statements are a] INSERT b] UPDATE c] SELECT d] All of the above
Ans : D
76. EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH A500 BALAJI 5750
Using the above data Select count(sal) from Emp will retrieve a] 1 b] 0 c] 3 d] None of the above
Ans : C
77. If an UNIQUE KEY constraint on DATE column is created, will it acceptthe rows that are inserted with SYSDATE ? a] Will b] Won't
Ans : B
78. What are the different events in Triggers ? a] Define, Create b] Drop, Comment c] Insert, Update, Delete d] All of the above
Ans : C79. What built-in subprogram is used to manipulate images in image items ? a] Zoom_out b] Zoom_in' c] Image_zoom d] Zoom_image
Ans : C
80. Can we pass RECORD GROUP between FORMS ? a] Yes b] No
Ans : A
81. SHOW_ALERT function returns a] Boolean b] Number c] Character d] None of the above
Ans : B
82. What SYSTEM VARIABLE is used to refer DATABASE TIME ? a] $$dbtime$$ b] $$time$$ c] $$datetime$$ d] None of the above
Ans : A
83. :SYSTEM.EFFECTIVE.DATE varaible is a] Read only b] Read & Write c] Write only d] None of the above
Ans : C
84. How can you CALL Reports from Forms4.0 ? a] Run_Report built_in b] Call_Report built_in c] Run_Product built_in d] Call_Product built_in
Ans : C
85. When do you get a .PLL extension ? a] Save Library file b] Generate Library file c] Run Library file d] None of the above
Ans : A
86. What is built_in Subprogram ? a] Stored procedure & Function b] Collection of Subprogram c] Collection of Packages d] None of the above
Ans : D
87. GET_BLOCK property is a a] Restricted procedure b] Unrestricted procedure c] Library function d] None of the above
Ans : D
88. A CONTROL BLOCK can sometimes refer to a BASETABLE ? a] TRUE b] FALSE
Ans : B
89. What do you mean by CHECK BOX ? a] Two state control b] One state control c] Three state control d] none of the above
Ans : C - Please check the Correcness of this Answer ( The correct answeris 2 )
90. List of Values (LOV) supports a] Single column b] Multi column c] Single or Multi column d] None of the above
Ans : C
91. What is Library in Forms 4.0 ? a] Collection of External field b] Collection of built_in packages c] Collection of PL/SQl functions, procedures and packages d] Collection of PL/SQL procedures & triggers
Ans : C
92. Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger ? a] Yes b] No
Ans : B
93. Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ? a] Yes b] No
Ans : B
94. What type of file is used for porting Forms 4.5 applications to variousplatforms ? a] .FMB file b] .FMX file c] .FMT file d] .EXE file
Ans : C
95. What built_in procedure is used to get IMAGES in Forms 4.5 ? a] READ_IMAGE_FILE b] GET_IMAGE_FILE c] READ_FILE d] GET_FILE
Ans A
96. When a form is invoked with CALL_FORM does Oracle forms issuesSAVEPOINT ? a] Yes b] No
Ans : A
97. Can we attach the same LOV to different fields in Design time ? a] Yes b] No
Ans : A
98. How do you pass values from one form to another form ? a] LOV b] Parameters c] Local variables d] None of the above
Ans : B
99. Can you copy the PROGRAM UNIT into an Object group ? a] Yes b] No
Ans : B
100. Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ? a] Yes b] No
Ans : A
101. When is a .FMB file extension is created in Forms 4.5 ? a] Generating form b] Executing form c] Save form d] Run form
Ans : C
102. What is a Built_in subprogram ? a] Library b] Stored procedure & Function c] Collection of Subprograms d] None of the above
Ans : D
103. What is a RADIO GROUP ? a] Mutually exclusive b] Select more than one column c] Above all TRUE d] Above all FALSE
Ans : A
104. Identify the Odd one of the following statements ? a] Poplist b] Tlist c] List of values d] Combo box
Ans : C
105. What is an ALERT ? a] Modeless window b] Modal window c] Both are TRUE d] None of the above
Ans : B
106. Can an Alert message be changed at runtime ? a] Yes b] No
Ans : A
107. Can we create an LOV without an RECORD GROUP ? a} Yes b] No
Ans : B
108. How many no of columns can a RECORD GROUP have ? a] 10 b] 20 c] 50 d] None of the above
Ans D
109. Oracle precompiler translates the EMBEDDED SQL statemens into a] Oracle FORMS b] Oracle REPORTS c] Oracle LIBRARY d] None of the above
Ans : D
110. Kind of COMMENT statements placed within SQL statements ? a] Asterisk(*) in column ? b] ANSI SQL style statements(...) c] C-Style comments (/*......*/) d] All the above
Ans : D
111. What is the appropriate destination type to send the output to aprinter ? a] Screen b] Previewer c] Either of the above d] None of the above
Ans : D
112. What is TERM ? a] TERM is the terminal definition file that describes the terminalfrom which you are using R20RUN ( Reports run time ) b] TERM is the terminal definition file that describes the terminalfrom which you are using R20DES ( Reports designer ) c] There is no Parameter called TERM in Reports 2.0 d] None of the above
Ans : A
113. If the maximum records retrieved property of a query is set to 10,then a summary value will be calculated a] Only for 10 records b] For all the records retrieved c] For all therecords in the referenced table d] None of the above
Ans : A
114. With which function of a summary item in the COMPUTE AT optionrequired ? a] Sum b] Standard deviation c] Variance d] % of Total function
Ans : D
115. For a field in a repeating frame, can the source come from a columnwhich does not exist in the datagroup which forms the base of the frame ? a] Yes b] No
Ans : A
116. What are the different file extensions that are created by OracleReports ? a] .RDF file & .RPX file b] .RDX file & .RDF file c] .REP file & .RDF file d] None of the above
Ans : C
117. Is it possible to Disable the Parameter form while running the report? a] Yes b] No
Ans : A
118.What are the SQL clauses supported in the link property sheet ? a] WHERE & START WITH b] WHERE & HAVING c} START WITH & HAVING d] WHERE, START WITH & HAVING
Ans : D
119. What are the types of Calculated columns available ? a] Summary, Place holder & Procedure column b] Summary, Procedure & Formula columns c] Procedure, Formula & Place holder columns d] Summary, Formula & Place holder columns
Ans.: D
120. If two groups are not linked in the data model editor, what is thehierarchy between them? a] There is no hierarchy between unlinked groups b] The group that is right ranks higher than the group that is to theleft c] The group that is above or leftmost ranks higher than the groupthat is to right or below it d] None of the above
Ans : C
121. Sequence of events takes place while starting a Database is a] Database opened, File mounted, Instance started b] Instance started, Database mounted & Database opened c] Database opened, Instance started & file mounted d] Files mounted, Instance started & Database opened
Ans : B
122. SYSTEM TABLESPACE can be made off-line a] Yes b] No
Ans : B
123. ENQUEUE_RESOURCES parameter information is derived from a] PROCESS or DDL_LOCKS & DML_LOCKS b] LOG BUFFER c] DB_BLOCK_SIZE d] DB_BLOCK_BUFFERS
Ans : A
124. SMON process is used to write into LOG files a] TRUE b] FALSE
Ans : B
125. EXP command is used a] To take Backup of the Oracle Database b] To import data from the exported dump file c] To create Rollback segments d] None of the above
Ans : A
126. SNAPSHOTS cannot be refreshed automatically a] TRUE b] FALSEAns : B127. The User can set Archive file name formats a] TRUE b] FALSE
Ans : A
128. The following parameters are optional in init.ora parameter fileDB_BLOCK_SIZE, PROCESS a} TRUE b] FALSE
Ans : B129. NOARCHIEVELOG parameter is used to enable the database in Archievemode a] TRUE b] FALSE
Ans : B
130. Constraints cannot be exported through Export command? a] TRUE b] FALSE
Ans : B
131. It is very difficult to grant and manage common priveleges needed bydifferent groups of database users using roles a] TRUE b] FALSE
Ans : B
132. The status of the Rollback segment can be viewed through a] DBA_SEGMENTS b] DBA_ROLES c] DBA_FREE_SPACES d] DBA_ROLLBACK_SEG
Ans : D
133. Explicitly we can assign transaction to a rollback segment a] TRUE B] FALSE
Ans : A
134. What file is read by ODBC to load drivers ? a] ODBC.INI b] ODBC.DLL c] ODBCDRV.INI d] None of the above
Ans : A
1. precedence of PL/SQL2.in an employee table consisting of empid and supid to get supervisor id for employee (something like this related to ans. self join) we would useIntersectunionjoin subquery3.The order of execution in corelated queriesInner query executes first then outer query Outer query executes first then inner query each row of inner query is evaluated with outer queryeach row of outer query is evaluated with inner query4.declare i Number j Number k Numberbegin i:=0 for j = 1..5 i:=i+1; j:=j+1;k:=i+j+k;..........5.function of ROLLUP and CUBE6.Based on Group by clause rule that it should contain column found in select clause7.Can procedure in a package be overloaded8.public void static main(String []args){String s1=new String("test");String s2=new String("test");if(s1==s2)System.out.println("Both are equal");Boolean b1=new Boolean("true");Boolean b2=new Boolean("false");if(b1.equals(b2))System.out.println("some message");}output=?9.x=7;y=0;if(x=y)y=7;elsey=5;what is the value of y10.Threading in java a prg was given in which it had no exceptions and run function had string as its parametera.runtime errorb.compile time errorc.d.
11.what fuction can be repeated instead of comment....{public void aMethod(String S,int i);//here....}a.public void aMethod(int i ,String S);b.public void aMethod(String myobj,int j);c.public int aMethod(String S,int i);d.public void AMethod(String S,int i);12.Encapsulation is implemented bya.private variables and public methodsb.private variables and private methodsc.public variables and public methodsd.protected members13.Based on scope of a variable14.Recursive fuction are used to a.call itselfb.call other functionsc.return integersd....15.int a[]={0,1,2,3,4,5}int *pa=a;which of the following is not the correct way to accessa.a[5]b.*(a+5)c.*(pa+5)d.*(*pa+5)16.struct{char emp[12];int mpno;}e;struct e a[2]={{jack,2},{raj,8},{jill,2}}struct e *p;*p=a;p+=2......17.AVL tree is a balanced binary search tree18.order of B+tree19.Disadvantage of indexed sequential file20.queue can be called as full even if its capacity is'nt
posted by Arjun | 11:12 PM
0 Comments:
Post a Comment
<< Home