- ·上一篇知名企业资料：dell面经(2006年11月25日)
- ·下一篇知名企业资料：汉王研究人员笔试题
EDS 2007招聘网申笔试题
作者：佚名 来源：本站整理 发布时间：2007-4-27 22:20:00
1. Which one is correct according to Stack and Queue?
A. Stack is FILO, while Queue is FIFO
B. Stack is FIFO, while Queue is FILO
C. Both Stack and Queue are FILO
D. Both Stack and Queue are FIFO
2. Which one is running at server side?
A. HTML
B. Java Script
C. CGI
D. Java Applet
3. Which one describes the characteristics of OOP (Object Oriented Programming) ?
A. Simple, Structural, Efficient.
B. Encapsulation, Inheritance, Polymorphism
C. Modularization, Inheritance, Simple
D. Efficient, Structural, Encapsulation
4. Using index onto the table can:
A. Improve data query performance.
B. Improve data insert performance.
C. Improve both query and insert performance.
D. Improve data insert performance and reduce data query performance.
5. Which one is the default port number of HTTP?
A. 65535
B. 8080
C. 64
D. 80
6. Which one is used to maintain one to many relationship between two tables?
A. Primary Key
B. Foreign Key
C. Middle table
D. Composite Key
7. Which one is used to maintain many to many relationship between two tables?
A. Primary Key
B. Foreign Key
C. Middle table
D. Composite Key
8. Socket programming is based on:
A. HTTP
B. TCP/IP
C. FTP
D. Telnet
9. What data format can be transmitted via Internet?
A. Only binary data
B. Only text data
C. Both binary and text data
D. Only HTML pages.
10. Observe the tree below,
What is the preorder traversal?
A. ABCDEFGHI
B. BCAFEGDIH
C. CBFGEIHDA
D. ABDCEHFGI
11. Observe the link L below,
If we want to insert Q after P, the code should be:
A. P->next = Q;
Q->next = P->next;
B. Q->next = P->next;
P->next = Q;
C. P = Q;
Q->next = P->next;
D. Q = P->next;
P->next = Q;
12. #define square(x) x*x
main()
{
int i;
i = 64/square(4);
printf("%d",i);
}
Answer:
A 64 B 32 C 16 D 4
13. enum colors {BLACK,BLUE,GREEN}
main()
{
printf("%d..%d..%d",BLACK,BLUE,GREEN);
return(1);
}
Answer:
A. 1..2..3 B. 2..1.. 0 C. 0..1..2 D. 3..2..1
14. main()
{
int i=-1;
+i;
printf("i = %d, +i = %d \n",i,+i);
}
Answer:
A. i=0, +i=1 B i = -1, +i = 0 C i = 1, +i = 1 D i = -1, +i = -1
15. main()
{
int y;
scanf("%d",&y); // input given is 2000
if( (y%4==0 && y%100 != 0) || y%100 == 0 )
printf("%d is a leap year");
else
printf("%d is not a leap year");
}
Answer:
2000 is a leap year
A. 2000 is a leap year
B. 2000 is not a leap year
16. main()
{
int i=3;
switch(i)
{
default:printf("zero");
case 1: printf("one");
break;
case 2:printf("two");
break;
case 3: printf("three");
break;
}
}
Answer :
A zero B two C three D one (All in lower case)
17. What is the value of ‘comm’ and ‘sal’ after executing the following query if the initial value of ‘sal’ is 10000?
UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;
Answer : sal = 11000, comm = 1000
A. sal = 11000, comm = 1000 B. sal = 11000, comm = 1100
C. sal = 10000, comm = 1000 D. sal = 1000, comm = 1100
18. Table : PROGRAMMER
PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER)
(Add some description )
DOB means Date of Birth.
PROF1 and PROF2 indicate two kind of techniques the people knows. For example, PROF1=’C’, PROF2=’C++’.
Construct SQL query to Display the details of those who don’t know C, C++ or Pascal?
Answer:
A. SELECT * FROM PROGRAMMER WHERE PROF1 NOT IN (''C'',''C++'',''PASCAL'') AND PROF2 NOT IN (''C'',''C++'',''PASCAL'');
B. SELECT * FROM PROGRAMMER WHERE PROF1 NOT IN (''C'',''C++'',''PASCAL'') OR PROF2 NOT IN (''C'',''C++'',''PASCAL'');
C. SELECT * FROM PROGRAMMER WHERE (PROF1 <> ‘C’ AND ‘C++’ AND ‘PASCAL’) AND (PROF1 <> ‘C’ AND ‘C++’ AND ‘PASCAL’);
D. SELECT * FROM PROGRAMMER WHERE (PROF1 <> ‘C’ AND ‘C++’ AND ‘PASCAL’) OR (PROF1 <> ‘C’ AND ‘C++’ AND ‘PASCAL’);
19. Table : EMP
EMPNO (NOT NULL , NUMBER(4)), ENAME (VARCHAR2(10)),
JOB (VARCHAR2(9)), MGR (NUMBER(4)), HIREDATE (DATE),
SAL (NUMBER(7,2)), COMM (NUMBER(7,2)), DEPTNO (NUMBER(2))
List the employee details if and only if more than 10 employees are present in department no 10?
Answer:
A. SELECT * FROM EMP WHERE DEPTNO IN (SELECT DEPTNO FROM EMP GROUP BY DEPTNO HAVING COUNT(EMPNO)>10 AND DEPTNO=10);
B. SELECT * FROM EMP WHERE DEPTNO = 10 AND COUNT(EMPNO)>10;
C. SELECT * FROM EMP WHERE MIN(EMPNO) = 10 AND DEPTNO = 10;
D. SELECT * FROM EMP WHERE MIN(EMPNO) = 10 AND DEPTNO = 10 GROUP BY DEPTNO;
20. List the highest salary paid for each job?
Answer:
A. SELECT JOB, MAX(SAL) FROM EMP;
B. SELECT JOB, MAX(SAL) FROM EMP GROUP BY JOB;
C. SELECT JOB, SAL FROM EMP ORDER BY SAL;
D. SELECT JOB, SAL FROM EMP ORDER BY SAL GROUP BY JOB;
请在邮件中注明:信息来自Byszp.COM
[各地求职生活指南]
[进入查询知名企业资料]
