[单选]
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?（）

A . INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')
B . UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'
C . 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)
D . UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1

Which of the following provide for higher system availability on a single CEC Power 770 or Power 780?（） Redundant system clock。 Redundant service processor。 POWER7 cores include redundant L3 caches。 Main memory DIMMs contain an extra DRAM chip for improved redundancy。监理单位应当按照水利部的规定，取得《水利工程建设监理单位资质等级证书》，并在其资质等级许可的范围内承揽水利工程建设监理业务。 What is the minimum recommended amount of memory that can be assigned to a new VIO server？（） 128MB。 256MB。 512MB。 1GB。简述教师专业能力的要点。 Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（） It cancels all pending disk drops within the disk group。 It restores disks that are being dropped as the result of a DROP DISKGROUP operation。 It mounts disks in the disk group for which the drop-disk operation has already been completed。 It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed。 It adds previously dropped disks back into the disk grou。

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?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1z0-883题库

相关题目: