软件工程师笔试题_2010.pdf

1 8 1 IP 1 IP A B C D 2 PC 2 PC A B C D 3 202 100 192 0 20 16 3 202 100 192 0 20 16 1 A 255 255 240 0 B 255 255 224 0 C 255 255 254 0 D 255 255 255 0 2 A 30 B 62 C 254 D 510 4 Web 4 Web A POP B SNMP C HTTP D HTTPS 5 5 A POP3 B SMTP C IMAP D MPLS 6 Windows ftp 6 Windows ftp A dir B list C dir D list 7 ping ping 127 0 0 1 IP ping IP 7 ping ping 127 0 0 1 IP ping IP A TCP IP B C D DNS 8 8 A 100 0 0 0 B 172 15 0 0 C 192 168 0 0 D 244 0 0 0 9 LabAP 2350AD9FE0 9 LabAP 2350AD9FE0 Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m 2 8 A SSID LabAP WEP B SSID 2350AD9FE0 WEP C SSID LabAP WEP D SSID 2350AD9FE0 WEP 1 Which statement is true when writing a cursor FOR loop 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 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 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 Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m 3 8 TO DATE 10 JUN 04 DD MON YY 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 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 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 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 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 5 In which section of a PL SQL block is a user defined exception raised A heading B executable C declarative D exception handling 6 Given this executable section of a PL SQL block 6 Given this executable section of a PL SQL block 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 B No FETCH statements were issued C Terminating conditions are missing D The cursor does not need to be closed 7 Which SELECT statement should you use to extract the year from the system date and display it in the format 1998 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 8 Evaluate the SQL statement SELECT LPAD salary 10 FROM EMP Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m 4 8 WHERE EMP ID 1001 If the employee with the EMP ID 1001 has a salary of 17000 what is displayed A 17000 00 B 17000 C 170 00 D 17000 00 E an error statement 9 Which view should a user query to display the columns associated with the constraints on a table owned by the user 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 B USER OBJECTS C ALL CONSTRAINTS D USER CONS COLUMNS E USER COLUMNS 10 What is true of using group functions on columns that contain NULL values 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 Which statement of assigning a long type variable to a hexadecimal value is correct JAVA 1 Which statement of assigning a long type variable to a hexadecimal value is correct A long number 345L B long number 0345 C long number 0345L D long number 0 x345L 2 Which of the following answer is correct to express the value 8 in octal number 2 Which of the following answer is correct to express the value 8 in octal number A 010 B 0 x10 C 08 D 0 x8 3 Which method will the statement on line 10 call 3 Which method will the statement on line 10 call 1 class Person 2 public void printValue int i int j 3 public void printValue int i 4 5 public class Teacher extends Person 6 public void printValue 7 public void printValue int i 8 public static void main String args 9 Person t new Teacher 10 t printValue 10 11 12 A on line 2 B on line 3 C on line 6 D on line 7 4 Which keyword should be used to enable interaction with the lock of an object The flag allows exclusive access to that object 4 Which keyword should be used to enable interaction with the lock of an object The flag allows exclusive access to that object A transient B synchronized C serialize D static 5 Given the uncompleted code of a class 5 Given the uncompleted code of a class class Person String name department int age public Person String n name n public Person String n int a name n age a public Person String n String d int a Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m 5 8 doing the same as two arguments version of constructor including assignment name n age a department d Which expression can be added at the doing the same as part of the constructor A Person n a B this Person n a C this n a D this name age 6 Given the following code 6 Given the following code 1 public void modify 2 int i j k 3 i 100 4 while i 0 5 j i 2 6 System out println The value of j is j 7 k k 1 8 i 9 10 Which line might cause an error during compilation A line 4 B line 6 C line 7 D line 8 7 Given the following code 7 Given the following code public class Person int arr new int 10 public static void main String a System out println arr 1 Which statement is correct A When compilation some error will occur B It is correct when compilation but will cause error when running C The output is zero D The output is null 8 A Button is positioned in a Frame Only height of the Button is affected by the Frame while the width is not Which layout manager should be used 8 A Button is positioned in a Frame Only height of the Button is affected by the Frame while the width is not Which layout manager should be used A FlowLayout B CardLayout C North and South of BorderLayout D East and West of BorderLayout E GridLayout 9 Given the following class 9 Given the following class public class Sample long length public Sample long l length l public static void main String arg Sample s1 s2 s3 s1 new Sample 21L s2 new Sample 21L s3 s2 long m 21L Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m Click to buy NOW P D F X C H A N G E w w w d o c u t r a c k c o m 6 8 Which expression returns true A s1 s2 B s