Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMPLOYEES e, DEPARTMENTS dWHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed?()A.selection, projection, joinB.difference, projection, joinC.selection, intersection, joinD.intersection, projection, joinE.difference, projection, product

Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMPLOYEES e, DEPARTMENTS dWHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed?()

A.selection, projection, join

B.difference, projection, join

C.selection, intersection, join

D.intersection, projection, join

E.difference, projection, product


相关考题:

JDBC中,Statement可以用于执行不带参数的简单SQL语句。()

Statement是PreparedStatement的父接口。Statement对象用于执行不带参数的简单SQL语句;PreparedStatement对象用于执行预编译SQL语句。() 此题为判断题(对,错)。

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?()A. Selection, projection, joinB. Difference, projection, joinC. Selection, intersection, joinD. Intersection, projection, joinE. Difference, projection, product

下列选项中,关于Statement描述错误的是()A.Statement是用来执行SQL语句的B.Statement是PreparedStatement的子接口C.获取Statement实现需要使用Connection的createStatement()方法D.PreparedStatement能使用参数占位符,而Statement不行

7、Statement对象提供了执行基本SQL语句的功能。

下列选项中,关于Statement描述错误的是()A.Statement是用来执行SQL语句的B.Statement是PreparedStatement的子接口C.获取Statement实现需要使用Connection的createStatement()方法D.PreparedStatement能使用参数占位符,而Statement不行

()接口继承了Statement接口,用来执行预编译的SQL语句。

Statement对象本身包含SQL语句。

3.下列选项中,关于Statement描述错误的是() A: Statement是用来执行SQL语句的 B: Statement是PreparedStatement的子接口 C: 获取Statement实现需要使用Connection的createStatement()方法 D: PreparedStatement能使用参数占位符,而Statement不行A.A B C DB.A B C DC.A B C DD.A B C D