IF Statements
BLOCK 1
.
IF a >= b THEN
do_this …..;
ELSE
do_that….;
END IF
BLOCK 2
.
IF a < b THEN
do_that …..;
ELSE
do_this….;
END IF;
• Given any pair of non-NULL values for “a” and”b”,
will Block 1 and Block 2 do the same thing?
• What if either “a” or”b” (or both) is NULL?
What is 2nf and 3nf?
What are the steps involved in Instance Recovery ?
What database should I learn first?
What is the importance of database in an organization?
Explain the Difference Between a Primary Key and a Foreign Key.
What is cold backup and hot backup (in case of oracle)?
Enlist the disadvantages of query.
What is the use of SHOW option in IMP command ?
What do you mean by dml compiler?
What is database definition (dbd)?
What are the objectives of rdbms?
What are the differences between hash join, merge join and nested loops?