 - 1. An organized collection of data.
A) Management
B) List
C) Database
- 2. An electronic collection of numeric, values, graphs, or images.
A) MSDB
B) BSMD
C) DBMS
 - 3. This DBMS classification relates to anything about commercial performance, the number of employees, and employee positions.
A) Business Resources
B) Data Resources
C) System Resources
 - 4. The process of gathering data.
A) Acquisition
B) Storage
C) Manipulation
- 5. It stores definitions of data elements and their relationships.
A) Transaction Support
B) Recovery Services
C) Data Dictionary
- 6. Provides security systems that enforce user access.
A) Authorization Services
B) Recovery Services
C) Concurrency Control Services
- 7. No duplication of data will take place.
A) Integrity Can Be Enforced
B) Inconsistency Can Be Avoided
C) Controls Redundancy
- 8. It requires substantial amount of memory to run efficiently.
A) Form
B) Size
C) Shape
 - 9. Database is stored in a single site shared through several workstations.
A) Distributed Database
B) Heterogenous Distributed
C) Centralized Database
- 10. This database element is a property of an entity,
A) Attribute
B) Relationship
C) Entity
- 11. This SQL Language element is a component of statements and queries. (Ex: Where, From, Select...)
A) Expressions
B) Predicates
C) Clauses
- 12. This SQL Language Element produces scalar values or tables.
A) Expressions
B) Predicates
C) Clauses
- 13. This SQL element has comparison symbols (<, >, =...) to change the program flow or specify conditions.
A) Expressions
B) Predicates
C) Clauses
- 14. This SQL Element could be numeric or string values.
A) Values
B) Object Names
C) Operators
- 15. Which Operator uses the words AND, OR, NOT?
A) Boolean
B) Arithmetic
C) Comparison
- 16. Which SQL Data Definition Language performs database maintenance, such as inserting updating modifying and querying?
A) Data Definition Language (DDL)
B) Data Control Language (DCL)
C) Data Manipulation Language (DML)
- 17. This is used to identify the SQL server.
A) Server Name
B) Server Type
C) Authentication
- 18. The SQL Server Database Engine has the facility to create and manipulate databases.
A) Security
B) Databases
C) Server Objects
- 19. The SQL Server Database Engine has the facility to back up, restore, trigger, and link database servers.
A) Server Objects
B) Security
C) Replication
- 20. In tables, this is a single piece of data.
A) File
B) Record
C) Field
- 21. In Database Security, their objective prevents/detects/deters improper denial of access to services.
A) Availability
B) Confidentiality
C) Integrity
- 22. This database security mechanism verifies a user or application claiming who or what they really are.
A) Authentication
B) Data Encryption
C) Authorization
- 23. This SQL Schema role is where the user can perform all configurations and maintenance activities.
A) db_owner
B) db_backupoperator
C) db_accessadmin
- 24. This SQL Schema Role is where the user can add or remove access to the database.
A) db_backupoperator
B) db_ddladmin
C) db_securityadmin
- 25. This SQL Schema Role is where the user is prohibited to add, modify, or delete any data,
A) db_denydatawriter
B) db_denydataadmin
C) db_denydatareader
- 26. This basic DDL command allows to make a new database.
A) Create
B) Alter
C) Use
- 27. This basic DDL command allows to modify the structure of an existing database.
A) Use
B) Alter
C) Drop
- 28. Which function key is the execute key?
A) F1
B) F7
C) F5
- 29. Which Ctrl button creates a new query?
A) Ctrl+N
B) Ctrl+Alt+N
C) Ctrl+Shift+N
- 30. Which option allows you to add a column?
A) Table Designer
B) Table Properties
C) Column Properties
|