SOC 200 FINAL
What design consideration would apply to a database that has special performance
requirements? - answerStructuring data properly on storage media.
Which database role focuses on database storage, response times, and optimization? -
answerDesigner
The _____ SQL statement does not alter any database data. - answerSELECT
Which option is found on the Schemas tab in MySQL Workbench? - answerA list of available
databases.
Which role focuses on creating software that interacts with a database? - answerProgrammer
Which concept relates to software that reads and writes data in a database? -
answerManagement system
What links a host programming language to a database system? - answerAPI
In the following ER diagram, what does 'AlbumTitle' represent? - answera.) Key
b.) Attribute
c.) Relationship
d.) entity
Attribute
When a user interacts with a database, they can use a _____ to modify data with commands. -
answerquery language
, The analysis phase of database design includes which process? - answerSpecifying requirements
that are not dependent on a specific database system.
Which type of database system is optimized for big data? - answerNoSQL
A database _____ is the implementation of database requirements in SQL with CREATE TABLE
statements. - answerschema
When using the MySQL Command-Line Client, which character ends a command? - answer;
A database management system reads and writes data in a database, and _____. -
answerensures consistency and availability
A database administrator uses which two SQL statements to view and then modify existing
customer balances with a late fee? - answerSELECT, UPDATE
A user creates a table by using a SQL statement. The data type VARCHAR(11) is part of the
statement. What does the value of (11) represent? - answerThe number of characters allowed
for the data type.
When data is produced and stored as numeric, textual, or visual information, it varies in _____. -
answerformat
When using a SQL statement to create a table, which data type is used to store a fractional
value? - answerDECIMAL
What does a user that interacts with a database use to read and write data? - answerQuery
Language
What design consideration would apply to a database that has special performance
requirements? - answerStructuring data properly on storage media.
Which database role focuses on database storage, response times, and optimization? -
answerDesigner
The _____ SQL statement does not alter any database data. - answerSELECT
Which option is found on the Schemas tab in MySQL Workbench? - answerA list of available
databases.
Which role focuses on creating software that interacts with a database? - answerProgrammer
Which concept relates to software that reads and writes data in a database? -
answerManagement system
What links a host programming language to a database system? - answerAPI
In the following ER diagram, what does 'AlbumTitle' represent? - answera.) Key
b.) Attribute
c.) Relationship
d.) entity
Attribute
When a user interacts with a database, they can use a _____ to modify data with commands. -
answerquery language
, The analysis phase of database design includes which process? - answerSpecifying requirements
that are not dependent on a specific database system.
Which type of database system is optimized for big data? - answerNoSQL
A database _____ is the implementation of database requirements in SQL with CREATE TABLE
statements. - answerschema
When using the MySQL Command-Line Client, which character ends a command? - answer;
A database management system reads and writes data in a database, and _____. -
answerensures consistency and availability
A database administrator uses which two SQL statements to view and then modify existing
customer balances with a late fee? - answerSELECT, UPDATE
A user creates a table by using a SQL statement. The data type VARCHAR(11) is part of the
statement. What does the value of (11) represent? - answerThe number of characters allowed
for the data type.
When data is produced and stored as numeric, textual, or visual information, it varies in _____. -
answerformat
When using a SQL statement to create a table, which data type is used to store a fractional
value? - answerDECIMAL
What does a user that interacts with a database use to read and write data? - answerQuery
Language
