1 week Flashcards
1.The persistent property of databases indicates
a. Data reside in volatile memory erased when user interaction completes.
b. Applications using a database never fail.
c. Data reside on stable storage as the long-term memory of an organization.
d. Data requires appropriate authorization for modification and retrieval.
c. Data reside on stable storage as the long-term memory of an organization.
2.The inter-related property of databases indicates
a. Entities exist independently without relationships to other entities.
b. Databases maintain connections or relationships among entities to store business interactions.
c. Entities exist independently except when required for applications.
d. Databases maintain connections among applications using entities.
b. Databases maintain connections or relationships among entities to store business interactions.
The shared property of databases indicates
a. Databases can have multiple users and uses (applications).
b. Each entity in a database can only have one active user.
c. Organizations forfeit access controls to databases.
d. Organizations must grant open access to databases.
a. Databases can have multiple users and uses (applications).
What is the meaning of the SQL acronym?
a. Sequel
b. Structured Quotient Lingo
c. Super Query Language
d. Structured Query Language
d. Structured Query Language
Identify important DBMS features. More than one answer is possible.
a. Non procedural access
b. Data definition
c. Transaction processing
d. Workflow definition
a. Non procedural access
b. Data definition
c. Transaction processing
Indicate the work emphasis of a database administrator. More than one answer is possible.
a. Focused on individual databases
b. Primary role for data planning
c. Requires skills and knowledge of specific DBMSs
d. Primary role for setting data standards for an organization
a. Focused on individual databases
c. Requires skills and knowledge of specific DBMSs
Indicate the work emphasis of a data administrator. More than one answer is possible.
a. Focused on individual databases
b. Primary role for data planning
c. Requires skills and knowledge of specific DBMSs
d. Primary role for setting data standards for an organization
b. Primary role for data planning
d. Primary role for setting data standards for an organization
What is an enterprise DBMS?
a. Supports small workgroups with modest performance and reliability capabilities
b. Resides in a larger system, either an application or a device with limited transaction processing, memory, processing, and storage.
c. Supports mission critical information systems with high performance for storage, transaction processing, and scalability.
d. Supports servers for website usage
c. Supports mission critical information systems with high performance for storage, transaction processing, and scalability.
What is a desktop DBMS?
a. Supports small workgroups with modest performance and reliability capabilities
b. Resides in a larger system, either an application or a device with limited transaction processing, memory, processing, and storage.
c. Supports mission critical information systems with high performance for storage, transaction processing, and scalability.
d. Supports servers for website usage
a. Supports small workgroups with modest performance and reliability capabilities
What is an embedded DBMS?
a. Supports small workgroups with modest performance and reliability capabilities
b. Resides in a larger system, either an application or a device with limited transaction processing, memory, processing, and storage.
c. Supports mission critical information systems with high performance for storage, transaction processing, and scalability.
d. Supports servers for website usage
b. Resides in a larger system, either an application or a device with limited transaction processing, memory, processing, and storage.
Languages for non-procedural database access have explicit statements for looping.
a. True
b. False
b. False
What tools do enterprise DBMSs provide for non-procedural access? More than one answer is possible.
a. the SQL SELECT statement
b. Graphical tools such as the Query Builder tool in the Oracle SQL Developer
c. Database programming languages combining a procedural language with non-procedural database access.
d. The SQL CREATE TABLE statement
a. the SQL SELECT statement
b. Graphical tools such as the Query Builder tool in the Oracle SQL Developer
c. Database programming languages combining a procedural language with non-procedural database access.
What are the benefits of non-procedural database access? More than one answer is possible.
a. Improve software productivity
b. Improve accessibility of databases to users without programming skills and training.
c. Provide security for databases
d. Provide privacy for databases
a. Improve software productivity
b. Improve accessibility of databases to users without programming skills and training.
Indicate reasons that organizations use database programming languages. More than one reason is possible.
a. Batch processing especially for big data tasks
b. Customization especially for ecommerce and automation
c. Data visualization for business analysts
d. Modularization to organize code performing database retrieval and modification
a. Batch processing especially for big data tasks
b. Customization especially for ecommerce and automation
d. Modularization to organize code performing database retrieval and modification
What statements are true about database transactions. More than one answer is possible.
a. Support daily operations of an organization
b. A database transaction consists of a collection of database operations to read and write to a database.
c. A transaction consists of a single database operation.
d. A DBMS reliably and efficiently processes each transaction as one unit of work.
a. Support daily operations of an organization
b. A database transaction consists of a collection of database operations to read and write to a database.
d. A DBMS reliably and efficiently processes each transaction as one unit of work.
