0

databases Online Quiz - 147

Description: databases Online Quiz - 147
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which function takes as argument a numeric value or an expression that can be evaluated to a number.

  1. CEILING()

  2. SQRT()

  3. EXP()

  4. FLOOR()


Correct Option: D
  1. DatabaseName.fun.FunctionName()

  2. DatabaseName.dbo.FunctionName()

  3. Exercise.fun.GetFullName();

  4. Exercise.dbo.GetFullName();


Correct Option: B
  1. datetime

  2. hierarchyid

  3. status

  4. views

  5. value


Correct Option: A,B,C
  1. sp_rename TableNewName, ExistingTableName;

  2. sp_renametable ExistingTableName, TableNewName;

  3. sp_rename ExistingTableName, TableNewName;

  4. sp_renametable TableNewName, ExistingTableName;


Correct Option: C

Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.

  1. True

  2. False


Correct Option: B

You may use two consecutive minus signs in arithmetic expressions to indicate the subtraction of a negative value.

  1. True

  2. False


Correct Option: B

You use comments in a SQL statement to pass hints to the Oracle optimizer

  1. True

  2. False


Correct Option: A

In Oracle SQL, all set operators have equal precedence

  1. True

  2. False


Correct Option: A

In Oracle, the select list appears after the SELECT keyword and before the FROM clause.

  1. True

  2. False


Correct Option: A

The UNION ALL operator does not eliminate duplicate selected rows from the result set.

  1. True

  2. False


Correct Option: A

The ALTER SEQUENCE statement can affect only the future sequence numbers

  1. True

  2. False


Correct Option: A
- Hide questions