IS 2000 - Ch 4 Warmup

As of 2018, _____ databases are considered an emerging market. a. NoSQL b. MySQL c. T-SQL d. SQL Server e. Oracle SQL

a. NoSQL

The _____ data model is excellent for modeling entities, attributes, and relationships. a. CSS b. XML c. E-R d. M-R e. UMI

c. E-R

StudentID is an example of a(n) _____, whose value is associated with only one entity instance. a. identifier b. table c. tuple d. entity e. row

a. identifier

In simple terms, the purpose of a database is to _____. a. keep track of things b. design spreadsheets c. establish metadata d. separate spreadsheet tabs e. replace word processing

a. keep track of things

Poorly designed databases can be improved through a process of _____. a. normalization b. cognition c. entity instances d. tuples e. metadata

a. normalization

MySQL is a popular _____ database management system. a. open source b. closed source c. Cisco d. Microsoft e. Access

a. open source

Microsoft's SQL Server is an example of a(n) _____ DBMS. a. Access b. enterprise c. Oracle d. IBM e. personal

b. enterprise

Having both the accounting and MIS department listed as Department 101 is an example of a(n) _____ problem. a. relevance b. E-R diagramming c. data integrity d. XML e. completeness

c. data integrity

Lists that involve data with multiple themes (i.e., students and advisors) require a(n) _____. a. XML document b. PowerPoint presentation c. database d. spreadsheet e. Web page

c. database

When creating a database, information that helps create the tables (i.e., data types) is called _____. a. abstract data b. procedural data c. metadata d. primary key data e. foreign key data

c. metadata

Most commonly, NoSQL stands for _____. a. Normalized SQL b. Non-normalized SQL c. Numbers only SQL d. Not only SQL e. Novell SQL

d. Not only SQL

SELECT *FROM STUDENT WHERE LastName = 'McKinney' is an example of _____. a. XML b. C# c. CSS d. SQL e. DBMX

d. SQL

A database application includes _____. a. a database and metadata b. both spreadsheet and database functionality c. referential integrity d. a collection of forms, reports, queries, and application programs that use the DBMS to process a database e. a collection of XML and HTML documents to enter into the database

d. a collection of forms, reports, queries, and application programs that use the DBMS to process a database

A group of similar rows (i.e., student information) is called a _____. a. column b. field c. record d. table e. row

d. table