Font size
S
M
L
XL
WorksheetsDataMan_Q2
Total questions: 74
Worksheet time: 1hrs 14mins
Name
Class
Date
1.
A ____ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.
a)
foreign
b)
surrogate
c)
candidate
d)
composite
2.
A key attribute is the extra attribute of a relation.
a)
can have NULL values.
b)
can have multiple data values.
c)
can not have NULL values
3.
A relation is in 1NF if it doesn't contain any ____________?
a)
Repeating groups
b)
Functional dependencies
c)
Null values in primary key fields
d)
Determinants
4.
A relational database consists of a collection of ___________.
a)
records
b)
keys
c)
tables
d)
fields
5.
A set of possible data values is called
a)
Tuple
b)
Attribute
c)
Domain
d)
Degree
6.
A table is in 3NF if it is in 2NF and if it has no transitive dependencies.
a)
True
b)
False
7.
Choose 3 correct statement about the diagram
a)
The reference table of judge_id is the Judge table
b)
The judge_id is the foreign key of the court table.
c)
Lawyer is identified by the lawyer_id
d)
Answer, Each client is identified by case_id
8.
Atomicity of domains of attributes is related to
a)
First Normal Form
b)
Third Normal Form
c)
Second Normal Form
d)
Fourth Normal Form
9.
Consider attributes ID, CITY, and NAME. Which one of this can be considered as a primary key?
a)
ID
b)
City
c)
None of these
d)
Name
10.
Select 3 Correct answer:
a)
Each court may have many cases.
b)
A lawyer can have many clients.
c)
A court can have many judges.
d)
Each client is served by one lawyer.
e)
Each court has only one judge.
11.
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
a)
Tuple, Attributes
b)
Tuple, Relation
c)
Relations, Attribute
d)
Attributes, Relation
12.
Data Normalization is the process of decomposing relations with entity type to produce smaller, well-structured relations.
a)
True
b)
False
13.
Data about data is
a)
Data Redundancy
b)
Data inconsistency
c)
Metadata
d)
Data Description
14.
Entities can be associated with one another in which of the following
a)
relationship
b)
attribute
c)
entities
d)
identifiers
15.
Entity is represented as
a)
double ellipse
b)
ellipse
c)
double rectangle
d)
rectangle
16.
For a weak entity type to be meaningful, it must be associated with another entity type is called Identifying type.
a)
True
b)
False
17.
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
a)
Schema
b)
Relation
c)
Set
d)
Domain
18.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
19.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
20.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
21.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
22.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
23.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
24.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
25.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
26.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
27.
For the following two ENTITIES, which is the appropriate relationship:
a)
One to One
b)
One to Many
c)
Many to Many
28.
Given the table: What is the appropriate code that will display the FirstName, LastName and Salary from the Employee
a)
π FirstName, LastName, Salary (σ Employee)
b)
σ FirstName, LastName, Salary (π Employee)
c)
π FirstName, LastName, Salary (Employee)
d)
σ (Employee) FirstName, LastName, Salary
e)
none in the options
29.
Given the table: What is the appropriate code that will display the account-number and balance from the BankAccount relation where branch-name is "Brighton"
a)
π account-number, balance (σ branch-name ="Brighton" (BankAccount))
b)
σ account-number, balance (π branch-name ="Brighton" (BankAccount))
c)
π (BankAccount) account-number, balance(σ branch-name ="Brighton" )
d)
σ account-number, balance(BankAccount) (π branch-name ="Brighton" )
30.
Given the table: What is the appropriate code that will find the sid, sname, and rating whose age is greater than 45.
a)
π sid, sname, rating (σ age > 45.0 (Sailors))
b)
π sid, rating (σ age > 45.0 (Sailors))
c)
σ sid, sname, rating (π age > 45.0 (Sailors))
d)
π sid, sname, rating (σ age < 45.0 (Sailors))
31.
Given the table: What type of data is "Downtown"
a)
Column
b)
Key
c)
Field
d)
Row
32.
How many fields that this table have?
a)
3
b)
4
c)
5
d)
2
33.
Identification of the ____ will let you know where you are in the normalization process.
a)
primary key
b)
attributes
c)
repeating groups
d)
normal form
34.
If every non-key attribute is functionally dependent on the primary key, then the relation will be in
a)
Third Normal Form
b)
Fourth Normal Form
c)
First Normal Form
d)
Second Normal Form
35.
In a database, each column is called a ___________.
a)
record
b)
data
c)
field
d)
table
36.
In a given relationship R, if an attribute A uniquely defines all other attributes, then the attribute A is a key attribute which is also known as the ….
a)
candidate
b)
primary
c)
composite
d)
determinant
37.
In order to convert the Main table to 2nd normal form we have split it into two tables Split_1 and Split_2. Split_1 and Split_2 are now in 2nd normal form:
a)
True
b)
False
38.
In the Chen's Notation, what is the symbol for attribute?
a)
Double line
b)
diamond
c)
Double rectangle
d)
elipse
39.
In the Chen's Notation, what is the symbol for relationship?
a)
rectangle
b)
ellipse
c)
diamond
d)
double rectangle
40.
In the Chen's Notation, what is the symbol for total participation?
a)
double line
b)
single line
c)
diamond
d)
double rectangle
41.
In the Chen's Notation, what is the symbol for weak entity?
a)
double line
b)
ellipse
c)
diamond
d)
double rectangle
42.
In the case of Database normalization the order of the rows and columns is immaterial;
a)
True
b)
False
43.
In the given table, what are the fields?
a)
1021, Beverages & Soft drinks, coffees, teas
b)
All of these are fields.
c)
S. No, Product Code & Description
d)
Dairy Products, Beverages & Seafood.
44.
It expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
a)
dependency
b)
connectivity
c)
cardinality
d)
relationship
45.
It is a Relational Algebra operator that combines all unique tuples from two relations.
a)
Project
b)
Intersection
c)
Union
d)
Cartesian Product
46.
It is a Relational Algebra operator that filters rows based on criteria.
a)
Union
b)
Project
c)
Intersection
d)
Select
47.
It is a Relational Algebra operator that selects specific columns in a table.
a)
Intersection
b)
Union
c)
Project
d)
Select
48.
It is a row in a table.
a)
field
b)
entity
c)
table
d)
tuple
49.
It is a type of key that uniquely identifies each record in a table.
a)
Primary Key
b)
Super Key
c)
Foreign Key
d)
Composite Key
50.
It is an organized collection of structured data.
a)
database
b)
DBMS
c)
file
d)
information
51.
It is the degree of relationship that involves between two entities
a)
unary
b)
ternary
c)
none
d)
binary
52.
It is the set of rules that define valid data.
a)
data dictionary
b)
query
c)
constraint
d)
all of these
53.
Mismatched redundant copies of data is known as data
a)
dependence
b)
isolation
c)
inconsistency
d)
redundancy
54.
Non-prime attributes cannot be transitively dependent, so the relation must have the Third Normal form.
a)
True
b)
False
55.
Property that describes the characteristics of entity is
a)
relationship
b)
entities
c)
identifiers
d)
attribute
56.
Redundancy in date may lead to its inconsistency
a)
True
b)
False
57.
Relational must belong to 1NF in the 2NF.
a)
True
b)
False
58.
Rows of a relation is called
a)
tuples
b)
a relation row
c)
an entity
d)
a data structure
59.
The ____ model views the data as part of a table or collection of tables in which all key values must be identified.
a)
relational
b)
conceptual
c)
object-oriented
d)
external
60.
The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is:
a)
Composite
b)
Derived
c)
Single valued
d)
Multi valued
61.
The following are data types, EXCEPT:
a)
char
b)
int
c)
varchar
d)
dom
62.
The following are primary key, EXCEPT:
a)
RegistrationNo
b)
StudentID
c)
SSS_No
d)
StreetNo
63.
The following are the type of relationship, EXCEPT:
a)
1:1
b)
1:M
c)
0:1
d)
M:N
64.
The table attached is an example of First Normal Form.
a)
True
b)
False
65.
This key uniquely identifies each record in an entity.
a)
Composite Key
b)
Secondary Key
c)
Primary Key
d)
Foreign Key
66.
This notation means
a)
One and Only one
b)
One or Many
c)
Many
d)
One
67.
This notation means
a)
One
b)
Zero or One
c)
Zero or Many
d)
One and Only one
68.
This notation means
a)
Zero or One
b)
Zero or Many
c)
One or Many
d)
One and Only one
69.
What does RDBMS stands for?
a)
Relational Database Management System
b)
Relational Database Basic Management System
c)
Relational Database Mass System
d)
Required Database Management Setup
70.
What language does the Relational Model use?
a)
SQL
b)
Java
c)
C++
d)
Python
71.
When a relation contains an atomic value, it is in the 2NF relation
a)
True
b)
False
72.
Which best explains the difference between logical and physical database design?
a)
Logical database design is concerned with the physical storage of data, while physical database design is concerned with the logical structure.
b)
Logical database design is used for physical implementation, while physical database design is used for conceptual structure.
c)
Logical database design focuses on the implementation details, while physical database design deals with the conceptual structure.
d)
Logical database design focuses on the conceptual structure, while physical database design deals with the implementation details.
73.
Which is true about the imporance of data integrity?
a)
Data integrity is important in database design to ensure accuracy, consistency, and reliability of data, preventing errors and maintaining data quality.
b)
Data integrity causes data errors
c)
Data integrity leads to data inconsistency
d)
Data integrity is irrelevant in database design
74.
Who is the father of DBMS?
a)
Edgar F. Codd
b)
Egay Allan Poe
c)
Egay Colt
d)
Edgar Allan Poe
Reset
