Priya Dogra – Certification | Jobs | Internships
Related Articles
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
