Exam 11: Building Solutions

What does the S in SQL stand for?

What is DBMS?

Compared with relational databases, which of the following is true of object-oriented databases?

____________________ is a common data type that consists of lengthy text entries.

To reduce data entry errors, well-designed forms should validate data as it is entered.

What does each byte in the ASCII coding scheme represent?

A relational database stores data in objects.

Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or on cloud storage?

Which kind of database stores data in dimensions?

Which of the following kinds of values is the one that a DBMS initially displays in a field?

DBMSs will process flagged records unless an instruction is issued to ignore them.

With a(n) ____________________, users create a computerized database; add, modify, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

It often is easier and faster to develop programs that use the database approach.

What type of database are organizations MOST LIKELY to use for payroll, accounts receivable, inventory, and invoicing?

What is the process of comparing data with a set of rules or values to determine if the data meets certain criteria?

In a database, the data ____________________ specifies the kind of data a field can contain and how the field is used.

A user of a database such as that pictured in the accompanying figure refers to a record as what?

Some report generators allow you to create a webpage, which can be interactive.

Explain data validation and the various types of validity checks.

Explain a multidimensional database, its applications, and its main advantage.