A NATIONAL LEVEL E-QUIZ ON DATABASE MANAGEMENT SYSTEMS | DBMS FREE CERTIFICATE

    402
    0

    We are from Department of Computer Science and Engineering from GATE Institute of Technology and Sciences conducting the online quiz on Database Management Systems. The quiz contains 20 questions. The candidates who got 40% of marks will get E-Certificate.

    APPLY LINK : CLICK HERE

    A relational database consists of a collection of *

    • Tables
    • Fields
    • Records
    • Keys

    The term _______ is used to refer to a row. *

    • Attribute
    • Tuple
    • Field
    • Instance

     A domain is atomic if elements of the domain are considered to be ____________ units. *

    • Different
    • Indivisbile
    • Constant
    • Divisible

     CREATE TABLE employee (name VARCHAR, id INTEGER) What type of statement is this? *

    • DDL
    • DML
    • DCL
    • TCL

     To remove a relation from an SQL database, we use the ______ command. *

    • delete
    • purge
    • remove
    • drop

    If we want to retain all duplicates, we must write ________ in place of union. *

    • union all
    • union some
    • intersect all
    • intersect some

     The number of attributes in relation is called as its *

    • cardinality
    • degree
    • tuples
    • entity

     _______ joins are SQL server default *

    • outer
    • inner
    • equi
    • none

     A Boolean data type that can take values true, false, and________ *

    • 1
    • 0
    • null
    • unknown

     The____condition allows a general predicate over the relations being joined. *

    • on
    • using
    • set
    • where

     Which of the join operations do not preserve non matched tuples? *

    • left outer join
    • right outer join
    • inner join
    • natural join

    How many tables may be included with a join? *

    • 1
    • 2
    • 3
    • all the above

     How many join types in join condition: *

    • 2
    • 3
    • 4
    • 5

     Which of the following is not an integrity constraint? *

    • not null
    • poisive
    • unique
    • check ‘predicate’

     The function that an entity plays in a relationship is called that entity’s _____________ *

    • Participation
    • position
    • ROLE
    • instance

     The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is *

    • single valued
    • multi valued
    • composite
    • derived

     Which of the following is a single valued attribute *

    • Register_number
    • address
    • SUBJECT_TAKEN
    • reference

    In the __________ normal form, a composite attribute is converted to individual attributes. *

    • first
    • second
    • third
    • fourth

     A table on the many side of a one to many or many to many relationship must: *

    • Be in Second Normal Form (2NF)
    • Be in Third Normal Form (3NF)
    • Have a single attribute key
    • Have a composite key

    Which forms has a relation that possesses data about an individual entity: *

    • 2 NF
    • 3 NF
    • 4 NF
    • 5 NF

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here