单选题Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone

题目

单选题

Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone_no, ' – ') AS 'office_no' 'coalesce (ph2 .phone_no, ' – ') AS 'cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = 'office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = 'mobile' The tables employees and employee_phone are InnoDB tables; all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec) Which method can you use to change the cell_no value to '555-8888' for John Doe?（）

INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')

UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'

DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)

UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

在SQL Server 2000中，现要在employees表的first_name和last_name列上建立一个唯一的非聚集复合索引，其中first_name列数据的重复率是5%，last_name列数据的重复率是10%。请补全下列语句使以first_name和last_name列作为条件的查询效率最高。

CREATE UNIQUE NONCLUSTERED INDEX Idx_Name

ON employees(______)

正确答案：first_nameASClast_nameDESC
first_nameASC，last_nameDESC

第2题：

您要对EMPLOYEES表的FIRST_NAME和LAST_NAME列创建一个组合索引。以下哪条语句将完成此任务（）

A、CREATE INDEXfl_idx ON employees（first_name last_name）
B、CREATE INDEXfl_idx ON employees（first_name），employees（last_name）
C、CREATE INDEXfl_idx ON employees（first_name，last_name）
D、CREATE INDEXfl_idx ON employees（first_name）；CREATE INDEXfl_idx ON employees（last_name）

正确答案:C

第3题：

Examine the structure of the EMPLOYEES table:Column name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyLAST_NAME VARCNAR2(30)FIRST_NAME VARCNAR2(30)JOB_ID NUMBERSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBERYou need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task? （）

A. CREATE INDEX NAME _IDX (first_name, last_name);

B. CREATE INDEX NAME _IDX (first_name, AND last_name)

C. CREATE INDEX NAME_IDX ON (First_name, last_name);

D. CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);

E. CREATE INDEX NAME_IDX ON employees (First_name, last_name);

F. CREATE INDEX NAME_IDX FOR employees (First_name, last_name);

参考答案：E

第4题：

Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）

A、SELECT last_name, department_name FROM employees NATURAL JOIN departments;
B、SELECT last_name, department_name FROM employees JOIN departments ;
C、SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
D、SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E、SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
F、SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

正确答案:F

第5题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which INSERT statement is valid?（）

A、INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);
B、INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');
C、INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));
D、INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01');

正确答案:A

第6题：

FACULTY表包含以下各列： FACULTYID VARCHAR2(5) NOT NULL PRIMARY KEY FIRST_NAME VARCHAR2(20) LAST_NAME VARCHAR2(20) ADDRESS VARCHAR2(35) CITY VARCHAR2(15) STATE VARCHAR2(2) ZIP NUMBER(9) TELEPHONE NUMBER(10) STATUS VARCHAR2(2) NOT NULL COURSE 表包含以下各列： COURSEID VARCHAR2(5) NOT NULL PRIMARY KEY SUBJECT VARCHAR2(5) TERM VARCHAR2(6 FACULTYID VARCHAR2(5) NOT NULL FOREIGN KEY 您需要制定一个报表，用于确定在下学期任教的所有副教授。您要创建一个视图来简化报表的创建过程。以下哪条CREATE VIEW语句将完成此任务（）

A、CREATE VIEW（SELECT first_name，last_name，status，courseid，subject，term FROM faculty，course WHERE facultyid=facultyid）
B、CREATE VIEW pt_view ON（SELEC Tfirst_name，last_name，status，courseid，subject，term FROM faculty f and coursec WHERE f.facultyid=c.facultyid）
C、CREATE VIEW pt_view IN（SELECT first_name，last_name，status，courseid，subject，term FROM faculty course）
D、CREATE VIEW pt_view AS（SELECT first_name，last_name，status，courseid，subject，term FROM facultyf，coursec WHERE f.facultyid=c.facultyid）

正确答案:D

第7题：

评估此CREATE VIEW 语句： CREATE VIEW pt_view AS (SELECT first_name, last_name, status, courseid, subject, term FROM faculty f, course c WHERE f.facultyid = c.facultyid); 此语句将创建什么类型的视图（）

A、嵌套
B、简单
C、内嵌
D、复杂

正确答案:B

第8题：

Examine the data in the EMPLOYEES and DEPARTMENTS tables.EMPLOYEESLAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000Kochhar 5000DEPARTMENTSDEPARTMENT_ID DEPARTMENT_NAME10 Sales20 Marketing30 Accounts40 AdministrationYou want to retrieve all employees, whether or not they have matching departments in the departments table.Which query would you use?（）

A. SELECT last_name, department_name FROM employees , departments(+);

B. SELECT last_name, department_name FROM employees JOIN departments(+);

C. SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d

D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

E. SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);

F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);

参考答案：F

第9题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）

A、INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
B、INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
C、INSERT INTO employees VALUES ('1000','JOHN','NULL');
D、INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
E、INSERT INTO employees (employee_id) VALUES (1000);
F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

正确答案:C,E,F

第10题：

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）

A、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
B、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "/";
D、SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';

正确答案:A

单选题Review the definition of the phone_list view. CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECT e . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone

题目

相似问题和答案

更多相关问题

相关内容