单选题A The introduction.B The middle.C The conclusion.D The statement

题目
单选题
A

The introduction.

B

The middle.

C

The conclusion.

D

The statement

相似考题

1.The income statement is prepared from ().A.the income statement columns of the work sheetB.the adjusted trial balanceC.either the adjusted trial balance or the income statement columns of the work sheetD.both the adjusted trial balance and the income statement columns of the work sheet

2.Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()A.B.C.D.

3.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.

4.Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?（）A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.B. The statement returns an error at the SELECT clause.C. The statement returns an error at the WHERE clause.D. The statement returns an error at the ORDER BY clause.

参考答案和解析
正确答案： A
解析：
由“I like the introduction which really sets out your ideas clearly. The middle needs some attention, but the end is really first rate.”(我喜欢引言部分，它清晰地陈述了你的想法，中间部分需要注意，但是结尾部分是相当精彩的)可知，Dr. Jones最喜欢部分是结论部分。
更多“单选题A The introduction.B The middle.C The conclusion.D The statement”相关问题

  • 第1题：

    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.


    参考答案：E

  • 第2题：

    cn是Connection对象，创建Statement对象的方法是（）。

    • A、Statement st=new Statement（）
    • B、Statement st=cn.newStatement（）
    • C、Statement st=cn.createNewStatement（）
    • D、Statement st=cn.createStatement（）

    正确答案:D

  • 第3题：

    Which two statements are true about terms in a routing policy?（）

    • A、A then statement is mandatory in a term
    • B、If a term does not contain a from statement, all routers match
    • C、If a term does not contain a from statement, the Junos OS will not commit
    • D、A then statement is not mandatory in a term

    正确答案:A,B

  • 第4题：

    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）

    • A、 The statement will be executed successfully， and a new time zone will be set for the database.
    • B、 The statement will be executed successfully， but a new time zone will not be set for the database.
    • C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
    • D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

    正确答案:D

  • 第5题：

    单选题
    The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）
    A

     The statement will deactivate DAY_PLAN.

    B

     The statement will activate DAY_PLAN as the top plan.

    C

     The statement will activate MANAGERS_PLAN as the top plan.

    D

     The statement will return an error because MANAGERS_PLAN is not the top plan.


    正确答案： D
    解析： 暂无解析

  • 第6题：

    单选题
    Ⅲ. There are four choices following each statement. Mark the choice that can best complete the statement: If a linguistic study describes and analyzes the language people actually use, it is said to be （）
    A

    prescriptive

    B

    analytic

    C

    descriptive

    D

    linguistic


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    In JUNOS software， how is route summarization at the L1/L2 border configured？（）
    A

    By specifying the area-range statement.

    B

    By creating aggregate routes and applying policies.

    C

    By specifying the route-summarization statement.

    D

    By specifying the area-range restrict statement.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）
    A

     The statement will be executed successfully， and a new time zone will be set for the database.

    B

     The statement will be executed successfully， but a new time zone will not be set for the database.

    C

     The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.

    D

     The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You issued the following statement：  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What will be the result of issuing the statement？（）
    A

     The control file will be multiplexed.

    B

     The control file will be recreated.

    C

    The script containing the CREATE CONTROLFILE statement will be created.

    D

     The binary backup of the control file will be created.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    Examine the statement： DROP TABLESPACE IND2  INCLUDING CONTENTS  AND DATAFILES；   What is the result of the statement？（）
    A

    A

    B

    B

    C

    C

    D

    D


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Which the statement is true？（）
    A

     The Error class is a Runtime Exception.

    B

     No exceptions are subclasses of Error.

    C

     Any statement that may throw an Error must be enclosed in a try block.

    D

     any statement that may throw an Exception must be enclosed in a try block.

    E

     Any statement that may throw an Runtime Exception must be enclosed in a try block.


    正确答案： E
    解析： 暂无解析

  • 第13题：

    What is a sub-select statement?

    A．a select statement that selects a subset of fields in a table

    B．a select statement that returns a subset of the data in a table

    C．a select statement that appears within another select statement

    D．a select statement that returns a subset of the constraints on a field


    正确答案：C

  • 第14题：

    Prepared Statement是Statement的子接口，使用Prepared Statement要比使用Statement性能更高。


    正确答案:正确

  • 第15题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第16题：

    Where can subqueries be used?（）

    • A、field names in the SELECT statement 
    • B、the FROM clause in the SELECT statement 
    • C、the HAVING clause in the SELECT statement
    • D、the GROUP BY clause in the SELECT statement 
    • E、the WHERE clause in only the SELECT statement 
    • F、the WHERE clause in SELECT as well as all DML statements

    正确答案:B,C,F

  • 第17题：

    判断题
    Prepared Statement是Statement的子接口，使用Prepared Statement要比使用Statement性能更高。
    A

    对

    B

    错


    正确答案： 对
    解析： 暂无解析

  • 第18题：

    单选题
    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）
    A

     The statement will not execute successfully.

    B

     The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days

    C

     The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.

    D

     Backups will be deleted from the media after 400 days.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?（）
    A

    Immediately after the SELECT clause

    B

    Before the WHERE clause

    C

    Before the FROM clause

    D

    After the ORDER BY clause

    E

    After the WHERE clause


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (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 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.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    Evaluate the SQL statement:SELECT ROUND(TRUNC(MOD(1600,10),-1),2)FROM dual;What will be displayed?（）
    A

    0

    B

    1

    C

    0.00

    D

    an error statement


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    This statement is not _____ with the ones you made earlier.
    A

    considered

    B

    competitive

    C

    comparative

    D

    consistent


    正确答案： D
    解析：
    句意：这个声明和你早期发表的不一致。consistent with是固定词组，表示“与……一致”。

  • 第24题：

    单选题
    Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）
    A

    The SELECT statement is syntactically accurate.

    B

    The SELECT statement does not work because there is no HAVING clause.

    C

    The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

    D

    The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.


    正确答案： C
    解析： 暂无解析

相关内容