DBMS MCQ Question and Answer

DBMS MCQ Question and Answer
71. SELECT ROUND (631.1250,2)
  • 631.13
  • 6.31125
  • 63112.50
  • none of the above
Show Answer
72. SELECT SUSTR (ORACLE 2,3) FROM DUAL
  • ORA
  • RAC
  • CLE
  • ACL
Show Answer
73. Which oracle command has the explicit commit statement
  • Grant
  • Insert
  • Drop
  • Create
Show Answer
74. Which type of row id for the propionate does the oracle global index uses
  • partial
  • full
  • restricted
  • Extend
Show Answer
75. Which function implements the IF-THEN-ELSE statement
  • Decode
  • Encode
  • Replace
  • IF-ELSE
Show Answer
76. The output of the query SELECT REPLACE ( RTRIM (
  • ANTICIPASHUNON
  • ANTICISHUNONPATION
  • ANTICIPAONSHUN
  • None
Show Answer
77. We can use any arithmetic operators in any clause of sql except
  • Where
  • having
  • from
  • grouping
Show Answer
78. On Which side the outer join condition the join symbol should be there
  • Both sides of the condition
  • Either side of the condition
  • The side that is deficient condition in information
  • None of the above
Show Answer
79. Consider the following query SELECT DNAME, ENAME FROM DEPT D, EMP E WHERE D.DEPTNO=E. DEPTNO ORDER BY DNAME, NAME This join is called as
  • outer join
  • inner join
  • equi join
  • normal join
Show Answer
80. What is the number of the values a sub query using the in operator can return to the parent query
  • 1
  • 32456
  • 0
  • unlimited
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test