CS8492 - DATABASE MANAGEMENT SYSTEMS (UNIT 1)

UNIT 1 - RELATIONAL DATABASES

20 flashcards · Computer Science · by Poongothai K

  1. A relational database consists of a collection of A) Tables B) Fields C) Records D) Keys

    A) Tables

  2. A __________ in a table represents a relationship among a set of values A) Column B) Key C) Row D) Entry

    C) Row

  3. The term __________ is used to refer to a row

    Tuple

  4. The tuples of the relations can be of ________ order A) Any B) Same C) Constant D) Sorted

    A) Any

  5. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record? A) Candidate Key B) Super Key C) Foreign Key

    B) Super Key

  6. Consider attributes ID, NAME and CITY. Which one of this can be considered as a super key? A) NAME B) ID C) CITY D) CITY, ID

    B) ID

  7. A ________ is a property of the entire relation, rather than the individual tuples in which each tuple is unique.

    Key

  8. Which one of the following cannot be taken as a primary key? A) Id B) Register number C) Dept_Id D) Street

    D) Street

  9. Using which language can a user request information from a database? A) Query B) Relational C) Structural D) Compiler

    A) Query

  10. The __________ operation performs a set union of two "similarly structured" tables

    Union

  11. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is A) Join B) Projection C) Select D) Union

    C) Select

  12. SELECT * FROM employee What type of statement is this? A) DML B) DDL C) View D) Integrity Constraint

    A) DML

  13. To remove a relation from an SQL database, we use the _______ command

    Drop table

  14. The ________ clause is used to list the attributes desired in the result of a query.

    Select

  15. In the given query, which of the keyword has to be inserted? INSERT INTO employee _________ (1002, Jeoy, 2000); A) Table B) Values C) Relation D) Field

    B) Values

  16. The intersection operator is used to get the _______ tuples.

    Common

  17. The number of attributes in relation is called as its ________

    Degree

  18. _________ joins are SQL server default

    Inner

  19. Using the _______ clause retains only one copy of such identical tuples

    Unique

  20. Which of the following is not an aggregate function? A) Avg B) Sum C) With D) Min

    C) With