CSCI 3600 Exam 1 Study Guide

All of the following values can be stored in a column that's defined as DECIMAL(6,2), except- A) -246 B) 0 C) 2479.95 D) 32492.05

D) 32492.05

Which of the following types of SQL statements is not a DML statement? A) INSERT B) UPDATE C) SELECT D) CREATE TABLE

D) Create Table

The SQL statements that work with the data in a database are called- A) Data Manipulation Language B) Data Manipulation Statements C) Data Modification Language D) Data Modification Statements

A) Data Modification Language

Which of the following types of statements does not modify the data in a table? A) SELECT B) INSERT C) UPDATE D) DELETE

A) Select

Which uses the least amount of storage? A) 'example' stored in a column of type VARCHAR2(20) B) 'exam' stored in a column of type VARCHAR2(20) C) 'ex' stored in a column of type VARCHAR2(20) D) they all use the same amount of storage

C) 'ex' stored in a column of type VARCHAR2(20)

Which of the following types of real numbers is considered an exact numeric type? A) DOUBLE B) FLOAT C) DECIMAL D) all of the given options

C) DECIMAL

The interface between an application program and the DBMS is usually provided by the- A) back end B) front end C) data access API D) programmer

C) Data Access API

Which of the following is not a hardware component of a client/server system? A) network B) client C) printer D) server

C) Printer

To be in the first normal form, each cell in a table must contain- A) a unique value B) a non-unique value C) a single, scalar value D) a non-redundant value

C) a single, scalar value

The ENUM data type stores values that are mutually exclusive. Which choice is not appropriate for the ENUM type? A) small, medium, large B) yes, no, maybe C) mushrooms, sausage, peppers D) cash, credit, debit

C) mushrooms, sausage, peppers

Numbers that include a decimal point are known as- A) integers B) exact numbers C) real numbers D) precise numbers

C) real numbers

To model a database on a real-world system, you typically represent each real-world entity as a- A) column B) row C) table D) cell

C) table

If two tables have a many-to-many relationship, which of the following do you typically use to relate their rows? A) a linking table B) a master table C) an index in each table D) a foreign key column in each table

A) a linking table

The DATE data type can store- A) dates only B) dates and times C) times only D) all of the given options

A) dates only

To be in the third normal form,- A) each non-key column must depend only on the primary key B) each non-key column must not depend on the primary key C) each non-key column must contain repeating values D) all of the given options

A) each non-key column must depend only on the primary key

Numbers that don't include a decimal point are known as- A) integers B)exact numbers C) real numbers D) precise numbers

A) integers

Which of the following is the default date format for MySQL? A) mm/dd/yy B) yyyy-mm-dd C) mon-dd-yyyy D) yy/dd/mm

B) yyyy-mm-dd

The processing that's done by the DBMS is typically referred to as- A) front-end processing B) back-end processing C) the file server D) the user interface

B) Back-End Processing

Which of the following statements is not true about a database that's normalized to the fifth normal form? A) It contains no multivalued dependencies. B) Fewer joins are required to retrieve data. C) Data redundancy is minimized or eliminated.

B) Fewer joins are required to retrieve data.

Which of the following statements is not true about the CHAR type? A) It uses the same amount of storage for each value. B) It includes one byte that indicates the actual length of the string. C) When used with the utf8mb4 character set, four bytes must be reserved for each character. D) It can be used to store numbers that aren't used in numeric operations.

B) It includes one byte that indicates the actual length of the string.

Which of the following statements about the primary key for a table is not true? A) Its values must be unique. B) Its values can never change. C) Its values should be short. D) It can consist of two or more columns.

B) Its values can never change.

Which of the following is not a good guideline for deciding when to create an index for a column? A) The column is a foreign key. B) The column is frequently updated. C) The column is frequently used in search conditions or joins. D) The column contains a large number of distinct values.

B) The column is frequently updated.

Which of the following recommendations won't improve the readability of your SQL statements? A) Break long clauses into multiple lines. B) Use comments to describe what each statement does. C) Start each clause on a new line. D) Indent continued lines

B) Use comments to describe what each statement does.

If two tables have a one-to-many relationship, which of the following do you typically need to add to the table on the "many" side? A) a primary key column B) a foreign key column C) an indexed column D) a linking column

B) a foreign key column

A database driver is software that lets the- A) data access model communicate with the application program B) data access model communicate with the database C) application program communicate with the data access model D) application program communicate with the database

B) data access model communicate with the database

Which of the following indicates the total number of digits that can be stored in a real number? A) size B) precision C) scale D) significance

B) precision

To apply the second normal form, you move columns that don't depend on the entire primary key to another table and establish a relationship between the two tables. This- A) reduces redundancy but makes maintenance more difficult B) reduces redundancy and makes maintenance easier C) increases redundancy but makes maintenance easier D) increases redundancy but makes the data more consistent

B) reduces redundancy and makes maintenance easier

Which of the following types of data would you not store in a binary large object (BLOB) type? A) image files B) text files C) sound files D) video files

B) text files

When you identify the data elements in a new database, you typically subdivide data elements into- A) the largest practical components B) the smallest practical components C) components that can be easily parsed each time you use them

B) the smallest practical components

Most database designers consider a database structure to be normalized if it's in which of the following normal forms? A) second B) third C) Boyce-Codd D) sixth

B) third

To enforce referential integrity for a delete operation, a MySQL database can (Choose all applied): A) return an error instead of deleting any rows B) set the foreign key values in the related rows to null C) delete the related rows in the foreign key table

Choose All

Which of the following is not true if you use a string in a numeric expression? A) If the string contains only numbers, MySQL returns those numbers. B) If the string starts with a number, MySQL returns that number and each successive number until it encounters a letter or special character. C) If the string starts with a letter or special character, MySQL returns a value of zero. D) If the string doesn't contain any numbers, an error occurs.

D) If the string doesn't contain any numbers, an error occurs.

Which of the following statements about a TIMESTAMP type is not true? A) It stores a date and time. B) MySQL automatically sets the value of a TIMESTAMP column when it inserts a row. C) MySQL automatically changes the value of a TIMESTAMP column when it updates a row. D) It requires more storage than a DATETIME type.

D) It requires more storage than a DATETIME type.

Which of the following does not violate the referential integrity of a database? A) inserting a new row into a table with a foreign key that doesn't match a primary key in the related table B) updating a foreign key with a value that doesn't match a primary key in the related table C) updating a primary key in a primary key table without also updating the foreign keys for the related rows in all related tables D) deleting a row in a foreign key table without deleting the related row in the related primary key table

D) deleting a row in a foreign key table without deleting the related row in the related primary key table

What type of constraints do you need to define to use declarative referential integrity? A) unique B) not null C) primary key D) foreign key

D) foreign key

Before you can normalize a data structure, you must do all but one of the following. Which one is it? A) identify the data elements B) identify the tables and assign columns C) identify the primary and foreign keys D) identify the indexes

D) identify the indexes

Which uses the least amount of storage? A) 'example' stored in a column of type CHAR(20) B) 'exam' stored in a column of type CHAR(20) C) 'ex' stored in a column of type CHAR(20) D) they all use the same amount of storage

D) they all use the same amount of storage