Filters
Question type

Study Flashcards

Personal DBMS products are designed ________.


A) to process large organizational and workgroup databases
B) to span dozens of different magnetic disks with hundreds of gigabytes or more of data
C) to support many users and many different database applications
D) for smaller, simpler database applications

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

SQL stands for ________.


A) Standard Query Language
B) Standard Question Language
C) Structured Query Language
D) Simplified Query Language

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

What are personal DBMS products?

Correct Answer

verifed

verified

DBMS products fall into two broad catego...

View Answer

How does one create a database and its structures?

Correct Answer

verifed

verified

Database developers use the DBMS to crea...

View Answer

A ________ is a collection of reports,forms,and queries that process a database.


A) database application
B) SQL query
C) DBMS
D) database structure

E) B) and D)
F) A) and B)

Correct Answer

verifed

verified

Enterprise DBMS products are designed for smaller,simpler database applications.

A) True
B) False

Correct Answer

verifed

verified

Each of the elements of the database application system calls on the database management system (DBMS)to process the database tables.

A) True
B) False

Correct Answer

verifed

verified

Database developers use the ________ to create relationships in the database.


A) DBMS
B) metadata
C) rows
D) columns

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

SQL Server is an open source DBMS product that is free for most applications.

A) True
B) False

Correct Answer

verifed

verified

Which of the following stands true for enterprise DBMS products?


A) Enterprise DBMS products are designed for small and simple database applications.
B) Enterprise DBMS products support many (perhaps thousands) of users and many different database applications.
C) Paradox is an example of an enterprise DBMS product.
D) Most of the enterprise DBMS products are out of business today.

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

What is a database application?

Correct Answer

verifed

verified

A database application is a collection o...

View Answer

Which of the following is the most significant personal DBMS product available in the market today?


A) MS Access
B) FoxPro
C) dBase
D) Paradox

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

Define SQL.

Correct Answer

verifed

verified

Structured Query Language (SQL)is an int...

View Answer

________ are used to read,insert,modify,and delete data.


A) Markup language codes
B) DBMS applications
C) Data entry forms
D) Application programs

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Explain enterprise DBMS products.

Correct Answer

verifed

verified

DBMS products fall into two broad catego...

View Answer

The ________ problem is unique to a multiuser database processing.


A) data integrity
B) redundancy
C) lost-update
D) scrambled report

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

Describe the usefulness of metadata.

Correct Answer

verifed

verified

A database is self-describing in that it...

View Answer

A ________ is a self-describing collection of integrated records.


A) datasheet
B) metadata
C) database
D) data record

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

Bytes are grouped into columns,which are also called ________.


A) records
B) rows
C) files
D) fields

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Which of the following is a function of the DBMS?


A) considering multiuser processing
B) mastering database application programs
C) preparing reports
D) processing the database

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

Showing 61 - 80 of 80

Related Exams

Show Answer