0

databases Online Quiz - 90

Description: databases Online Quiz - 90
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Atomicity,Concurrently,Isolation,Durability

  2. Atomicity,Consistency,Incremental,Durability

  3. Atomicity,Consistency,Isolation and Durability

  4. Atomicity,Concurrently,Incremental,Durability


Correct Option: A

Identity is a column that automatically generates numeric values.

  1. True

  2. False


Correct Option: A
  1. Read Uncommitted

  2. Read Committed

  3. Serializable

  4. Repeatable Read


Correct Option: A,B,C,D
  1. 10.5.1702

  2. 8.00.223

  3. 9.00.4285

  4. 7.00.1152


Correct Option: C
  1. Subqueries can have up to 16 levels of nesting

  2. Subqueries can have up to 50 levels of nesting

  3. Subqueries returning only one row can follow β€œ=” in a WHERE clause

  4. Subqueries returning only one row can follow β€œIN” in a WHERE clause


Correct Option: A,C,D

For which of the following queries may a merge join be considered?

  1. Outer joins

  2. Multi-table updates and deletes

  3. Equi-joins

  4. Equi-join with a text column in select list


Correct Option: C
  1. All select lists in the UNION must have the same number of expressions

  2. Corresponding columns must have the same column names

  3. Corresponding columns must be of the same datatype or the server must be able to implicitly convert them

  4. Corresponding columns must be in the same order


Correct Option: A,C,D

Choose the correct statements about the union clause in ASE (Choose 2)

  1. Duplicate rows are removed from the result set by default

  2. ASE evaluates a statement containing union operators from left to right

  3. Order by and group by clauses are not allowed in a union query

  4. The into clause can be used only in the first query


Correct Option: A,B,D

Which of the following are true about triggers? (Choose 2)

  1. the inserted and deleted tables are created manually

  2. triggers can be disabled using alter table

  3. a single trigger can be created for both insert and delete

  4. @@sqlstatus contains the number of rows affected


Correct Option: B,C

Which T-SQL elements can be used in a stored procedure? (Choose 2)

  1. 'return', without a return value

  2. 'rollback transaction'

  3. 'rollback trigger'

  4. the built-in function 'update()'


Correct Option: A,B

Which ASE table contains the source code of a stored procedure?

  1. sysprocedures

  2. syscomments

  3. syslogs

  4. systext


Correct Option: B

What is the maximum number of characters that can be passed to a stored procedure through a single char or varchar parameter without being truncated?

  1. 127

  2. 255

  3. 16384

  4. equal to the server page size


Correct Option: C
  1. Index

  2. Cluster

  3. Package

  4. DB links

  5. Function


Correct Option: A,C,E

A call statement inside the trigger body enables you to call:

  1. Package

  2. Function

  3. Procedure

  4. Another DB trigger


Correct Option: C

What part of a DB trigger determines the number of times a trigger body executes?

  1. Trigger type

  2. Trigger body

  3. Trigger event

  4. Trigger timing


Correct Option: A
- Hide questions