Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement?
Static sql is hard-coded in a program when the programmer knows the statements to be executed. For dynamic sql the program must dynamically allocate memory to receive the query results.
A Cartesian product results from a faulty query. It is a row in the results for every combination in the join tables.
Latest Answer : IF YOU CREATE A PRIMARY KEY IT IS MANDATORY THAT YOU SHOULD CREATE AN INDEX FOR THAT TABLE ON THAT PRIMARY KEY,WITHOUT WHICH YOU CAN NOT ACCESS THE TABLE ...
Latest Answer : group :- is used to find the sum and orderby is like checking the condition .furter explansion will be provided upon req! ...
Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36
Latest Answer : The ans shud be 6*6 = 36 , a cartesian product. ...
Table1 has the following data – Book Chapter ---------------------------- DB2 Retrieval DB2 Updates DB2 Locking COBOL File processing COBOL Working storage JCL Job statement CICS Maps What
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. ...
Which of the following DB2 components allows references to Oracle and DB2 databases in a single query? A. DB2 Query Patroller B. DB2 Warehouse Manager C. DB2 Relational Connect D. DB2 Connect Enterprise
Given a read-only application that requires consistent data for every query, which isolation levels should it use to provide the most concurrency with other applications doing updates?
Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?
