Oracle Recent placement papers top1

Oracle Recent placement papers top1

GRADUATION DATE
Cuurently the table is empty. You have decided that
null values should not be allowed in NAME column.
Which statement restricts NULL Values from being
entered into Column?
a) ALTER TABLE student ADD CONSTRAINT name (NOTNULL);
b) ALATER TABLE studnet ADD ConSTRAINT NOT NULL(name);
c) ALTER TABLE studnet MODIFY CONSTRAINT name(NOT
NUL);
D) ALTER TABLE student MONDIFY(namevarchar2(25) NOT
NULL);
2) YOu have decided to permamently remove all the data
from the above STUDENT table and you need the
structure in the future. Which single command perform
this?
a) DROP TABLE Student;
d) TRUNCATE TABLE student;
c) DELETE* from Student;
d) TRUNCATE TABLE student KEEP STRUCTURE;
e) DELETE * from STudent kEEP STRUCTURE;
3) The structure of the DEPT table is asfollows
NAME NULL TYPE
Deptno Not Null Number(2)
Dname varchar2(14)
Loc varchar2(13)
Examine the code
Declare
Type dept_record is record(dno number,name
varchar2(20));
Dept_rec dept_record;
BEGIN
Select deptno,dname
INTO dept_rec
FROM dept
WHERE deptno=10;
END;
Which of the following Statement Displays the name of
the selected department ?
<>
4) How would you declare a PL/SQL table of records to
holdthe rows selectd from the EMP table ?
5) Which statement about Implicit cursor is true ?
a) Implicit cursors are declared implicitly only from
DML
b) Implicit cursors are dclared implicitly for all the
DML and SELECT statements
c) Programmers needs to close all implicit cursors
before the end of PL/SQL programs
d) Programmers can declare Implicit cursors by using
cursor type in declaraion section
6) Evaluate this PL/SQL Block
Declare
V_Result number(2)
BEGIN
DELETE
FROM EMPLOYEES
WHERE department id (20,30,80);
V_result:=SQL%ROWTYPE;
COMMIT;
END;
/
What will be the value of v_result if no rows are
selected
a) 0 b) 1 c) TRUE d) NULL
7) Which two conditions in a PL/SQL block cause an
exception error to occur ? ( Choose 2 )
a) Select statement does not return a row
b) select stmt returns more than one row
c) select statement contaains a group by clause
d) seelct statenent donot have where clause
e) data type in the select list are inconsistent whith
data types in the into clause




DBMS/ RDBMS
-----------
1)You are requested to use the HIERARCHIAL DATABSE
model for the Human Resource DBMS System . Since your
entity relationship model for the system reveal that
most of the entities have many-o-many relationships
between them, you do not approve TOm,s
request.Referring to the above scenario,what is the
REASON behind your decision ?
<>

2) Which one of the following mechanisms in aRDBMS
ensure
a) 1 Constraints b) Locking c) Views d) Indexes
3) How does a data base stor information that is
related to the location of its tables
a) 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 given
You are asked to mintain a relationship between Table
A & B. Referring to the gien table, which field will
you choose as the primary key for Table A
<>

5) You have been asked to remove all aggregate
functions from your SQL statements refering to the
scenario above. WHich one of the following do you need
to 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 in the stack");
scanf("%d",&current);
puts("Enter elements");
for (top=1;top<=current;top++)
{scanf("%d",&item);
stack[top]=item;
}
top--;
for(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 BINARY
TREE?


Oracle Corporation

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.