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

Related Articles

Field Sales Trainee Hiring by Swiggy | Swiggy Jobs | Swiggy Internships

14 hours ago

IBM SkillsBuild Training Program | Google Career Certificate Scholarship Program

2 days ago

Infosys Springboard Fundamentals of Information Security Free Certification Program

2 days ago

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

Question 1: A relational database consists of a collection of *

• Tables
• Fields
• Records
• Keys

Question 2: The term _______ is used to refer to a row. *

• Attribute
• Tuple
• Field
• Instance

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

• Different
• Indivisbile
• Constant
• Divisible

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

• DDL
• DML
• DCL
• TCL

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

• delete
• purge
• remove
• drop

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

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

 Question 7: The number of attributes in relation is called as its *

• cardinality
• degree
• tuples
• entity

 Question 8: _______ joins are SQL server default *

• outer
• inner
• equi
• none

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

• 1
• 0
• null
• unknown

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

• on
• using
• set
• where

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

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

Question 12: How many tables may be included with a join? *

• 1
• 2
• 3
• all the above

 Question 13: How many join types in join condition: *

• 2
• 3
• 4
• 5

 Question 14: Which of the following is not an integrity constraint? *

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

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

• Participation
• position
• ROLE
• instance

 Question 16: The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is *

• single valued
• multi valued
• composite
• derived

 Question 17: Which of the following is a single valued attribute *

• Register_number
• address
• SUBJECT_TAKEN
• reference

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

• first
• second
• third
• fourth

 Question 19: 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

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

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