DBMS MCQ Question and Answer

DBMS MCQ Question and Answer
131. Assume that today is Monday of jan 2006 then what is the output of the query bellow SELECT TO CHAR (NEXT DAY(SYSDATE MONDAY,
  • 17/01/06
  • 17/jan/06
  • 17-01-06
  • 17-Jan-06
Show Answer
132. SELECT ROUND (631.1250,2)
  • 631.13
  • 6.31125
  • 63112.50
  • none of the above
Show Answer
133. Which oracle command has the explicit commit statement
  • Grant
  • Insert
  • Drop
  • Create
Show Answer
134. Which type of row id for the propionate does the oracle global index uses
  • partial
  • full
  • restricted
  • Extend
Show Answer
135. The output of the query SELECT REPLACE ( RTRIM (
  • ANTICIPASHUNON
  • ANTICISHUNONPATION
  • ANTICIPAONSHUN
  • None
Show Answer
136. We can use any arithmetic operators in any clause of sql except
  • Where
  • having
  • from
  • grouping
Show Answer
137. 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
138. 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
139. When using the multiple table to query information , in which clause we specify the names of tables
  • having
  • grouping
  • where
  • from
Show Answer
140. The query given bellow is SELECT E.ENAME=
  • inner join
  • outer join
  • self join
  • none
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test