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

Could we able to create a assembly in SQL 2005?

  1. True

  2. False


Correct Option: A

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

How to rename a existing table.

  1. sp_rename TableNewName, ExistingTableName;

  2. sp_renametable ExistingTableName, TableNewName;

  3. sp_rename ExistingTableName, TableNewName;

  4. sp_renametable TableNewName, ExistingTableName;


Correct Option: C

By using TOP() can we able to update a record

  1. True

  2. False


Correct Option: B

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

Oracle treats zero-length character strings as nulls.

  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
- Hide questions