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题:
您要对EMPLOYEES表的FIRST_NAME和LAST_NAME列创建一个组合索引。以下哪条语句将完成此任务()
第2题:
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?()
第3题:
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?()
第4题:
Which three statements inserts a row into the table?()
第5题:
Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You 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? ()
第6题:
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE Which UPDATE statement is valid?()
第7题:
INSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);
INSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);
INSERT INTO employees VALUES (‘1000’,‘John’,NULL);
INSERT INTO employees(first_name,last_name, employee_id) VALUES ( 1000, ‘John’,‘Smith’);
INSERT INTO employees (employee_id) VALUES (1000);
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, ‘John’,‘’);
第8题:
INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
INSERT INTO employees VALUES ( '1000', 'John', NULL);
INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
INSERT INTO employees (employee_id) VALUES (1000);
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
第9题:
UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
第10题:
SELECT last_name, department_name FROM employees NATURAL JOIN departments;
SELECT last_name, department_name FROM employees JOIN departments ;
SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
第11题:
INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01);
INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01 january 01');
INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, 'John', 'smith', To_ date ('01/01/01));
INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01-Jan-01');
第12题:
CREATE INDEX NAME _IDX (first_name, last_name);
CREATE INDEX NAME _IDX (first_name, AND last_name)
CREATE INDEX NAME_IDX ON (First_name, last_name);
CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
CREATE INDEX NAME_IDX ON employees (First_name, last_name);
CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
第13题:
评估此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); 此语句将创建什么类型的视图()
第14题:
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? ()
第15题:
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?()
第16题:
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?()
第17题:
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?()
第18题:
CREATE VIEW(SELECT first_name,last_name,status,courseid,subject,term FROM faculty,course WHERE facultyid=facultyid)
CREATE VIEW pt_view ON(SELEC Tfirst_name,last_name,status,courseid,subject,term FROM faculty f and coursec WHERE f.facultyid=c.facultyid)
CREATE VIEW pt_view IN(SELECT first_name,last_name,status,courseid,subject,term FROM faculty course)
CREATE VIEW pt_view AS(SELECT first_name,last_name,status,courseid,subject,term FROM facultyf,coursec WHERE f.facultyid=c.facultyid)
第19题:
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;
SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
第20题:
UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employee_id = 180;
UPDATE employees SET first_name = 'John', SET last_name = 'Smoth' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John' AND last_name = 'Smith' WHERE employee_id = 180;
UPDATE employee SET first_name = 'John', last_name = 'Smith' WHERE employee_id = 180;
第21题:
嵌套
简单
内嵌
复杂
第22题:
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
第23题:
INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
INSERT INTO employees VALUES ('1000','JOHN','NULL');
INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
INSERT INTO employees (employee_id) VALUES (1000);
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);