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

Select from the following, Transact-SQL internal keywords

  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

In general, Oracle accepts all forms of expressions in all parts of all SQL statements.

  1. True

  2. False


Correct Option: B

ALL scalar functions in Oracle return null when given a null argument

  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

Oracle treats zero-length character strings as nulls.

  1. True

  2. False


Correct Option: A

In Oracle SQL, all set operators have equal precedence

  1. True

  2. False


Correct Option: A

AI Explanation

To answer this question, you need to understand the concept of set operators in Oracle SQL and their precedence.

Set operators in Oracle SQL are used to combine the result sets of two or more SELECT statements. These set operators include UNION, UNION ALL, INTERSECT, and MINUS.

In Oracle SQL, all set operators have equal precedence. This means that when multiple set operators are used in a single query, they are evaluated from left to right, regardless of the specific operator.

Therefore, the correct answer is:

A. True - This option is correct because all set operators in Oracle SQL have equal precedence.

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

  1. True

  2. False


Correct Option: A
- Hide questions