-
Evaluate the following statement：
https://assets.asklib.com/images/image2/2018080114444988840.jpg
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
A . They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B . They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C . They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D . The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
-
Evaluate this SQL statement:
https://assets.asklib.com/images/image2/2018080116554090144.jpg
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
-
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）
A . You cannot roll back this statement.
B . All pending transactions are committed.
C . All views based on the DEPT table are deleted.
D . All indexes based on the DEPT table are dropped.
E . All data in the table is deleted, and the table structure is also deleted.
F . All data in the table is deleted, but the structure of the table is retained.
G . All synonyms based on the DEPT table are deleted.
-
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）
A . A text copy of the control file.
B . A binary copy of the control file.
C . A file containing a SQL statement which will re-create the database.
D . A file containing a SQL statement which will re-create the control file.
-
Statement对象提供了int executeUpdate（String sqlStatement）方法，用于实现对数据库中数据的添加、删除和更新操作。
A . 正确
B . 错误
-
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? （）
A . It releases the storage space used by the table.
B . It does not release the storage space used by the table.
C . You can roll back the deletion of rows after the statement executes.
D . You can NOT roll back the deletion of rows after the statement executes.
E . An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F . You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
-
cn是Connection对象，创建Statement对象的方法是（）。
A . Statement st=new Statement（）
B . Statement st=cn.newStatement（）
C . Statement st=cn.createNewStatement（）
D . Statement st=cn.createStatement（）
-
Evaluate the following statement：
https://assets.asklib.com/images/image2/2018080114301711053.jpg
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
A . They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B . They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C . They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D . The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
-
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）
A . An error is generated.
B . You will have two identical tables in the HR schema with different names.
C . You create a table called employees in the HR schema based on you EMP table.
D . You create an alternative name for the employees table in the HR schema in your own schema.
-
Which statement is the main idea of the second paragraph?Which statement is the main idea of paragraph 2?
-
__________________接口的对象可以代表一个预编译的SOL语句，它是Statement接口的子接口。
-
以下哪个不是Statement中的方法（ ）。
-
以下哪个不是Statement中的方法（ ）。
-
Statement接口的executeUpdate(String sql)返回值是int,它表示数据库中受该SQL语句影响的记录的数目
-
Translate the following sentence into Chinese.\A profit statement is also known as a profit and loss statement, an income statement, an income and expense statement or an operating statement.\
-
下面是创建Statement接口并执行executeUpdate方法的代码片段：conn=DriverManager.getConnection(\jdbc:odbc:book\,\\,\\);stmt=conn.createStatement();String strsql=\insert into bookvalues('TP003', 'ASP.NET','李','清华出版社',35)
-
Effective training objectives have three components: a statement of performance or outcome, a statement of quality or acceptable level of performance, and a statement of conditions under which the trainee is expected to perform.
-
Statement对象是通过Connection对象的什么方法创建的？
-
The empty statement is represented by placing __________ where a statement would normally be.
-
JDBC接口________中创建Statement的方法是________;创建PreparedStatement的方法是________;
-
Statement接口的execute （)方法的返回类型是int型。
-
4、JDBC中，接口Statement中定义的execute方法的返回类型是（）
A．ResultSet
B．Int
C．Boolean
D．String
-
创建基本的Statement对象的实现代码是__
-
Statement是用于发送并执行SQL语句的类。（）
