Have an account?
Skip to Content
Build your own quiz
Suggestions for you
20 questions
Show Answers
See Preview
- 1. Multiple Choice
In relational data model, the total number of rows can be identified as ______________________ .
Cardinality
Degree
Attribute
Entity
- 2. Multiple Choice
Identify the total number of attributes in a relational data model.
Tuple
Entity
Degree
Cardinality
- 3. Multiple Choice
Identify the candidate key.
W
X
Y
Z
- 4. Multiple Choice
An attribute whose value is calculated (derived) from other attributes. Choose the correct attributes based on the information given.
Registration Number
IC Number
Certificates
Date of Birth
- 5. Multiple Choice
If related data exists in more than one table, they can be joined by using the Primary Key link to the same key in the other table. Identify this key.
Foreign Key
Primary Key
Candidate Key
Composite Key
- 6. Multiple Choice
In relational data model, the total number of attributes can be identified as ______________________ .
Cardinality
Degree
Tuple
Entity
- 7. Multiple Choice
Choose the CORRECT symbol of SELECT in the Relational Algebra
x
- 8. Multiple Choice
Based on the figure above, identify the number of tuples that will be returned by the following relational algebra query : Type = 'Saving' (Account)
2
3
6
0
- 9. Multiple Choice
Base on the table given, identify output that will be produced when, σ Salary > 3000 ˅ City = ‘Batu Pahat’ (WORKER).
- 10. Multiple ChoiceWhat is data types?It specifies what type of data is expected inside of each column in a table (ef. number, date, string)It specifies how many tables you will create when you convert your Entity Relations Model to a Logical Data ModelIt specifies the database-nameIt counts how many attributes you have
- 11. Multiple ChoiceWhat does the data-type INT containWhole numbersDecimal numbersCharactersDate
- 12. Multiple ChoiceA row in a database.RecordFieldEntityTable
- 13. Multiple ChoiceA column in a database.FieldRecordEntityValidation
- 14. Multiple ChoiceText/String, Integer, Real/Float, Boolean and Date/Time are all examples of...Data TypesFiltersSortsValidations
- 15. Multiple ChoiceA unique identifying field.Primary KeyIntegerVerificationBoolean
- 16. Multiple ChoiceWhat language does the Relational Model use?JavaPythonSQLC++
- 17. Multiple ChoiceWhat is SQL?Structured Query LanguageSuitable Query LanguageSustainable Question LanguageSuitable Question Language
- 18. Multiple ChoiceExample of an SQL Command?REMOVESELECTBINNUMBER
- 19. Multiple ChoiceHow many records are in this database?851012
- 20. Multiple ChoiceWhat is the primary key in this database?Emp_IdLast NameGenderTitle
- Answer choicesTagsAnswer choicesTags