Home › Quizzes › DBMS

DBMS

Fundamental DBMS concepts covering entity-relationship modeling, keys, relational operations, and SQL queries

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

The process of assigning similar objects/entities to object classes/entity type is known as

  1. classification
  2. instantiation
  3. specialisation
  4. generalisation
  5. none of these
Question 2 Multiple Choice (Single Answer)

A subclass can be in more than one class or subclass relationship. What is the name of this process?

  1. Specialisation
  2. Specialisation lattice
  3. Shared subclass
  4. Specialisation hierarchy
  5. None of these
Question 3 Multiple Choice (Single Answer)

To filter the tuples of a relation on which it is applied based on some condition mentioned is called _________.

  1. rename operation
  2. project operation or projection
  3. unary operation
  4. select operation or selection
  5. option 3 and 4
Question 4 Multiple Choice (Single Answer)

How can you define a weak entity type?

  1. It is dominant entity type.
  2. It is coordinate entity type.
  3. It is parent entity type.
  4. It is child entity type.
  5. None of these
Question 5 Multiple Choice (Single Answer)

Which of the following terms describe(s) strong entity type?

  1. Child entity type
  2. Parent entity type
  3. Owner entity type
  4. Option 1 and 3
  5. Both 2 and 3
Question 6 Multiple Choice (Single Answer)

Which of the following terms is used to describe minimal super key?

  1. Prime attribute
  2. Primary key
  3. Candidate key
  4. Partial key
  5. None of these
Question 7 Multiple Choice (Single Answer)

With reference to a table which key resides in another table?

  1. The primary key
  2. The reference key
  3. The candidate key
  4. The foreign key
  5. None of these
Question 8 Multiple Choice (Single Answer)

Which key or part of that key cannot contain a null value?

  1. Primary key
  2. Secondary key
  3. Super key
  4. Both 1 and 2
  5. None of these
Question 9 Multiple Choice (Single Answer)

From which of the following keys does a database designer choose a primary key?

  1. The super keys
  2. The candidate keys
  3. The prime attribute
  4. Options 2 and 3
  5. None of these
Question 10 Multiple Choice (Single Answer)

Which of the following queries corresponds to finding the name and number of employees in each department?

  1. select dname,count(*) from emp group by dname
  2. select dname,count(*) from emp group by eid
  3. select dname,count(*) from emp group by dname,eid
  4. options 2 and 3
  5. none of these
Question 11 Multiple Choice (Single Answer)

Which predicate is not use in SQL?

  1. IN
  2. BETWEEN
  3. LIKE
  4. AMONG
  5. None of these
Question 12 Multiple Choice (Single Answer)

SELECT ename FROM emp WHERE ename LIKE 'S%';
Which of the following names can be selected by the above query?

  1. SURESH
  2. SURES
  3. URES
  4. Both 1 and 2
  5. None of these
Question 13 Multiple Choice (Single Answer)

Which of the following commands makes the updates performed by the transaction permanent in the database?

  1. ROLLBACK
  2. COMMIT
  3. TRUNCATE
  4. DELETE
  5. None of these
Question 14 Multiple Choice (Single Answer)

SELECT ename FROM emp WHERE ename LIKE '%A_E%';
Which name from the following names can selected by the above query?

  1. SALEA
  2. ALISHE
  3. SASLEA
  4. Options 2 and 3
  5. None of these
Question 15 Multiple Choice (Single Answer)

Which query among following can give more than one name (employee name or ename)?

  1. SELECT ename WHERE ename AMONG ('value1', 'value2','value3', ...)
  2. SELECT ename WHERE ename = ('value1', 'value2','value3', ...)
  3. SELECT ename WHERE ename IN ('value1', 'value2','value3', ...)
  4. SELECT ename WHERE ename WITH ('value1', 'value2','value3', ...)
  5. None of these
← Back to Quizzes