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
