An employee of ABC company has move to an office on a different floor. Although the administrator is able to telnet to all of the routers,the address of Switch F is needed in order to verify that the employee remains in the same VLAN.Which action could be used by the administrator to find the IP address of Switch F?（）..

第1题

[单选题] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

A、MERGE B、INSERT C、UPDATE D、ADD E、ENTER F、You cannot enter the phone numbers for the existing employee records.

点击查看答案

第2题

[单选题] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

A、MERGE B、INSERT C、UPDATE D、ADD E、ENTER F、You cannot enter the phone numbers for the existing employee records.

点击查看答案

第3题

[单选题] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）

A、MERGE B、INSERT C、UPDATE D、ADD E、ENTER F、You cannot enter the phone numbers for the existing employee records.

点击查看答案

第4题

[单选题] Evaluate the SQL statement: What is the result of the statement?（）

A、The statement produces an error at line 1. B、The statement produces an error at line 3. C、The statement produces an error at line 6. D、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company. E、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

点击查看答案

第5题

[单选题] You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）

A、You get an error because of a primary key violation. B、The data and structure of the EMPLOYEES table are deleted. C、The data in the EMPLOYEES table is deleted but not the structure. D、You get an error because the statement is not syntactically correct.

点击查看答案

第6题

[单选题] Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement?（）

A、The statement produces an error at line 1. B、The statement produces an error at line 3. C、The statement produces an error at line 6. D、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company. E、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

点击查看答案

第7题

[单选题] Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement? （）

A、The statement produces an error at line 1. B、The statement produces an error at line 3. C、The statement produces an error at line 6. D、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company. E、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

点击查看答案

第8题

[] You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （） You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）

A、A. You get an error because of a primary key violation. B、B. The data and structure of the EMPLOYEES table are deleted. C、C. The data in the EMPLOYEES table is deleted but not the structure. D、D. You get an error because the statement is not syntactically correct.

点击查看答案

第9题

[单选题] Examine the structure of the EMPLOYEES table: You issue these statements: At the end of this transaction, what is true?（）

A、You have no rows in the table. B、You have an employee with the name of James. C、You cannot roll back to the same savepoint more than once. D、Your last update fails to update any rows because employee ID 180 was already eleted.

点击查看答案

请使用微信扫码支付