Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/30
Score 0
Data is the result of processed information. This statement is not (True)
30
FALSE, True
TRUE
FALSE, False
FALSE, DBMS 2
Q 2/30
Score 0
During the processing of the data, (Information) can be passed back to fine tune the type of data that is collected and how it is collected.
30
TRUE
FALSE, Data
FALSE, Feedback
FALSE, Process
30 questions
Q.
Data is the result of processed information. This statement is not (True)
1
30 sec
Q.
During the processing of the data, (Information) can be passed back to fine tune the type of data that is collected and how it is collected.
2
30 sec
Q.
A type of DBMS that stores data in table format is (Object-oriented) DBMS.
3
30 sec
Q.
A (information) is the repository of data.
4
30 sec
Q.
A DBMS does not offer security and protects your data from disasters. This statement is not (False).
5
30 sec
Q.
The (Data) model is formal representaion of entities that includes their properties, relationships and operations to be performed on them.
6
30 sec
Q.
An Entity-relationship diagram building block that means the properties of an object is (Field).
7
30 sec
Q.
In ERD, A Student-id is considered as an (Entity) that can have a value like 20-0001, 20-0002, 20-0003, etc.
8
30 sec
Q.
A type of relationship in RDBMS which one or more entity set is connected to exactly one entity set is (Many-to-many)
9
30 sec
Q.
A building block of relationship which signifies the relationship if it is many and/or one is (crows foot notation).
10
30 sec
Q.
In converting or mapping ERD to a table, the (entity) becomes the field names in a table.
11
30 sec
Q.
In a relation, the collection of data in a tuple is a (row).
12
30 sec
Q.
In a relation, the (degree) can also be called as field name or column name.
13
30 sec
Q.
In a relation, the (cardinality) is the number of tuples.
14
30 sec
Q.
In a relation, the other term for a row is (cardinality).
15
30 sec
Q.
A relation is a mathematical term for a table, while (domain) is an unordered collection of distint elements and collection of items of same type.
16
30 sec
Q.
In a relation, the relation (schema) specifies the name of a relation, name and type of each of the columns with its attributes.
17
30 sec
Q.
A relation (schema) is the view of a relation which the user can input or see the collection of data and not the name and type of each of the columns with its attributes.
18
30 sec
Q.
In relation, a (set) is the set of all possible values for a specific attribute.
19
30 sec
Q.
A (foreign) key can only be put in a relation once and set the column unique but it is optional.
20
30 sec
Q.
A relational model constraint that says that no attribute participating in the primary key of a relation is allowed to accept null values is a (Null) constraint.
21
30 sec
Q.
The (semantic integrity) constraint defines relationships between tables and ensures that these relationships remain valid.
22
30 sec
Q.
A (semantic integrity) constraint refers to the correctness of the meaning of the data.
23
30 sec
Q.
A (domain) constraint enforce domain integrity by limiting the values that are accepted by a column.
24
30 sec
Q.
In database normalization, (2NF) says that, all fields can be determined only by the key in the table and no other column.
25
30 sec
Q.
In database normalization, entries in a column are same type is rule in 2NF. This statement is not (TRUE)
26
30 sec
Q.
In database normalization, Boyce Codd normal form is the extension of 2NF that says all fields can be determined only by the key in the table and no other column. This statement is (TRUE).
27
30 sec
Q.
In planning a query for more than one table, locating the attributes in the relations of the database is the 2nd step. This statement is not (False)
28
30 sec
Q.
(Determine) is a step in designing a multi-table query which you need to set exactly your goal or what you want to know in the database.
29
30 sec
Q.
The (foreign) key is a unique value that identifies each row. This is the entity integrity constraint.