41. In E-R Notation, multivalued attribute is represented by _______

A. Ellipse 
B. Dotted-Ellipse 
C. Double-Ellipse 
D. None of the above 

42. A view of database that appears to an application program is known as?

A. Report 
B. subscheme 
C. structure 
D. Meta Data 

43. What is the difference between SQL99 and SQL3

A. SQL99 is a predecessor of SQL3 
B. SQL99 is a successor of SQL3 
C. both are one and the same 
D. none of the above 

44. What is the order of execution of SQL clauses 1.having 2.group by 3.where 4.orderby

A. 1 2 3 4 
B. 3 2 1 4 
C. 2 3 4 1 
D. 4 3 1 2 

45. The max length of varchar2 when used in table is

A. 16k 
B. 32k 
C. 4k 
D. either B or C 

46. Implicit and Explicit cursor has attribute

A. %ISOPEN 
B. %WASFOUND  
C. %COLCOUNT 
D. none of these 

47. Which of the following trigger types will be impacted by constraining factors brought on by mutating tables

A. row triggers only 
B. statement trigger only 
C. both statement and row triggers  
D. neither row or statement triggers 

48. DBMS does not have ________model

A. hierarchical model 
B. network model 
C. relational model 
D. hybrid model 

49. Which of the following statement is true about implicit cursors

A. implicit cursors are used for SQL statements that are not named 
B. implicit cursors are no longer a feature in oracle 
C. both 
D. all 

50. A block from database buffer cache is marked as __________when modified

A. Dirty 
B. Modified 
C. Mod 
D. None of the above 

• 1
• 2
• 3
• 4
• 5