Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）A、

题目

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）

  • A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';
  • B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
  • C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
  • D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
  • E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
相似考题

1.(ii) ‘job description’. (4 marks)

2.UiSelector的description()查找属性content－description为指定字符串的UI元素并返回UiSelector,要求字符串必须完全匹配。()此题为判断题(对，错)。

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

4.统计描述statistical description(名词解释)

更多“Examine the description of the ”相关问题

  • 第1题：

    Examine the description of the STUDENTS table:Which two aggregate functions are valid on the START_DATE column?()

    A. SUM(start_date)

    B. AVG(start_date)

    C. COUNT(start_date)

    D. AVG(start_date, end_date)

    E. MIN(start_date)

    F. MAXIMUM(start_date)


    参考答案：C, E

  • 第2题：

    YouneedtodesignthestorageoftheapplicationtextsforUIelementstofulfilltherequirements.Whichtableandcolumndesignshouldyouuse?()

    A.Languages(LanguageID,Name)Elements(ElementID,Description)ElementLanguages(ElementID,LanguageID,Text)

    B.Languages(LanguageID,Name)Elements(ElementID,LanguageID,Description,Text)

    C.Languages(LanguageID,Name)ElementTexts(LanguageID,Text)ElementDescriptions(ElementID,Description)

    D.Languages(LanguageID,Name)Elements(ElementID,Description,Text)


    参考答案：A

  • 第3题：

    _______

    . A. conclusion B. description C. evaluation D. introduction


    正确答案：A

  • 第4题：

    Description叙述标签


    正确答案: 叙述标签是存在于网页的HTML编码之内，只有搜索引擎才会去阅读。这个标签的使用是为了弥补标题标签（titletag）的不足，通过较长的一段叙述，把网页的大意让搜索引擎了解。因此，这个标签的重要性仅次于标题标签。在撰写这段叙述的时候，如何在其中适当地融入关键词是个重要的写作技术。

  • 第5题：

    网页的META标签是指（）

    • A、title、h1、keywords
    • B、description、alt、keywords
    • C、robots、keywords、description
    • D、keywords、description、h2

    正确答案:C

  • 第6题：

    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）

    • A、ALTER TABLE commercials MODIFY (description CHAR2(1000));
    • B、ALTER TABLE commercials CHANGE (description CHAR2(1000));
    • C、ALTER TABLE commercials CHANGE (description VARCHAR2(1000));
    • D、ALTER TABLE commercials MODIFY (description VARCHAR2(1000));
    • E、You cannot increase the size of a column if the table has rows.

    正确答案:D

  • 第7题：

    description


    正确答案:性状

  • 第8题：

    The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.

    • A、Customs
    • B、The ministry of commerce
    • C、The state council
    • D、the commodity inspection institution

    正确答案:A

  • 第9题：

    Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do? （）

    • A、Examine the System Event Log on the user’s computer.
    • B、Examine the System Event Log on both domain controllers.
    • C、Examine the Security Event Log on both domain controllers.
    • D、Examine the Application Event Log on the user’s computer.

    正确答案:C

  • 第10题：

    单选题
    The（）may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.
    A

    Customs

    B

    The ministry of commerce

    C

    The state council

    D

    the commodity inspection institution


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

  • 第11题：

    名词解释题
    统计描述statistical description

    正确答案： 是利用统计指标，统计图，统计表反映包括数据资料基本特点的统计方法，可是人们准确，全面的了解数据资料包含的信息，有利于在此基础上完成进一步的统计分析。
    解析： 暂无解析

  • 第12题：

    单选题
    You need to design the storage of the application texts for UI elements to fulfill the requirements. Which table and column design should you use?（）
    A

    Languages (LanguageID, Name)Elements (ElementID, Description)ElementLanguages (ElementID, LanguageID, Text) 

    B

    Languages (LanguageID, Name)Elements (ElementID, LanguageID, Description, Text) 

    C

    Languages (LanguageID, Name)ElementTexts (LanguageID, Text)ElementDescriptions (ElementID, Description) 

    D

    Languages (LanguageID, Name)Elements (ElementID, Description, Text)


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

  • 第13题：

    检查

    A.expect

    B.except

    C.excuse

    D.examine


    正确答案：D

  • 第14题：

    面向服务系统构建过程中，（ ）用于实现Web服务的远程调用，（ ）用来将分散的、功能单一的Web服务组织成一个复杂的有机应用。

    A.UDDI（Universal Description，Discovery and Integration） B.WSDL（Web Service Description Language)C.SOAP（Simple Object Access Protocol）D.BPEL（Business Process Execution Language） A.UDDI（Universal Description，Discovery and Integration）B.WSDL（Web Service Description Language） C.SOAP（Simple Object Access Protocol）D.BPEL（Business Process Execution Language）


    正确答案：C,D

  • 第15题：

    The description about the murderer was pretty vague.

    A:imprecise
    B:concise
    C:unpolished
    D:elementary

    答案：A
    解析：
    本句意思：对那个凶手的描述十分的模糊。imprecise的意思为“不准确的，有差池的”; concise的意思为“简洁的，简明的”; unpolished的意思为“未擦拭的，未经修饰的”; elementary的 意思为“基础的”。vague的意思为“含糊的，模糊的”，可指话语的表述或事物轮廓的模糊，和 imprecise的意思接近。

  • 第16题：

    检查（）

    • A、expect
    • B、except
    • C、excuse
    • D、examine

    正确答案:D

  • 第17题：

    网页描述标签优化description指的是？


    正确答案: 是对网页内容的精练概括。如果description描述与网页内容相符，搜索引擎会把description当做摘要的选择目标之一，好的description会帮助用户更方便的从搜索结果中判断你的网页内容是否和需求相符。

  • 第18题：

    统计描述statistical description


    正确答案: 是利用统计指标，统计图，统计表反映包括数据资料基本特点的统计方法，可是人们准确，全面的了解数据资料包含的信息，有利于在此基础上完成进一步的统计分析。

  • 第19题：

    A diachronic study of language is the description of language at some point in time.


    正确答案:错误

  • 第20题：

    Your alert log file has the following information： Tue May 25 17：43：38 2004  ORA-00060： Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）

    • A、examine the trace file and kill the session that caused the deadlock
    • B、examine the trace file and kill both the sessions responsible for the deadlock
    • C、examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
    • D、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
    • E、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

    正确答案:D

  • 第21题：

    单选题
    What’s the passage about?
    A

    A description of an English book.

    B

    A description of an English course.

    C

    A description of life in Los Angeles.

    D

    A description of weekend visits to San Francisco.


    正确答案： A
    解析：
    根据对短文的整体理解以及文章的第一句话“We provide summer English courses and you will enjoy learning about American culture and improve your English.”可知本文是对一门英语课程的介绍。

  • 第22题：

    单选题
    Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_ marks; 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
    解析： 暂无解析

  • 第23题：

    单选题
    You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）
    A

    ALTER TABLE commercials MODIFY (description CHAR2(2000));

    B

    ALTER TABLE commercials CHANGE (description CHAR2(2000));

    C

    ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));

    D

    ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));

    E

    You cannot increase the size of a column if the table has rows.


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

  • 第24题：

    多选题
    Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? （　）
    A

    SUM（start_date）

    B

    AVG（start_date）

    C

    COUNT（start_date）

    D

    AVG（start_date，end_date）

    E

    MIN（start_date）

    F

    MAXIMUM（start_date）


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

相关内容