软件工程师笔试题_2010

B
SNMP
C HTTP
D
HTTPS
B
SMTP ftp
C IMAP
D MPLS
B
list
C !dir
D ping
!list 127.0.0.1 IP ping
IP A TCP/IP C 8. A 100.0.0.0 9. 2350AD9FE0 B 172.15.0.0 C 192.168.0.0 D LabAP 244.0.0.0 B D DNS
PD
H F-XC A N GE
PD
H F-XC A N GE
O W !
N
y
bu
to
k
lic
C
m
C
lic
k
to
bu
y
N
.c
O W !
w
.d o
w
o
Biblioteka Baidu.d o
c u-tr a c k
c u-tr a c k
.c
____________
) 1. IP A 2. PC A 3. B B
____________
4. You need to perform a major update on the EMPLOYEE table. You have decided to disable the PRIMARY KEY constraint on the empid column and the CHECK constraint on the job column. What happens when you try to enable the constraints after the update is completed? A: You need to recreate the constraints once they are disabled. B: Any existing rows that do not confirm with the constraints are automatically deleted. C: Only the future values are verified to confirm with the constraints, leaving the existing values unchecked. D: The indexes on both the columns with the PRIMARY KEY constraint and the CHECK constraint are automatically re-created. E: All the existing column values are verified to confirm with the constraints and an error message is generated if any existing values do not confirm. 5. In which section of a PL/SQL block is a user-defined exception raised? A: heading BEGIN FOR employee_record IN salary_cursor LOOP employee_id_table(employee_id) := employee_record.last_name; END LOOP; CLOSE salary_cursor; END; Why does this section cause an error? A: The cursor needs to be opened. C: Terminating conditions are missing. B: No FETCH statements were issued. D: The cursor does not need to be closed. B: executable C: declarative D: exception handling
2. The EMP table contains columns to hold the birth date and hire date of employees. Both of these columns are defined with DATE as their datatype. You want to insert a row with the details of employee Smith who was born in 1944 and hired in 2004. Which statement will ensure that values are inserted into the table in the correct century? A: INSERT INTO EMP(empno, ename, birthdate, hiredate) VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', '12-DEC-44', '10-JUN-04'); B: INSERT INTO EMP(empno, ename, birthdate, hiredate) VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', TO_DATE('12-DEC-44','DD-MON-RR'), TO_DATE('10-JUN-04','DD-MON-RR')); C: INSERT INTO EMP(empno, ename, birthdate, hiredate) VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', TO_DATE('12-DEC-44','DD-MON-YY'),
w
o
.d o
c u-tr a c k
.c
9. Which view should a user query to display the columns associated with the constraints on a table owned by the user? A: USER_CONSTRAINTS D: USER_CONS_COLUMNS B: USER_OBJECTS E: USER_COLUMNS C: ALL_CONSTRAINTS
WEP WEP
1.
Which statement is true when writing a cursor FOR loop? A: You must explicitly fetch the rows within a cursor FOR loop. B: You must explicitly open the cursor prior to the cursor FOR loop. C: You must explicitly close the cursor prior to the end of the program. D: You do not explicitly open, fetch or close the cursor within a cursor FOR loop . E: You must explicitly declare the record variable that holds the row returned from the cursor.
2/8
o
m
w
w
w
w
PD
H F-XC A N GE
PD
H F-XC A N GE
O W !
N
y
bu
C
m
C
TO_DATE('10-JUN-04','DD-MON-YY'));
w
w
to
k
lic
lic
k
to
bu
y
N
.c
O W !
w
.d o
c u-tr a c k
D: INSERT INTO EMP(empno, ename, birthdate, hiredate) VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', TO_DATE('12-DEC-1944','DD-MON-YYYY'), TO_DATE('10-JUN-04','DD-MON-RR'));
6. Given this executable section of a PL/SQL block:
7. Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? A: SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual; B: SELECT TO_DATE(SYSDATE,'yyyy') FROM dual; C: SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual; D: SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual; E: SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual; 8. Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP
10. What is true of using group functions on columns that contain NULL values? A: Group functions on columns ignore NULL values. B: Group functions on columns returning dates include NULL values. C: Group functions on columns returning numbers include NULL values. D: Group functions on columns cannot be accurately used on columns that contain NULL values. E: Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS. JAVA 1. A. long number = 345L; C. long number = 0345L; A. 010 B. 0x10 C. 08 ) B. long number = 0345; D. long number = 0x345L D. 0x8
1/8
o
m
w
w
w
w
PD
H F-XC A N GE
PD
H F-XC A N GE
O W !
N
y
bu
to
k
lic
C
m
C
lic
k
to
bu
y
N
.c
O W !
w
.d o
w
o
.d o
c u-tr a c k
c u-tr a c k
.c
A SSID B SSID C SSID D SSID
LabAP 2350AD9FE0 LabAP 2350AD9FE0 ) WEP WEP
w
o
.d o
c u-tr a c k
.c
3.
You are a user of the PROD database which contains over 1000 tables, and you need to determine the number of tables you can access. Which data dictionary view could you query to display this information? A: USER_OBJECTS B: ALL_OBJECTS C: DBA_SEGMENTS D: DBA_TABLES
3/8
o
m
w
w
PD
H F-XC A N GE
PD
H F-XC A N GE
O W !
N
y
bu
C
m
C
WHERE EMP_ID = 1001;
w
w
to
k
lic
lic
k
to
bu
y
N
.c
O W !
w
.d o
c u-tr a c k
If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed? A: 17000.00 D: **17000.00 B: 17000***** E: an error statement C: ****170.00
________
_______
C
D
C 16
D
202.100.192.0/20
1 A 255.255.240.0 C 255.255.254.0 2 A 30 4. B 62
B D
255.255.224.0 255.255.255.0 D 510 Web
C 254
A POP 5. A POP3 6. Windows A dir 7. ping