Is it possible to declare or create a cursor for update of table? If no tell me why?
What are the differences between hash join, merge join and nested loops?
What do you mean by entity type extension?
Why are recursive relationships are bad? How do you resolve them?
What are the disadvantages of file processing systems?
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 a database in computer?
Segregate database technology's development.
Define fragmentation.
What is stored procedure in database?
How do you exit a database?
What is buffer manager?
What is record in a database?
What is data types in database?
Explain the term entity type in dbms?