A SELECT statement can be used to perform these three functions:1. Choose rows from a table.2. Choose columns from a table3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? （）A. difference, projection, joinB. selection, projection, joinC. selection, intersection, joinD. intersection, projection, joinE. difference, projection, product
A SELECT statement can be used to perform these three functions:1. Choose rows from a table.2. Choose columns from a table3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? （）
A. difference, projection, join
B. selection, projection, join
C. selection, intersection, join
D. intersection, projection, join
E. difference, projection, product
相关考题：
SQL语句：SELECT*FROM班级WHERE班级号NOT IN;(SELECT班级号FROM学生)该语句等价于：SELECT*FROM班级WHERE NOT______;(SELECT*FROM学生WHERE班级号=班级.班级号)
对由SELECT—FROM—WHERE—GROUP—ORDER组成的SQL语句，其在被DBMS处理时，各子句的执序次序(43)。A．SELECT—FROM—GROUP—WHERE—ORDERB．FROM—SELECT—WHERE—GROUP—ORDERC．FROM—WHERE—GROUP—SELECT—ORDERD．SELECT—FROM—WHERE—GROUP—ORDER
与“SELECT*FROM教师表INTO DBF A”等价的语句是A．SELECT*FROM教师表TO DBF AB．SELECT*FROM教师表TO TABLE AC．SELECT*FROM教师表INTO TABLE AD．SELECT*FROM教师表INTO A
在学生表中查找没有选课的学生，下列语句正确的是( )。A．SELECT*FROM 学生 WHERE EXISTS； (SELECT*FROM 选课 WHERE学生号=学生.学生号)B．SELECT*FROM 学生 WHERE NOT EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生.学生号)C．SELECT*FROM 学生 WHERE EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生号)D． SELECT*FROM 学生 WHERE NOT EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生号)
假设所有学生都已选课，所有的选课成绩都已确定。检索所有选课成绩都在90分以上(含)的学生信息，正确的SQL命令是( )。A．SELECT*FROM学生WHERE学号IN(SELECT学号FROM选课WHERE成绩=90)B．SELECT*FROM学生WHERE学号NOT IN(SELECT学号FROM选课 WHERE成绩90)C．SELECT*FROM学生WHERE学号!=ANY(SELECT学号FROM选课 WHERE成绩90)D．SELECT*FROM学生WHERE学号=ANY(SELECT学号FROM选课 WHERE成绩=90)
与“SELECT*FROM教师表INTO DBF A”等价的语句是（ ）。A.SELECT*FROM教师表TO DBF AB.SELECT*FROM教师表TO TABLE AC.SELECT*FROM教师表INTO TABLE AD.SELECT*FROM教师表INTO A ，
有如下SQL语句： SELECT姓名FROM学生表WHERE学号IN； (SELECT学号FROM成绩表WHERE成绩＞90) 下列哪条命令与该SQL语句等价A．SELECT姓名FROM学生表WHERE EXISTS； (SELECT学号FROM成绩表WHERE成绩＞90)B．SELECT姓名FROM学生表WHERE EXISTS； (SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90)C．SELECT姓名FROM学生表WHERE学号EXISTS； (SELECT学号FROM成绩表WHERE学号=学生表．学号AND成绩＞90)D． SELECT姓名FROM学生表WHERE学号=； (SELECT学号FROM成绩表WHERE成绩＞90)
（ 30 ）与 “ SELECT * FROM 教师表 INTO DBF A ” 等价的语句是A ） SELECT * FROM 教师表 TO DBF AB ） SELECT * FROM 教师表 TO TABLE AC ） SELECT * FROM 教师表 INTO TABLE AD ） SELECT * FROM 教师表 INTO A
查询“成绩”表的所有记录并存储于数组arrl中的SQL语句是（ ）。A)SELECT﹡FROM成绩INTO ARRAY arrlB)SELECT﹡FROM成绩TO CURSOR arrlC)SELECT﹡FROM成绩TO ARRAY arrlD)SELECT﹡FROM成绩INTO CURSOR arrl
SELECT语句中必选的子句是（）A．SELECT…FROMB．SELECT…FROM…WHEREC．SELECT…FROM…ORDER BYD．SELECT