The statement: "search austin.ibm.com raleigh.ibm.com" belongs in which of the following files?()
Evaluate the set of SQL statements:What is true about the set?()A. The DESCRIBE DEPT statement displays the structure of the DEPT table.B. The ROLLBACK statement frees the storage space occupies by the DEPT table.C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
点击查看答案
Evaluate the SQL statement:What is the result of the statement?()A. The statement produces an error at line 1.B. The statement produces an error at line 3.C. The statement produces an error at line 6.D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
What is a sub-select statement?A.a select statement that selects a subset of fields in a tableB.a select statement that returns a subset of the data in a tableC.a select statement that appears within another select statementD.a select statement that returns a subset of the constraints on a field
A seaman dies during a voyage. What is NOT required to be entered into the Official Log?A.Statement that the Master has taken custody of the deceased's MMD and passportB.An inventory of the money and propertyC.Statement of the wages dueD.Statement as to the total deductions to be made from the wages
关于PreparedStatement与Statement描述错误的是()。A、一般而言,PreparedStatement比Statement执行效率更高B、PreparedStatement会预编译SQL语句C、Statement每次都会解析/编译SQL,确立并优化数据获取路径D、Statement执行扫描的结果集比PreparedStatement大
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?()A、The DESCRIBE DEPT statement displays the structure of the DEPT table.B、The ROLLBACK statement frees the storage space occupied by the DEPT table.C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
cn是Connection对象,创建Statement对象的方法是()。A、Statement st=new Statement()B、Statement st=cn.newStatement()C、Statement st=cn.createNewStatement()D、Statement st=cn.createStatement()