60:00
0/15 Attempted
Scoreboard
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Total Score 0
Marks 0
Your Progress
Attempted 0
Correct 0
Incorrect 0
Skipped 0
Score 0
Marks 0

DBMS MCQs — Test 1

Page 1 of 2

Review Skipped Questions

0
Question 1
A rotational database consists of …….?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 2
A …… in a table represents a relationship among a set of values?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 3
The term …… is used to refer to a row?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 4
The term attribute refers to a ……. of a table?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 5
Which of the following is a tuple-generating dependency?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 6
The main task carried out in the ……. is to remove repeating attributes to separate tables?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 7
Which of the normal form is based on multi-valued dependencies?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 8
Which forms have a relation that possesses data about an individual entity?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 9
Which of the following has each related entity set its own schema and there is an additional schema for the relationship set?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017
Question 10
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set?
PPSC - Lecturer Computer Science IT - Higher Education Department Punjab - 2017