Tag: databases

Questions Related to databases

Can a function take OUT parameters.?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Can the default values be assigned to actual parameters?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Can you use a commit statement within a database trigger?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Can we call a procedure from Anonymous PL/SQL block?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

can we have more than one column of BLOB(data type to store images) in a table?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following can duplicate the structure and related objects of a database table?
technology databases

  1. Copy table

  2. Alter table

  3. Export table

  4. Generate DDL

Show answer
Correct Option: D

DB2 Cursor Stablity i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consistency

technology databases

  1. Both are True

  2. i) Is Only True

  3. ii) is only True

  4. Neither is True

Show answer
Correct Option: A

DB2 Indexes i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column.
technology databases

  1. Both are True

  2. i) Is Only True

  3. ii) is only True

  4. Neither is True

Show answer
Correct Option: A

DB2 Index Storate Format Indexes is Stored in
technology databases

  1. B - Tree format

  2. Hash Table

  3. AVL Tree

  4. Red Black Tree

Show answer
Correct Option: A

When do you open cursor before Fetching i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution.
technology databases

  1. Both are True

  2. i) Is Only True

  3. ii) is only True

  4. Neither is True

Show answer
Correct Option: A