DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q131
Assume that today is Monday of jan 2006 then what is the output of the query bellow SELECT TO CHAR (NEXT DAY(SYSDATE MONDAY,
  • A 17/01/06
  • B 17/jan/06
  • C 17-01-06
  • D 17-Jan-06
Answer: Option D
Q132
SELECT ROUND (631.1250,2)
  • A 631.13
  • B 6.31125
  • C 63112.50
  • D none of the above
Answer: Option A
Q133
Which oracle command has the explicit commit statement
  • A Grant
  • B Insert
  • C Drop
  • D Create
Answer: Option B
Q134
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
Q135
The output of the query SELECT REPLACE ( RTRIM (
  • A ANTICIPASHUNON
  • B ANTICISHUNONPATION
  • C ANTICIPAONSHUN
  • D None
Answer: Option A
Q136
We can use any arithmetic operators in any clause of sql except
  • A Where
  • B having
  • C from
  • D grouping
Answer: Option C
Q137
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
Q138
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
Q139
When using the multiple table to query information , in which clause we specify the names of tables
  • A having
  • B grouping
  • C where
  • D from
Answer: Option D
Q140
The query given bellow is SELECT E.ENAME=
  • A inner join
  • B outer join
  • C self join
  • D none
Answer: Option C

📚 More from Database

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