0

databases Online Quiz - 222

Description: databases Online Quiz - 222
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. It specifies which versions of the element should appear in the view

  2. It specifies what type of branching logic used.

  3. All the above

  4. None of the above


Correct Option: A
  1. ClearCase LT

  2. ClearCase

  3. ClearCase MultiSite

  4. All the above


Correct Option: D

What are the different clear case Roles

  1. Configuration Manager

  2. Administrator

  3. Tester

  4. a & b


Correct Option: D
  1. Sets up workspace

  2. Integrates changes

  3. Creates baseline

  4. a & b


Correct Option: D
  1. Contains orphaned elements, which are no longer catalogued in any version of any directory

  2. All the deleted elements will be stored

  3. It the meta directory of the ClearCase

  4. None


Correct Option: A
  1. The application must release the row-level Share lock it holds and acquire an Update lock on the row

  2. The application must release the row-level Share lock it holds and acquire an Update lock on the table

  3. The row-level Share lock will automatically be converted to a row-level Up-date lock

  4. The row-level Share lock will automatically be escalated to a table-level Up-date lock


Correct Option: C
  1. Restrict users' access to a subset of table data

  2. Ensure that rows inserted remain within the scope of a definition

  3. Produce an action as a result of a change to a table

  4. Provide users with an alternate view of table data


Correct Option: C

Which wildcard character is used for a single character replacement

  1. %

  2. &

  3. _

  4. None of the above


Correct Option: C
  1. S9 (4) COMP-3

  2. S9 (4)

  3. 9 (4)

  4. S9 (4) COMP


Correct Option: D
  1. SYNONYM

  2. ALIAS

  3. All of the above

  4. None of the above


Correct Option: A

The maximum number of tables that can be joined is _____________

  1. 20

  2. 10

  3. 15

  4. No Limit.


Correct Option: C

B37 abend during SPUFI is due to

  1. Space Issues

  2. Data Issues

  3. No records found while querying the table

  4. Both a & b


Correct Option: A
  1. Joins

  2. Unions

  3. Nested SELECT

  4. All of the above


Correct Option: D

Which of the following tools can be used to automate table reorganization Operations ?

  1. Control Center

  2. Command Center

  3. Command Line Processor

  4. Task Center


Correct Option: D

Given the following statement: CREATE TABLE t1 col1  SMALLINT NOT NULL PRIMARY KEY, col2  VARCHAR(200) NOT NULL WITH DEFAULT NONE, col3  DECIMAL(5,2) CHECK (col3 >= 100.00), col4  DATE NOT NULL WITH DEFAULT) Which of the following definitions will cause the CREATE TABLE statement to fail?

  1. COL1

  2. COL2

  3. COL3

  4. COL4


Correct Option: B
- Hide questions