CS403-Midterm
1 / 50
Structural constraints of a relationship type refer to
2 / 50
Which of the following constraints enforces entity integrity?
3 / 50
Consider the following statements. A. An entity integrity constraint states that no primary key value can be null. B. A referential integrity constraint is specified between two relations. C. A foreign key cannot be used to refer to its own relation. Identify which of the above statements is/are correct.
4 / 50
5 / 50
The ER- data model is an example of:
6 / 50
Identify the correct way to implement one-to-one relationship in tables?
7 / 50
8 / 50
Which of the following statements is NOT correct?
9 / 50
As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.
10 / 50
11 / 50
Which of the following is a correct way to implement one-to-many relationship while designing tables?
12 / 50
Which of the following enforces a relation into 1st normal form?
13 / 50
A collection of concepts that can be used to describe the structure of a database
14 / 50
Select the correct statement among the following.
15 / 50
Identify the correct statement.
16 / 50
In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
17 / 50
Which of the following concepts is applicable with respect to 2NF?
18 / 50
19 / 50
Identify the correct statement with respect to normalization.
20 / 50
21 / 50
Identify the INCORRECT statement among the given
22 / 50
Select the correct statement about the ANSI/SPARC architecture.
23 / 50
Which of the following is correct?
24 / 50
Which of the following is true about relational schema?
25 / 50
A software package designed to store and manage databases
26 / 50
A database system allows the following EXCEPT
27 / 50
28 / 50
Which of the following is not true about relational tables?
29 / 50
Which of the following is INCORRECT statement concerning the database design process?
30 / 50
Which of the following is NOT a feature of Context DFD?
31 / 50
32 / 50
Which of the following is true for the relational model?
33 / 50
34 / 50
Consider the relation Interview (CandidateNo, InterviewDate, InterviewTime, StaffNo, RoomNo) and the following functional dependencies. FD1 : CandidateNo, InterviewDate -> InterviewTime, StaffNo, RoomNo FD2 : RoomNo, InterviewDate, InterviewTime -> StaffNo, CandidateNo FD3 : StaffNo, InterviewDate -> RoomNo Which of the following is correct?
35 / 50
36 / 50
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
37 / 50
Controlling redundancy in a database management system DOES NOT help to
38 / 50
Database management systems, operating systems, applications and utilities are all examples of ____.
39 / 50
Which of the following most certainly implies the need for an entire table to implement?
40 / 50
41 / 50
Which of the following is a feature of PRIMARY KEY constraint?
42 / 50
Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the above data?
43 / 50
44 / 50
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
45 / 50
A relation (from the relational database model) consists of a set of tuples, which implies that
46 / 50
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
47 / 50
A collection of related data is
48 / 50
Which of the following is not a benefit of normalization?
49 / 50
Which of the following is true about NOT NULL constraint?
50 / 50
Which of the following is INCORRECT with respect to file systems?
Your score is
The average score is 22%
Restart quiz