Assignment
I. What is a data model?
i. method of storing files on a disk drive
ii. simple representation of complex real-world data structures
iii. name of system for designing software
iv. method of designing invoices for customers
II. A Relationship Database system consists of 3 parts: a client front end for sending information to a command processor, a middle tier that interprets user commands, and a management frame work for storing, organizing and securing data.
i. True
ii. False
III. What are the 3 components of a table:
i. Row, column, value
ii. Row, top, bottom
iii. Column, row, top
iv. Top, middle, end
IV. What does the column represent in a table?
i. Attribute of the table records
ii. A complete record in the table
iii. The system log from the database
iv. A list of database tables
V. What does a row in the table represent?
i. A complete data record
ii. List of system logs
iii. A list of file systems on database server
iv. The primary keys from all the tables.
VI. Which of the following is an example of data definition language (DDL)?
i. UPDATE
ii. V$SYSLOG
iii. CREATE
iv. DETAIN
VII. Which of the following is an example of data manipulation language (DML)?
i. SELECT
ii. ABORT
iii. GRANT
iv. REVOKE
VIII. A _______ key is an attribute that uniquely identifies a record in a table.
IX. A _______ key is an attribute that is a primary key in one table and is used as a reference in a second table to establish a relationship between the two tables.
X. When running a ‘SELECT' join, what is returned from the table:
i. ROW
ii. Column
iii. single attribute
iv. all tables in the database
XI. When running a ‘PROJECT' join, what is returned from the table:
i. COLUMN
ii. ROW
iii. Single Attribute
iv. a list of tables in the database
XII. What are the 3 types of relationships commonly shown on an entity relationship diagram?
i. 1 to 1
ii. 1 to Many
iii. Many to Many
iv. All the above
v. None of the above
XIII. What is an entity relationship diagram (ERD)?
i. graphical representation of all entities in a database and how the entities are related
ii. list of the log files in the database.
iii. list of all the tablespace names in a database
iv. A diagram that shows how data is written to a physical disk drive.
XIV. The definition of an attribute in a table that has no value is:
i. ZERO
ii. NULL
iii. ZILTCH
iv. NONE
XV. A ____________ attribute can either be stored on retrieve on an ad hoc basis.
XVI. Briefly describe the advantages and disadvantages of storing a derived attribute?
XVII. A database can process many types of data classifications. Which of the following is not a data classification or architecture that databases can process:
i. Structured
ii. Semi-structured
iii. undelimited
iv. Unstructured
XVIII. The process by which functional/partial dependency and transitive dependency is removed from a database table is called:
i. sharding
ii. normalization
iii. defragmentation
iv. reallocation
XIX. A type of database that is used for decision making and business intelligence is what type of database:
i. general purpose database
ii. content management database
iii. analytical database
iv. cloud database
XX. All of the following are disadvantages to database systems except which of the choices below:
i. Vendor dependence
ii. increased security
iii. increased management complexity
iv. Frequent upgrade cycles.