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