| 1 |
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Select correct option: |
Database Designer
Database Administrator
End User
Application Programmer
|
| 2 |
Which of the following is a feature of PRIMARY KEY constraint? |
unique identifier for a row within a database table.
allow any actions that would destroy links between tables
limit the values that can be placed in a column.
enforces that the column will only accept null values.
|
| 3 |
Which of the following enforces a relation into 1st normal form?
|
The domain of attribute must include only atomic values
Every non-key attribute is fully functionally dependent on primary key
non-key attribute is non-transitively dependent on primary key.
Every non-key attribute is partially dependent on super key
|
| 4 |
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 |
Only A
Only B
B and C
A and B
|
| 5 |
If K is a foreign key in relation R1, then |
every tuple of R1 has a distinct value for K
k can not have a null value for tuples in R1
K is a key for some other relation.
K is a primary key for R1.
|
| 6 |
A description on a particular collection of data using the given data model |
Database
Schema
None of the above
Relation
|
| 7 |
A weak entity type |
must have total participation in an identifying relationship
does not have a key attribute(s)
both (a) and (b)
none of the above
|
| 8 |
A collection of related data is |
Logical model
Database
Data
Relational model
|
| 9 |
Which of the following statements is correct with respect to the two relations given above? |
The two relations are not union-compatible since their attribute names differ.
The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two
relations.
To find out those students who work as instructors, it is necessary to perform the operation
Student ∩ Instructor.
CS403-MIDTERM SOLVED MCQS with references by MOAAZ(2).pdf
|
| 10 |
Which of the following is true about relational schema? |
The sequence of columns is significant
The sequence of rows is significant.
Contains only derived attributes.
Values are atomic
|
.gif)
Home
News
Colleges
Courses
Admission
Lectures
Online Test
Past Papers
Date Sheets
Results
Study Abroad
Jobs
Tutors
More
Apps
