isbc test 2 – Flashcards
Unlock all answers in this set
Unlock answersquestion
The purpose of a data base is to:
answer
store lists of data involving multiple themes
question
A _______ is a self-describing collection of integrated records
answer
Database
question
What best describes a byte in a database?
answer
character of data
question
In a database bytes are grouped into:
answer
columns
question
In a database columns are also called:
answer
fields
question
In a database rows are also called:
answer
records
question
In a database the collection of data for all columns is called a:
answer
record
question
In a database a group of similar rows is called a:
answer
table
question
In a database, a table, which is a group of similar rows, is also called a ________.
answer
File
question
What best describes the metadata in a database?
answer
special data that describes the structure of a database
question
In a database, a ________ is a column or group of columns that identifies a unique row in a table.
answer
Key
question
In a database, columns that are keys of a different table than the one in which they reside are known as ________ keys.
answer
foreign
question
Databases that carry their data in the form of tables and represent relationships using foreign keys are called ________ databases.f
answer
relational
question
In a database, a table is formally referred to as a ________.
answer
relation
question
Special data that describe the data contained in a database are called ________.
answer
metadata
question
A(n) ________ is a program that is used to create, process, and administer a collection of self-describing integrated records.
answer
DBMS
question
Which of the following is a DBMS product from Microsoft
answer
SQL Server
question
________ is a popular enterprise DBMS product from IBM.
answer
DB2
question
Which of the following is a function of the DBMS?
answer
processing a database by inserting or modifying data
question
The DBMS provides applications for processing operations such as ________.
answer
inserting or deleting data
question
SQL stands for ________.
answer
Structured query language
question
________ is an international standard language that is used for processing a database.
answer
SQL
question
One of the important functions of a DBMS is to provide the necessary tools for ________.
answer
administering the database
question
Which of the following is considered an administrative function of the DBMS?
answer
adding structures
question
Monitoring the performance of a database after providing solutions for improving its performance is a(n) ________ of the DBMS.
answer
administrative
question
Conducting training to ensure that users and operations personnel know and understand recovery procedures is a(n) ________ of the DBMS.
answer
administrative
question
A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
answer
database application
question
Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?
answer
forms
question
Which of the following elements of a database application presents data in a structured manner using sorting, grouping, filtering, and other operations?
answer
reports
question
Which of the following elements of a database application provides security, data consistency, and special-purpose processing?
answer
application programs
question
Traditional database application programs are written in object-oriented languages like ________.
answer
VisualBasic
question
Which of the following is true of browser-based database applications?
answer
thin client apps that don't need installation
question
Browser-based database applications differ from traditional applications in that they ________.
answer
are open to the public
question
Which of the following is a major problem posed by multi-user processing of a database
answer
lost update problem
question
Which of the following is a drawback of the relational database processing model?
answer
not a natural fit
question
Which of the following is true of the relational database processing model?
answer
represents relationships with foreign keys
question
One of the reasons for the appearance of new styles of nonrelational database processing is the need for ________.
answer
storing data types
question
Which of the following is a nonrelational data store developed by Amazon.com?
answer
Dynamo
question
________ refers to software systems that support very high transaction rates, processing relatively simple data structures, replicated on many servers in the cloud.
answer
NoSQL DBMS
question
The conversion of the existing traditional databases in organizations to NoSQL databases is ________.
answer
not needed if the current db meets needs
question
T/F: Databases are required to keep track of lists with multiple themes.
answer
True
question
T/F: A database is a self-describing collection of integrated records.
answer
True
question
T/F: Bytes, which are characters of data, are grouped into rows in a database.
answer
False
question
T/F: In a database, columns are also called records.
answer
False
question
T/F: In a database, the collection of data for all columns is called a file.
answer
False
question
T/F: In a database, a group of similar rows or records is called a table.
answer
True
question
T/F: In a database, a key is a column or group of columns that identifies a unique row in a table.
answer
True
question
T/F: Databases that carry their data in the form of tables and that represent relationships using foreign keys are called discrete databases.
answer
False
question
T/F: The format of the metadata in a database depends on the software product that is processing the database.
answer
True
question
T/F: To find out what a database contains, one can look at the metadata inside the database.
answer
True
question
T/F: Most organizations develop their own database management systems.
answer
False
question
T/F: DB2 is a popular DBMS product that is licensed from Microsoft.
answer
False
question
T/F: A DBMS is also referred to as a database.
answer
False
question
T/F: Hypertext Markup Language is an international standard language for processing a database.
answer
False
question
T/F: SQL statements can be issued directly to the DBMS by an application program.
answer
True
question
T/F: The DBMS can be used to set up a security system involving user accounts, passwords, permissions, and limits for processing the database.
answer
True
question
T/F: DBMS administrative functions include adding structures to improve the performance of database applications.
answer
True
question
T/F: The administrative functions of a DBMS include backing up database data.
answer
True
question
T/F: A database application serves as an intermediary between users and database data
answer
True
question
T/F: Queries in database applications present data in a structured manner using operations such as sorting, grouping, and filtering.
answer
False
question
T/F: Reports in database applications provide security, data consistency, and special-purpose processing.
answer
False
question
T/F: All traditional databases require the Internet to transmit traffic between a user's computer and a DBMS server computer
answer
False
question
T/F: In single-user databases, the application, the DBMS, and the database all reside on a user's computer.
answer
True
question
T/F: Traditional database application programs are written in object-oriented languages such as C++.
answer
True
question
T/F: Browser database application forms, reports, and queries are displayed and processed using html.
answer
True
question
T/F: Browser applications are thin-client applications that need not be pre-installed on the users' computers.
answer
True
question
T/F: Security requirements are more stringent for traditional applications than for browser-based ones.
answer
False
