DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q71
SELECT ROUND (631.1250,2)
  • A 631.13
  • B 6.31125
  • C 63112.50
  • D none of the above
Answer: Option A
Q72
SELECT SUSTR (ORACLE 2,3) FROM DUAL
  • A ORA
  • B RAC
  • C CLE
  • D ACL
Answer: Option B
Q73
Which oracle command has the explicit commit statement
  • A Grant
  • B Insert
  • C Drop
  • D Create
Answer: Option B
Q74
Which type of row id for the propionate does the oracle global index uses
  • A partial
  • B full
  • C restricted
  • D Extend
Answer: Option D
Q75
Which function implements the IF-THEN-ELSE statement
  • A Decode
  • B Encode
  • C Replace
  • D IF-ELSE
Answer: Option A
Q76
The output of the query SELECT REPLACE ( RTRIM (
  • A ANTICIPASHUNON
  • B ANTICISHUNONPATION
  • C ANTICIPAONSHUN
  • D None
Answer: Option A
Q77
We can use any arithmetic operators in any clause of sql except
  • A Where
  • B having
  • C from
  • D grouping
Answer: Option C
Q78
On Which side the outer join condition the join symbol should be there
  • A Both sides of the condition
  • B Either side of the condition
  • C The side that is deficient condition in information
  • D None of the above
Answer: Option C
Q79
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
  • A outer join
  • B inner join
  • C equi join
  • D normal join
Answer: Option C
Q80
What is the number of the values a sub query using the in operator can return to the parent query
  • A 1
  • B 32456
  • C 0
  • D unlimited
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test