LawMint Sign in

UGC NET Computer Science and Applications Database Management Systems Previous Year Questions

Try the preview and open any solution for a worked explanation.

UGC NET Computer Science and Applications practice pack

The practice pack for UGC NET Computer Science and Applications is coming soon to LawMint.

Question 1

For the relation schema r(M, Y, P, MP, C) and set of functional dependencies F={M→MP,{M, Y}→P, MP→C}, which of the following is the key?

Select one answer

Question 2

Which of the following relational algebraic expression is equivalent to the SQL query

SELECT X FROM B WHERE Y
Select one answer

Question 3

Which of the following are true?

A. A database relation may have only one primary key
B. Every key is a candidate key
C. There can be multiple candidate keys
D. There can be more than one super keys
E. Every candidate key is a primary key.

Select one answer

Question 4

What is the correct sequence of database design process?

  • A. Create conceptual schema
  • B. Data model mapping
  • C. Requirements collection and analysis
  • D. Physical design
Select one answer

Question 5

Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R Assertion A: OLAP systems are optimized for complex queries and analysis. Reason R: OLTP systems are designed for transactions processing with large read-only queries.

Select one answer

Question 6

Which of the following statements are correct?

A. The HAVING clause is an optional clause which tells Oracle to group rows based on distinct values that exist for specified columns.
B. Unions cannot be used in subqueries.
C. The INTERSECT clause outputs only rows produced by both the queries intersected.
D. The statement containing a subquery is called a parent statement.
E. If a SELECT statement is defined as a non-correlated subquery, the innermost SELECT statement gets executed first.

Select one answer

Question 7

Match the LIST-I with LIST-II

LIST-ILIST-II
A. V-ModelI. Trigger transition
B. Incremental process modelII. Classic life cycle
C. Spiral ModelIII. Risk Driven
D. Concurrent ModelIV. Core product
Select one answer

Question 8

Consider the relation T1(A, B, C, D, E)with the dependencies{EB→C, D→E, EA→B}andT2(A, B, C, D)with the dependencies{C→A, A→B, A→D}. Which of the following is TRUE?

Select one answer

Question 9

In a relational database, which one of the following is CORRECT:

Select one answer

Question 10

Consider the following three relations Employee(eid, eName), Comp(cid, cName), Own(eid, cid). Which of the following relational algebra expression return the set of eids who own all brands:

Select one answer

Continue practising

The practice pack for UGC NET Computer Science and Applications is coming soon to LawMint.

UGC NET Computer Science and Applications practice pack

The practice pack for UGC NET Computer Science and Applications is coming soon to LawMint.