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 ",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 &lsquoASCAL’) AND (PROF1 <> ‘C’ AND ‘C++’ AND &lsquoASCAL’);
D. SELECT * FROM PROGRAMMER WHERE (PROF1 <> ‘C’ AND ‘C++’ AND &lsquoASCAL’) OR (PROF1 <> ‘C’ AND ‘C++’ AND &lsquoASCAL’);
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;