Tag: databases

Questions Related to databases

Which is NOT Date function?
technology databases

  1. ADD_MONTHS

  2. NEXT_DAY

  3. LAST_DAY

  4. NEXT_MONTHS

Show answer
Correct Option: B

Which is NOT TCL Statements ?
technology databases

  1. SAVEPOINT

  2. GRANT

  3. ROLLBACK

  4. COMMIT

Show answer
Correct Option: B

Which is Single Row Function?
technology databases

  1. CONCAT

  2. MOD

  3. ROUND

  4. CONVERSION FUNCTION

Show answer
Correct Option: A,B,C,D

Normalization: which is automatic NORMAL form? (NF=normal form)
technology databases

  1. 1NF

  2. 2NF

  3. 3NF

  4. 4NF

Show answer
Correct Option: A
  1. What is VOB
technology databases

  1. Versioned Object

  2. Versioned Object Base

  3. Version Objects

  4. Versioned Objects

Show answer
Correct Option: A,B,C,D

Choose All Approriate About Clear Case
technology databases

  1. provides parallel development

  2. provides versioning

  3. provides automation

  4. All the above

Show answer
Correct Option: A,B,C,D

Using Clear Case what are all can be created
technology databases

  1. Branches

  2. Labels

  3. Both 1 and 2

  4. All the above

Show answer
Correct Option: A,B,C,D

After an element is added to a directory "Add to Source Control" need to done to give control to the clearcase over that element

technology databases

  1. True

  2. False

Show answer
Correct Option: A

You are developing SQL statements for the application. Which of the following SQL operations requires the use of a subquery?
technology databases

  1. IN

  2. Between

  3. Exists

  4. Like

Show answer
Correct Option: C

Which is the most commonly used type of table?
technology databases

  1. Clustered

  2. Partitioned

  3. Regular

  4. Index organized

Show answer
Correct Option: C