Latest Answer: no an index cannot be displayed,as it is a system generated one. ...
i) Cursor Stablity Leads to Higher concurency ii) Repeatable Read Leads to Higher consistency1 Both are True2 i) Is Only True3 ii) is only True4 Neither is TrueBoth are True
Latest Answer: both are true ...
Select the correct statement 1 Storage groups can be altered2 Database can be altered3 Tablespace can be altered4 All of the Choices
All of the Choices
1 Declare / fetch / open / close2 Open / Declare / fetch /close3 Declare / open / fetch /close4 None of the aboveDeclare / open / fetch /close
Latest Answer: 3. Declare/open/fetch/close ...
What are memory structures used to handle multiple row selections at a time 1 Cursors2 Host Variables3 Indicator Variable4 SQLCACursors
i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column. 1 Both are True2 i) is only True3 ii) is Only True4 Neither is True
Latest Answer: Both are true. ...
i) Synonyms can refer to local and remote table ii) Alias can refer only to local tables Of the Statement 1 Both are TRUE2 Both Are False3 i) is Only True4 ii) is Only True Both Are False
Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree
B - Tree format
Latest Answer: B tree by default in DB2 UDB for LUW ...
IRLM is a module of DB2 which does1 Logging2 Thread creation3 Concurrency control using locking4 both logging and thread creation Concurrency control using locking
i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution. Of the Statement.Which are true?1 Both are True2 i) is only True3 ii) is False Both
Latest Answer: Both are true. ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
