UTpaper

Free mock tests & test series

CIL MT · Computer Science

DBMS & SQL Previous Year Questions (page 2)

53 DBMS & SQL (Computer Science) questions asked in CIL MT previous year papers, each with the correct answer and explanation. Read them free on UTpaper, or attempt the full papers as timed online tests.

  • 53 questions
  • Official answer key
  • Free
Attempt CIL MT papers →All Computer Science questions

Other Computer Science topics

Data Structures 56Theory of Computation & Compilers 27Digital Logic & Number Systems 26Computer Networks 22Operating Systems 21Algorithms 16Computer Organization & Architecture 16Programming in C/C++ 11Discrete Mathematics 10
Q51CIL MT Systems, 27 Feb 2020 (8:00 AM)
In SQL, the _______ command is used to recompile view.
  1. AALTER VIEW
  2. BCOMPILE VIEW
  3. CCREATE VIEW
  4. DDEFINE VIEW
Show answerHide answer

Correct answer: (A) ALTER VIEW

Q52CIL MT Systems, 27 Feb 2020 (8:00 AM)
The _______ defines a set of operations on relations, paralleling the usual algebraic operations such as addition, subtraction or multiplication, which operate on numbers.
  1. Arelational calculus
  2. Breferential integrity
  3. Crelational algebra
  4. Drelations
Show answerHide answer

Correct answer: (C) relational algebra

Q53CIL MT Systems, 27 Feb 2020 (8:00 AM)
Which of the following is a unary operation?
  1. AIntersection
  2. BProjection
  3. CJoin
  4. DCartesian Product
Show answerHide answer

Correct answer: (B) Projection

How to use these CIL MT Computer Science questions

Every question here was asked in a real CIL MT paper; the paper and shift are shown on the card, and the number opens the question on its own page. Try each one before tapping Show answer, then attempt the full CIL MT papers as timed tests to check your speed under exam conditions.

More CIL MT subjects

English 75General Awareness 75Mathematics 75Reasoning 64