1) Database system environment consist of a few elements, including hardware, software, data, procedures, and ___________. a) cloud services b) people c) rules d) process 2) The DIKW Model consist of Data, ______________, Knowledge, Wisdom a) Information b) Input c) Insight d) Idea 3) _____________ is important to keep data secure and protect it from unauthorized access or theft. a) Data visualization b) Data storage c) Data collection d) Data analysis 4) Categories of organizational structure consist of traditional structure, team structure, project structure, and ___________________. a) digital structure b) functional structure c) virtual structure d) task structure 5) ____________ is data about data, through which the end-user data is integrated and managed. a) Raw data b) Metadata c) Unprocessed data d) Data type 6) All the following statements are TRUE about the advantages of Database Management System (DBMS), EXCEPT; a) Enables data to be shared. b) Provides an integrated view of data. c) Provides efficient data management. d) Enhance security and reduce productivity. 7) Enterprise database has the ability to _____________ . a) support one user at a time. b) support a small number of users. c) support many users across many departments. d) support internal users only. 8) ___________________is a character or group of characters that has a specific meaning and it is used to define and store data. For example : students_name. a) Record b) Metadata c) File d) Field 9) All the following statements are TRUE about impacts of uncontrolled data redundancy, EXCEPT; a) Poor data security b) Data consistency c) Data anomalies d) Data integrity problems 10) Data dictionary is used to ________________________. a) enforce user security and data privacy b) store definitions of data elements and their relationships c) enable recovery of the database after a failure d) accept end-user requests via multiple, different network environments 11) Rearrange these database conceptual design steps into correct order; a) 2, 4, 3, 1 b) 4, 1, 3, 2 c) 1, 3, 2, 4 d) 4, 3, 2, 1 12) __________________ can be defined as a characteristic or group of characteristics of an entity. a) Data b) Relationship c) Attribute d) Constraint 13) All of the followings are sources of business rules, EXCEPT; a) Written documentations b) Company managers c) End-users d) Business competitors 14) __________ is an attribute that can be subdivided to yield additional attributes. For example : Customers_Name.  a) Composite attribute b) Composite key/identifier c) Simple attribute d) Optional attribute 15) ____________________ expresses the minimum and maximum number of entity occurrences associated with one occurrence of related entity. a) Relationship b) Cardinality c) Connectivity d) Attributes 16) Entity Relational Diagram can be depicted as the example in the figure. What model / notation is used in the figure? a) Chen Model / Notation b) Crow's Foot Model / Notation c) DIKW Model / Notation d) Dependency Diagram Model / Notation 17) ____________ is evaluating and correcting table structures to minimize data redundancies a) Data storage b) Data analysis c) Normalization d) Data visualization 18) All the following statements are TRUE about characteristics of a relational table, EXCEPT; a) All values in a field must conform to the same data type. b) Each intersection of a row and column represents a single data value. c) Each field represents an attribute, and has a distinct name. d) Each record represents multiple entity occurrences within the entity set. 19) All the followings SQL statements are CORRECT to demonstrate the function of create, read, update and delete (CRUD), EXCEPT; a) SELECT * FROM Customer b) INSERT INTO Customer (cust_id, cust_name) VALUES (1, sarah) c) DELETE FROM Customer WHERE cust_id ='1' d) UPDATE Customer SET cust_name!='zahrah' 20) Cloud computing services can be defined as ______________. a) Computing model that enables access to a shared pool of configurable computer resources.  b) Mechanisms through which application programs connect and communicate with data repositories. c) Connection interface that is provided by the database vendor and is unique to that vendor. d) database middleware developed with the goal of adding object-oriented functionality.

Database Management Exercises

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?