Select the statement that best describes The cure for Amplification Principle in the Internetdomain， as explained in RFC 3429 （Internet Architectural Guidelines ）（）？A、Amplification is prevented if global changes have only a local effect as opposed to syst

题目

Select the statement that best describes The cure for Amplification Principle in the Internetdomain， as explained in RFC 3429 （Internet Architectural Guidelines ）（）？

  • A、Amplification is prevented if global changes have only a local effect as opposed to systems in which global changes have a local effect
  • B、Amplification is prevented if local changes have only a local effect as opposed to system inwhich localchange have a global effect
  • C、Internet domain does not suffer from“The Amplification Principle”as BGP takes care of misbehaving advertisers
  • D、None of the above
相似考题

1.The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber

2.Evaluate this SQL statement: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

3.Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP 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.

4.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 clauseB. Before the WHERE clauseC. Before the FROM clauseD. After the ORDER BY clauseE. After the WHERE clause

更多“Select the statement”相关问题

  • 第1题：

    From SQL*Plus, you issue this SELECT statement:You use this statement to retrieve data from a data table for()。

    A. Updating

    B. Viewing

    C. Deleting

    D. Inserting

    E. Truncating


    参考答案：B, D

  • 第2题：

    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


    参考答案：A

  • 第3题：

    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

  • 第4题：

    Which two statements about views are true? （）

    • A、A view can be created as read only.
    • B、A view can be created as a join on two or more tables.
    • C、A view cannot have an ORDER BY clause in the SELECT statement.
    • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
    • E、A view must have aliases defined for the column names in the SELECT statement.

    正确答案:A,B

  • 第5题：

    Which two statements are true regarding the ORDER BY clause? （）

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第6题：

    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

    正确答案:E

  • 第7题：

    单选题
    The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
    A

    Alice only

    B

    Alice and Reena

    C

    Alice, Reena, and Timber

    D

    Sue, Alice, Reena, and Timber


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements about views are true?（）
    A

    A view can be created as read only.

    B

    A view can be created as a join on two or more tables.

    C

    A view cannot have an ORDER BY clause in the SELECT statement.

    D

    A view cannot be created with a GROUP BY clause in the SELECT statement.

    E

    A view must have aliases defined for the column names in the SELECT statement.


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

  • 第10题：

    多选题
    Which two are true about aggregate functions?（）
    A

    You can use aggregate functions in any clause of a SELECT statement.

    B

    You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.

    C

    You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

    D

    You can pass column names, expressions, constants, or functions as parameter to an aggregate function.

    E

    You can use aggregate functions on a table, only by grouping the whole table as one single group.

    F

    You cannot group the rows of a table by more than one column while using aggregate functions.


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

  • 第11题：

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


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

  • 第12题：

    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.


    参考答案：C

  • 第13题：

    Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP 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.


    参考答案：A

  • 第14题：

    In which four clauses can a subquery be used?（）

    • A、in the INTO clause of an INSERT statement
    • B、in the FROM clause of a SELECT statement
    • C、in the GROUP BY clause of a SELECT statement
    • D、in the WHERE clause of a SELECT statement
    • E、in the SET clause of an UPDATE statement
    • F、in the VALUES clause of an INSERT statement

    正确答案:A,B,D,E

  • 第15题：

    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.

    • A、Updating
    • B、Viewing
    • C、Deleting
    • D、Inserting
    • E、Truncating

    正确答案:B,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题：

    单选题
    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, join

    B

    Difference, projection, join

    C

    Selection, intersection, join

    D

    Intersection, projection, join

    E

    Difference, projection, product


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

  • 第18题：

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


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

  • 第19题：

    单选题
    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, join

    B

    Difference, projection, join

    C

    Selection, intersection, join

    D

    Intersection, projection, join

    E

    Difference, projection, product


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

  • 第20题：

    多选题
    In which four clauses can a subquery be used? （）
    A

    in the INTO clause of an INSERT statement

    B

    in the FROM clause of a SELECT statement

    C

    in the GROUP BY clause of a SELECT statement

    D

    in the WHERE clause of a SELECT statement

    E

    in the SET clause of an UPDATE statement

    F

    in the VALUES clause of an INSERT statement


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

  • 第21题：

    多选题
    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
    A

    Updating

    B

    Viewing

    C

    Deleting

    D

    Inserting

    E

    Truncating


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

相关内容