database management chapter 1(A+ Guaranteed
Answers)
What role does the Web browser play in a Web database application? correct answers Web user
interface
Microsoft SQL Server is an example of a _______ correct answers database management system
Microsoft Access is a personal database system, and a personal database system is characterized
by ________. correct answers the DBMS product taking the role of the DBMS and the database
application generator
Today almost every commercial database is based on _______ correct answers the relational
model
A relational database stores data in the form of __ correct answers tables
SQL stands for ________ correct answers Structured Query Language
Regarding Big Data, what does the term NoSQL really mean? correct answers Non-Relational
Database
Which of the following is not a basic component of a database system? correct answers ERD
A relational database is ____ correct answers a self-describing collection of related tables
The component of a database that makes it self-describing is the _ correct answers metadata
Which of the following would not be an example of database metadata? correct answers Queries
against records in the database tables
The creation of a database and its tables is a function of which component of the database
system? correct answers DBMS
The statement
SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of ________. correct answers SQL
Which of the following is a function of the database application in a database system? correct
answers Create and transmit queries
, Microsoft Access 2013 database files are stored using the file extension correct answers accdb.
The default file format for Microsoft Access 2016 database files is the ___ correct answers
Access 2007 format
Which of the following problems associated with storing data in a list is avoided by storing data
in a relational database? correct answers All of the above
A database may be used to help people with all of the following except __ correct answers debug
existing program code
Which of the following is a function of the DBMS in a database system? correct answers
Perform backup and recover
The Microsoft Access application generator is not responsible for __ correct answers creating
tables
Which of the following is not a function of the database application in a database system? correct
answers Control concurrency
The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a
________. correct answers surrogate key
Although users use database systems, they are not considered part of a database system. correct
answers false
A relational database can be defined as a self-describing collection of related tables. correct
answers true
Metadata is the user data stored in the database. correct answers false
Most organizations create and use their own database management system (DBMS) products.
correct answers false
The DBMS is used to create the database itself. correct answers true
A relational database stores data in the form of lists. correct answers false
SQL stands for Structural Question Language. correct answers false
Relational database tables are commonly combined, queried, and processed using Structured
Query Language (SQL). correct answers true
There is no reason for serious database developers to learn many aspects of database processing
technology because DBMS products like Microsoft Access hide these aspects. correct answers
false
Answers)
What role does the Web browser play in a Web database application? correct answers Web user
interface
Microsoft SQL Server is an example of a _______ correct answers database management system
Microsoft Access is a personal database system, and a personal database system is characterized
by ________. correct answers the DBMS product taking the role of the DBMS and the database
application generator
Today almost every commercial database is based on _______ correct answers the relational
model
A relational database stores data in the form of __ correct answers tables
SQL stands for ________ correct answers Structured Query Language
Regarding Big Data, what does the term NoSQL really mean? correct answers Non-Relational
Database
Which of the following is not a basic component of a database system? correct answers ERD
A relational database is ____ correct answers a self-describing collection of related tables
The component of a database that makes it self-describing is the _ correct answers metadata
Which of the following would not be an example of database metadata? correct answers Queries
against records in the database tables
The creation of a database and its tables is a function of which component of the database
system? correct answers DBMS
The statement
SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of ________. correct answers SQL
Which of the following is a function of the database application in a database system? correct
answers Create and transmit queries
, Microsoft Access 2013 database files are stored using the file extension correct answers accdb.
The default file format for Microsoft Access 2016 database files is the ___ correct answers
Access 2007 format
Which of the following problems associated with storing data in a list is avoided by storing data
in a relational database? correct answers All of the above
A database may be used to help people with all of the following except __ correct answers debug
existing program code
Which of the following is a function of the DBMS in a database system? correct answers
Perform backup and recover
The Microsoft Access application generator is not responsible for __ correct answers creating
tables
Which of the following is not a function of the database application in a database system? correct
answers Control concurrency
The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a
________. correct answers surrogate key
Although users use database systems, they are not considered part of a database system. correct
answers false
A relational database can be defined as a self-describing collection of related tables. correct
answers true
Metadata is the user data stored in the database. correct answers false
Most organizations create and use their own database management system (DBMS) products.
correct answers false
The DBMS is used to create the database itself. correct answers true
A relational database stores data in the form of lists. correct answers false
SQL stands for Structural Question Language. correct answers false
Relational database tables are commonly combined, queried, and processed using Structured
Query Language (SQL). correct answers true
There is no reason for serious database developers to learn many aspects of database processing
technology because DBMS products like Microsoft Access hide these aspects. correct answers
false
