ORACLE CORPORATION
-------------------------------------

COMPANY PROFILE
-------------------------------------------------------
Oracle Corporation is one of the major companies developing database management systems (DBMS), tools for database development, middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software.As of 2005 it ranked as the world's second[citation needed] largest software company. Oracle was founded in 1977 and it has offices in more than 145 countries around the world. As of 2008, it employed more than 70,000 people worldwide.

Lawrence J. Ellison (Larry Ellison) is Oracle's CEO.

Oracle in India
----------------
Hyderabad is the main centre of Oracle in India
Bangalore

Technical Paper-Sample 1
--------------------------------------------
1. The purpose of defining an index is
(A) Enhance Sorting Performance (B) Enhance Searching Performance
(C) Achieve Normalization (D) All of the above

2. A transaction does not necessarily need to be
(A) Consistent (B) Repeatable (C) Atomic (D) Isolated

3. To group users based on common access permission one should use
(A) User Groups (B) Roles (C) Grants (D) None of the above

4. PL/SQL uses which of the following
(A) No Binding (B) Early Binding (C) Late Binding (D) Deferred Binding

5. 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

6. 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.

7. 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.

8 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.

9. Roll Back segment is not used in case of a
(A) DCL Statements. (B) DML Statements. (C) DDL Statements. (D) all of the above.

10. 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.

11.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.

12.enum number { a=-1, b=4, c,d,e,} what is the value of e?
(A) 7 (B) 4 (C) 5 (D) 3

13.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.

14.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.

15.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) {....}

Output of the following program is
main()
{
int i=0;
for(i=0;i<20;i++)
{
switch(i)
{
case 0:
i+=5;
case 1:
i+=2;
case 5:
i+=5;
default:
i+=4;
break;
}
}
}
(A) 5,9,13,17 (B) 12,17,22 (C) 16,21 (D) syntax error.

16.What does the following function print?
func(int i)
{
if(i%2) return 0;
else return 1;
}
main()
{
int i=3;
i=func(i);
i=func(i);
printf("%d",i);
}
(A) 3 (B) 1 (C) 0 (D) 2

17.What will be the result of the following program?
char*g()
{
static char x[1024];
return x;
}
main()
{
char*g1="First String";
strcpy(g(),g1);
g1=g();
strcpy(g1,"Second String");
printf("Answer is:%s", g());
}
(A) Answer is: First String (B) Answer is: Second String
(C) Run time Error/Core Dump (D) None of these

Consider the following program
main()
{
int a[5]={1,3,6,7,0};
int *b;
b=&a[2];
}
The value of b [-1] is
(A) 1 (B) 3 (C) -6 (D) none

18. Given a piece of code
int x[10];
int *ab;
ab=x;

19. To access the 6th element of the array which of the following is incorrect?
(A) *(x+5) (B) x[5] (C) a[5] (D) *(*a+5}.

20. What is the output of the following code
#define sq (a) (a*a)
printf (“%d”, sq (3+2));

Stumble Upon Toolbar

Related Posts by Categories



Widget by Hoctro | Jack Book

Comments (0)