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?
Question 2
Which of the following relational algebraic expression is equivalent to the SQL query
SELECT X FROM B WHERE YQuestion 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.
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
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.
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.
Question 7
Match the LIST-I with LIST-II
| LIST-I | LIST-II |
|---|---|
| A. V-Model | I. Trigger transition |
| B. Incremental process model | II. Classic life cycle |
| C. Spiral Model | III. Risk Driven |
| D. Concurrent Model | IV. Core product |
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?
Question 9
In a relational database, which one of the following is CORRECT:
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:
Previous papers with Database Management Systems questions
- UGC NET Computer Science 2026 06 22 Evening
- UGC NET Computer Science 2026 01 02 Morning
- UGC NET Computer Science 2025 06 26 Morning
- UGC NET Computer Science 2025 01 06
- UGC NET Computer Science 2024 08 23 Morning
- UGC NET Computer Science 2024 06 18
- UGC NET Computer Science 2023 12 07 Evening
- UGC NET Computer Science 2023 06 17 Morning
- UGC NET Computer Science 2023 03 15 Morning
- UGC NET Computer Science 2023 03 11 Evening
- UGC NET Computer Science 2022 10 08 Morning
- UGC NET Computer Science 2021 11 26 Evening
- UGC NET Computer Science 2020 11 11 Evening
- UGC NET Computer Science 2019 12 04 Morning
- UGC NET Computer Science 2019 06 24 Morning
- UGC NET Computer Science 2018 12 20 Morning
- UGC NET Computer Science 2018 07 Paper 2
- UGC NET Computer Science 2017 11 Paper 3
- UGC NET Computer Science 2017 11 Paper 2
- UGC NET Computer Science 2017 01 Paper 3
- UGC NET Computer Science 2017 01 Paper 2
- UGC NET Computer Science 2016 08 Paper 3
- UGC NET Computer Science 2016 08 Paper 2
- UGC NET Computer Science 2016 07 Paper 3
- UGC NET Computer Science 2016 07 Paper 2
- UGC NET Computer Science 2015 12 Paper 3
- UGC NET Computer Science 2015 12 Paper 2
- UGC NET Computer Science 2015 06 Paper 3
- UGC NET Computer Science 2015 06 Paper 2
- UGC NET Computer Science 2014 12 Paper 3
- UGC NET Computer Science 2014 12 Paper 2
- UGC NET Computer Science 2014 06 Paper 3
- UGC NET Computer Science 2014 06 Paper 2
- UGC NET Computer Science 2013 12 Paper 3
- UGC NET Computer Science 2013 12 Paper 2
- UGC NET Computer Science 2013 09 Paper 3
- UGC NET Computer Science 2013 09 Paper 2
- UGC NET Computer Science 2013 06 Paper 3
- UGC NET Computer Science 2013 06 Paper 2
- UGC NET Computer Science 2012 12 Paper 3
- UGC NET Computer Science 2012 12 Paper 2
- UGC NET Computer Science 2012 06 Paper 3
- UGC NET Computer Science 2012 06 Paper 2
- UGC NET Computer Science 2011 12 Paper 2
- UGC NET Computer Science 2011 06 Paper 2
- UGC NET Computer Science 2010 12 Paper 2
- UGC NET Computer Science 2010 06 Paper 2
- UGC NET Computer Science 2009 12 Paper 2
- UGC NET Computer Science 2009 06 Paper 2
- UGC NET Computer Science 2008 12 Paper 2
- UGC NET Computer Science 2008 06 Paper 2
- UGC NET Computer Science 2007 12 Paper 2
- UGC NET Computer Science 2007 06 Paper 2
- UGC NET Computer Science 2006 12 Paper 2
- UGC NET Computer Science 2006 06 Paper 2
- UGC NET Computer Science 2005 12 Paper 2
- UGC NET Computer Science 2005 06 Paper 2
- UGC NET Computer Science 2004 12 Paper 2
UGC NET Computer Science and Applications practice pack
The practice pack for UGC NET Computer Science and Applications is coming soon to LawMint.