搜索
1 /8_______________________________________)1.IP A B C D2.PC A B C D3.202.100.192.0/2016 1A255.255.240.0 B255.255.224.0C255.255.254.0 D255.255.255.02A30 B62 C254 D5104.WebAPOP BSNMP CHTTP DHTTPS5.APOP3 BSMTP CIMAP DMPLS6.WindowsftpAdir Blist C!dir D!list7.pingping127.0.0.1IPpingIPATCP/IP BC DDNS8.A100.0.0.0 B172.15.0.0 C192.168.0.0 D244.0.0.09.LabAP2350AD9FE0Click to buy NOW!PDFXCHANGEtrack.comClick to buy NOW!PDFXCHANGEtrack.com2 /8ASSIDLabAPWEPBSSID2350AD9FE0WEPCSSIDLabAPWEPDSSID2350AD9FE0WEP)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 thesecolumns are defined with DATE as their datatype. You want to insert a row with the details ofemployee Smith who was born in 1944 and hired in 2004. Which statement will ensure that valuesare inserted into the table in the correct century?A: INSERT INTO EMP(empno, ename, birthdate, hiredate)VALUES (EMPNO_SEQ.NEXTVAL,'SMITH', '12DEC44','10JUN04');B: INSERT INTO EMP(empno, ename, birthdate, hiredate)VALUES (EMPNO_SEQ.NEXTVAL,'SMITH',TO_DATE('12DEC44','DDMONRR'),TO_DATE('10JUN04','DDMONRR'));C: INSERT INTO EMP(empno, ename, birthdate, hiredate)VALUES (EMPNO_SEQ.NEXTVAL,'SMITH',TO_DATE('12DEC44','DDMONYY'),Click to buy NOW!PDFXCHANGEtrack.comClick to buy NOW!PDFXCHANGEtrack.com3 /8TO_DATE('10JUN04','DDMONYY'));D: INSERT INTO EMP(empno, ename, birthdate, hiredate)VALUES (EMPNO_SEQ.NEXTVAL,'SMITH',TO_DATE('12DEC1944','DDMONYYYY'),TO_DATE('10JUN04','DDMONRR'));3.You are a user of the PROD database which contains over 1000 tables, and you need to determinethe number of tables you can access. Which data dictionary view could you query to display thisinformation?A: USER_OBJECTS B: ALL_OBJECTS C: DBA_SEGMENTS D: DBA_TABLES4.You need to perform a major update on the EMPLOYEE table. You have decided to disable the PRIMARYKEY 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 areautomatically recreated.E: All the existing column values are verified to confirm with the constraints and an error message is generated ifany existing values do not confirm.5.In which section of a PL/SQL block is a userdefined exception raised?A: heading B: executable C: declarative D: exception handling6.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 itin 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 EMPClick to buy NOW!PDFXCHANGEtrack.comClick to buy NOW!PDFXCHANGEtrack.com4 /8WHERE 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.00D: **17000.00 E: an error statement9.Which view should a user query to display the columns associated with the constraints on a tableowned by the user?A: USER_CONSTRAINTS B: USER_OBJECTS C: ALL_CONSTRAINTSD: USER_CONS_COLUMNS E: USER_COLUMNS10.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