CS403 Midterm Online Quiz

0%
2 votes, 5 avg

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

Which of the following constraints enforces entity integrity?

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

Which of the following constraints enforces entity integrity?

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

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.

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

Which of the following statements is NOT correct?

19 / 50

Identify the correct statement with respect to normalization.

20 / 50

Which of the following statements is NOT correct?

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

Which of the following is a correct way to implement one-to-many relationship while designing tables?

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

Which of the following is NOT a feature of Context DFD?

32 / 50

Which of the following is true for the relational model?

33 / 50

A collection of concepts that can be used to describe the structure of a database

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

Which of the following is true about relational schema?

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

Identify the correct statement.

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

The ER- data model is an example of:

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%

0%

Qunoot e Nazilah
Dua e Hajat
4 Qul
6 Kalma
Dua-e-Akasha
Darood Akbar
Surah Fatiha
Dua-e-Ganj Ul Arsh
Dua-e-Jamilah
Ayat-ul-Kursi