A.FORCE B.NOFORCE C.WITH READ ONLY D.WITH ADMIN OPTION
A.創(chuàng)建視圖前,必須創(chuàng)建“銷售”表 B.默認(rèn)情況下,即使“銷售”表不存在,也會(huì)創(chuàng)建視圖 C.使用FORCE選項(xiàng),可以同時(shí)創(chuàng)建表和視圖 D.可以使用FORCE選項(xiàng)在創(chuàng)建“銷售”表之前,創(chuàng)建視圖
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 您需要制定一個(gè)報(bào)表,用于確定在下學(xué)期任教的所有副教授。您要?jiǎng)?chuàng)建一個(gè)視圖來簡(jiǎn)化報(bào)表的創(chuàng)建過程。以下哪條CREATE VIEW語(yǔ)句將完成此任務(wù)()
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)