DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
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
133. Which oracle command has the explicit commit statement
- Grant
- Insert
- Drop
- Create
134. Which type of row id for the propionate does the oracle global index uses
- partial
- full
- restricted
- Extend
135. The output of the query SELECT REPLACE ( RTRIM (
- ANTICIPASHUNON
- ANTICISHUNONPATION
- ANTICIPAONSHUN
- None
136. We can use any arithmetic operators in any clause of sql except
- Where
- having
- from
- grouping
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
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
139. When using the multiple table to query information , in which clause we specify the names of tables
- having
- grouping
- where
- from
140. The query given bellow is SELECT E.ENAME=
- inner join
- outer join
- self join
- none