- 1. Which DML command adds value or data in a table?
A) Insert
B) Update
C) Delete
- 2. Which DML command edits value or data in a table?
A) Insert
B) Update
C) Delete
- 3. In writing the DELETE syntax, which data must be filled in?
A) column name = value
B) condition
C) table name
- 4. Which DML command views value or data in a table?
A) Insert
B) Delete
C) Select
- 5. Which symbol serves as a pointer where new data will be inserted?
A) /
B) *
C) -
- 6. Ctrl command for select all.
A) Ctrl+L
B) Ctrl+E
C) Ctrl+A
- 7. Ctrl command for execute SQL.
A) Ctrl+E
B) Ctrl+F5
C) Ctrl+P
- 8. Ctrl command for save.
A) Ctrl+S
B) Ctrl+A
C) Ctrl+E
- 9. Ctrl command for open.
A) Ctrl+E
B) Ctrl+F
C) Ctrl+O
- 10. Function key for execute.
A) F1
B) F5
C) F7
- 11. One of the benefits normalization is that provides an overall
A) Security of Database
B) Consistency of Data
C) Better Database Organization
- 12. One of the benefits of normalization is that Redundant Data can be
A) Abstained
B) Reduced
C) Increased
- 13. One of the benefits of normalization is that database has better consistency of
A) Process
B) Data
C) Information
- 14. One of the benefits of normalization include providing better
A) Database Security
B) Design Flexibility
C) Data Integration
- 15. One of the benefits of normalization is that it can have a password, thus improving
A) Database Integration
B) Database Security
C) Database Accounting
- 16. This normal form requires a minimum of one candidate key,
A) BCNF
B) 1NF
C) 5NF
- 17. This normal form reduces redundancy by moving multiple rows in a table to another table.
A) 2NF
B) 3NF
C) 1NF
- 18. This normal form requires dependency to a super key.
A) 1NF
B) BCNF
C) 4NF
- 19. This normal form eliminates independent multivalued facts.
A) 4NF
B) 5NF
C) 3NF
- 20. This normal form removes all nontrivial join dependencies.
A) 4NF
B) 2NF
C) 5NF
- 21. The number of instances of an entity from a relation to another relation.
A) Orthogonality
B) Cardinality
C) Deaconality
- 22. One row is related to one row.
A) 1:1
B) 1:M
C) M:M
- 23. One row is related to two or more rows.
A) M:M
B) 1:M
C) 1:1
- 24. 2 or more rows are related by more rows.
A) M:M
B) 1:1
C) 1:M
 - 25. Real world objects with independent existence. Represented with a rectangle.
A) Relationship
B) Attributes
C) Entites
 - 26. The properties, traits, or characteristics of the entity.
A) Relationship
B) Entities
C) Attributes
 - 27. Association among two or more entities.
A) Entities
B) Relationship
C) Attributes
 - 28. This downed telephone pole denotes how many relationships?
A) Zero
B) One
C) Many
 - 29. The crow's foot denotes how many relationships?
A) Many
B) One
C) Zero
 - 30. The node denotes how many relationships?
A) Zero
B) Zero or Many
C) Zero or One
- 31. This important table is used to uniquely identify each column in the table.
A) Secondary Key
B) Primary Key
C) Tertiary Key
- 32. This table is a set of one or more columns with a special code, configuration, or table definition.
A) Primary Key
B) Foreign Key
C) Tertiary Key
- 33. A duplicate copy of data.
A) Backup
B) Restoration
C) Copy
- 34. The retrieval of data from a backup copy.
A) Removable Storage
B) Backup
C) Restoration
- 35. Different strategies in duplicating or creating another copy of your data.
A) Backup and Recovery
B) USB Backup
C) Data Recovery
- 36. If one of your files are corrupted, it's called
A) Power Interruption
B) User Errors
C) Media Failure
- 37. If someone accidentally spilled water in the main system, it's called
A) User Errors
B) Natural Disasters
C) Power Interruption
- 38. If a storm damaged your data, it's called
A) Natural Disasters
B) Power Interruption
C) Media Failure
- 39. The database administrator's job includes setting up a
A) Backup Schedule
B) Backup of Data
C) Loss Data
- 40. The database administrator's job includes data transfer to preserve
A) Data Copy
B) Data Pasting
C) Data Cutting
|