database management chapter 1(A+ Guaranteed Answers)

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