Database design
Database Design
1. What is a data model?
A. method of storing files on a disk drive
B. simple representation of complex real-world data structures
C. name of system for designing software
D. method of designing invoices for customers
2. Which of the following are the most important elements of a security program for databases:
a. Integrity, referential index, user rights
b. Confidentiality. Integrity and Availability
c. Availability, multi-master replication, high-bandwidth
d. DBA, System Admin, and PMO
3. Suppose that you have a table with a number of product sales. The product code may repeat in the table as it is likely the same product could be sold multiple times. If you want to produce a list of the unique products that are sold, you could use which of the following keywords in the SELECT statement:
A. LIKE
B. ORDERED BY
C. DISTINCT
D. DIFFERENT
4. What does the column represent in a table?
a. Attribute of the table records
b. A complete record in the table
c. The system log from the database
d. A list of database tables
5. What does a row in the table represent?
a. A complete data record
b. List of system logs
c. A list of file systems on database server
d. The primary keys from all the tables.
6. Which of the following is an example of data definition language (DDL)?
a. UPDATE
b. V$SYSLOG
c. CREATE
d. DETAIN
7 . Which of the following is an example of data manipulation language (DML)?
A. SELECT
B. ABORT
C. GRANT
D. REVOKE
8. A _____________ key is an attribute that uniquely identifies a record in a table.
9. 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.
10. When running a ‘SELECT’ join, what is returned from the table:
A. ROW
B. Column
C. single attribute
D. all tables in the database
11. When running a ‘PROJECT’ join, what is returned from the table:
A. COLUMN
B. ROW
C. Single Attribute
D. a list of tables in the database
12. What are the 3 types of relationships commonly shown on an entity relationship diagram?
A. 1 to 1
B. 1 to Many
C. Many to Many
D. All the above
E. None of the above
13. What is an entity relationship diagram (ERD)?
A. graphical representation of all entities in a database and how the entities are related
b. list of the log files in the database.
C. list of all the tablespace names in a database
D. A diagram that shows how data is written to a physical disk drive.
14. The definition of an attribute in a table that has no value is:
A. ZERO
b. NULL
c. ZILTCH
D. NONE
15. A __________ attribute can either be stored on retrieve on an ad hoc basis.
16. Which of the following is not considered a characteristic of distributed management systems:
a. Concurrency Control
b. Business intelligence
c. Transaction management
d. query optimization
17. A database can process many types of data classifications. Which of the following is not a data classification or architecture that databases can process:
A. Structured
B. Semi-structured
C. undelimited
D. Unstructured
18. The process by which functional/partial dependency and transitive dependency is removed from a database table is called:
a. sharding
b. normalization
c. defragmentation
d. reallocation
19. A type of database that is used for decision making and business intelligence is what type of database:
a. general purpose database
b. content management database
c. analytical database
d. cloud database
20. All of the following are disadvantages to database systems except which of the choices below:
a. Vendor dependence
b. increased security
c. increased management complexity
d. Frequent upgrade cycles
21. A methodology that is made up of 5 phases that cover the creation of the database and the operation of the database is called:
a. Agile Programming
b. System Development Lifecyle (SDLC)
c. Design and Analysis
d. Capability Maturity Model
22. The following object in a database can speed up access to the data as well facilitate searching and sorting operations:
a. Shards
b. two-phase commit
c. Indexes
d. Views
23. Which of the following is not a data structure used to implement indexes:
a. Hash
b. stack
c. bitmap
d. b-tree
24. Which of the following lead to the development of distributed databases:
a. Applications as a service
b. Mobile and wireless applications
c. Big Data and Business Intelligence
D. All the above
25. Suppose that a query is created to list the Lastname, Firstname and Address of each individual in a table. If the results are needed to be returned in alphabetical order based on the lastname, which of the following would achieve the result:
a. SELECT Lastname, Fistname, address from Tbl_Persons ORDERED BY Lastname;
b. SELECT Lastname, Firstname, address from tbl_persons where Lastname = “ORDERED BY”;
C. SELECT Lastname, Firstname, address from tbl_persons;
D. SELECT count(Lastname) from tbl_persons;