M

Question 1

a characteristic of a relation is that rows may hold identical values

Answer 1

False

Question 2

a characteristic of a relation is that rows may hold single values

Answer 2

True

Question 3

The SQL keyword MODIFY is used to change the structure, properties or constraints of a table.

Answer 3

False

Question 4

The SQL keyword CONSTRAINT is used to define one of five types of constraints.

Answer 4

True

Question 5

The Microsoft Access 2016 application generator provides the ability to create and store forms, reports, and queries.

Answer 5

True

Question 6

most Microsoft access 2016 commands and tools are available on the tabbed ribbon

Answer 6

True

Question 7

Microsoft Access uses the AutoNumber data type to create surrogate keys

Answer 7

True

Question 8

SQL commands can be embedded in an application program

Answer 8

True

Question 9

Business Intelligence (BI) systems typically store their data in data warehouses.

Answer 9

True

Question 10

SQL includes a data definition language, a data manipulation language, and SQL/Persistent stored modules.

Answer 10

True

Question 11

Table names in databases usually follow a certain style

Answer 11

False. They can follow any style desired.

Question 12

In a DB, each table stores data about a different type of thing

Answer 12

True

Question 13

With SQL server, the preferred way to create database structures is with SQL statements

Answer 13

True

Question 14

SQL statements can be submitted to SQL Server from Microsoft SQL Server Management Studio

Answer 14

True

Question 15

The SQL Server GUI program is the Enterprise Manager

Answer 15

False. Enterprise Manager is an Oracle program I believe.

Question 16

Microsoft Access 2016 DBs are stored using the file extension .accdb

Answer 16

True

Question 17

Microsoft Access is a personal DB that combines a DBMS with an application generator

Answer 17

True

Question 18

Microsoft Access 20– uses the Access 2003 .mdb file format as the default file format for database files.

Answer 18

False, regardless of version

Question 19

The SQL CREATE TABLE statement is used to name a new table and describe the table’s columns.

Answer 19

True

Question 20

Data values to be added to a table are specified by using the SQL VALUES clause.

Answer 20

True

Question 21

Microsoft SQL Server Management Studio can be used to create a new DB

Answer 21

True

Question 22

Purpose of a DB is to help keep track of things

Answer 22

True

Question 23

In a DB, each table stores data about a different type of thing

Answer 23

True

Question 24

Like a spreadsheet, a DB table has rows and columns

Answer 24

True

Question 25

The SQL keyword SELECT is used to specify the columns to be listed in the query results

Answer 25

True

Question 26

The SQL keyword WHERE is used to specify the table(s) that contain the data to be retrieved

Answer 26

False. That’s FROM

Question 27

A relation is a table that has special restrictions on it

Answer 27

False

Question 28

All relations are tables, but not all tables are relations

Answer 28

True

Question 29

Can users ever enter numbers into an autonumber field in Access?

Answer 29

No

Question 30

SQL, although very popular, has never become a national standard.

Answer 30

False

Question 31

SQL statements are ended with a colon.

Answer 31

False. Semi-colon

Question 32

IMPORTANT The WHERE clause contains the condition that specifies which columns are to be selected. IMPORTANT

Answer 32

FALSE.

Columns vs Rows
WHERE affect the rows, it does not affect the columns! Select affects te columns!

Question 33

The clause SELECT COUNT (*) results in a table with a single row and a single column.

Answer 33

True

Question 34

he CODASYL DBTG mode structured data relationships as a tree structure

Answer 34

False