Tuesday , February 27 2024
Breaking News

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

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

About Clear My Certification

Check Also

iit hyderabad

Summer Undergraduate Research Exposure (SURE) Internship 2024 – IIT Hyderabad ( Complete Details )

Eligibility: ONLY NON-IIT HYDERABAD STUDENTS with below mentioned eligibility.A. Should be a first year MSc …

Leave a Reply

Your email address will not be published. Required fields are marked *