Placement Papers - ORACLE

Why ORACLE Placement Papers?

Learn and practice the placement papers of ORACLE and find out how much you score before you appear for your next interview and written test.

Where can I get ORACLE Placement Papers with Answers?

IndiaBIX provides you lots of fully solved ORACLE Placement Papers with answers. You can easily solve all kind of placement test papers by practicing the exercises given below.

How to solve ORACLE Placement Papers?

You can easily solve all kind of questions by practicing the following exercises.

ORACLE PLACEMENT PAPER (TECHNICAL- SQL)

Posted By : Aabhas Rating : +19, -11

PAPER: ORACLE PLACEMENT PAPER (TECHNICAL- SQL)

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++) is
run?
a. 10
b. 9
c. 0
d. 1

11. what is the data type of FILE?
a. integer
b. union
c. pointer
d. structure

12. if "a" is an array of 5*5 dimension, a[2][4] is same as
a. **(a+2+4)
b. *(a+2) + *(a+4)
c. **(a+2)+4
d. *(*a+2)+4)

13. what is the output of ..
#include  
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("
%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 doubly 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
 

Like this page? +19 -11




Companies List:

3i Infotech - AAI - ABACUS - ABB - Accel Frontline - Accenture - Aditi - Adobe - ADP - Agreeya - Akamai - Alcatel Lucent - Allfon - Alumnus - Amazon - Amdocs - AMI - Andhra Bank - AppLabs - Apps Associates - Aricent - Ashok Leyland - Aspire - Atos Origin - Axes - Bajaj - Bank of Maharashtra - BEL - BEML - BHEL - BirlaSoft - Blue Dart - Blue Star - BOB - BPCL - BPL - Brakes - BSNL - C-DOT - Cadence - Calsoft - Canara Bank - Canarys - Capgemini - Caritor - Caterpillar - CDAC - CGI - Changepond - Ciena - Cisco - Citicorp - CMC - Consagous - Convergys - CORDYS - Crompton - CSC - CTS - Cummins - Dell - Deloitte - Delphi-TVS - DeShaw - Deutsche - Dotcom - DRDO - EDS - EIL - ELGI - ELICO - ERICSSON - Essar - Fidelity - Flextronics - Freescale - FXLabs - GAIL - GE - Genpact - Geodesic - Geometric - Globaledge - GlobalLogic - Godrej - Google - Grapecity - HAL - HCL - Hexaware - Honeywell - HP - HPCL - HSBC - Huawei - Hughes - IBM - IBS - ICICI - iGate - Impetus - iNautix - Indian Airforce - Indian Airlines - Infosys - Infotech - Intec - Integra - Intergraph - IOCL - iSOFT - ISRO - Ittiam - JSW - Keane - Kenexa - L & T - L & T Infotech - LG Soft - Lifetree - LionBridge - Mahindra Satyam - Mastek - Maveric - McAfee - MECON - Microsoft - MindTree - Miraclesoft - Mistral - Motorola - Mphasis - MTNL - NIC - Nokia Siemens - Novell - NTPC - Nucleus - ORACLE - Patni - Perot - Polaris - Ramco - Robert Bosch - Samsung - SAP - Sapient - Sasken - SBI - Sierra Atlantic - Sonata - Sony India - Sutherland - Syntel - TCS - Tech Mahindra - VeriFone - Virtusa - Wipro - Zensar.