Deck 15: Introduction to Database Concepts

Question 1

Inconsistency is the main reason to avoid redundancy of information in a database .

Answer 1

True

Question 2

Relationships connect rows of one table with rows of another table .

Answer 2

True

Question 3

Relationships are part of the metadata of a database .

Answer 3

True

Question 4

Relationships are specified by the user of a database .

Question 5

The logical database is the permanent repository of the data .

Question 6

The logical database shows the user the view of the information he or she needs and wants .

Question 7

Queries are used to create views .

Question 8

A logical table can be created with information from no more than two physical tables .

Question 9

To successfully use a database, a user must be able to write SQL code .

Question 10

In relational databases, an attribute can be thought of as a column of a table, where the attribute names are the column headings and attribute values are the entries .

Question 11

A root element is the tag that encloses all of the content of an XML file .

Question 12

XML is intuitive because it is a self-describing language .

Question 13

Every relational database can be described by XML and, similarly, anything described by XML is a relational database .

Question 14

A table is defined with a specific set of attributes and, among the instances of any table, is the "empty instance . "

Question 15

An XML file is an alternative notation for a database schema .

Question 16

A database table may not contain multiple identical rows . Each row must be unique .

Question 17

A database table is technically called a relation .

Question 18

The rules for producing XML encodings of information produce hierarchical descriptions that can be thought of as trees .

Question 19

The key field for a database of all students on a campus is probably the

A) student's ID number
B) student's date of birth
C) student's address
D) student's last name

Question 20

What operation combines two tables based on matching fields?

A) Bind
B) Combine
C) Join
D) Unite

Question 21

What operation takes rows from one table to create a new table?

A) Select
B) Unite
C) Join
D) Union

Question 22

The Select operation on tables is often combined with the ________ operation to trim tables .

A) Select
B) Project
C) Join
D) Union

Question 23

Assume that you use the Product operation on table A (5 attributes) x table B (3 attributes) . The resulting supertable will have

A) 15 attributes
B) 8 attributes
C) 2 attributes
D) 10 attributes

Question 24

Logical tables are created from a(n)

A) query
B) view
C) relationship
D) key

Question 25

Relationships in a database schema show how

A) data types of all attributes within each table relate to each other
B) fields are related to one another in a table
C) information in a table is related to information in another table
D) queries are related to each other

Question 26

Rules for writing XML include

A) element names must begin with a special symbol
B) a required first line that identifies an XML file
C) tags and attributes are not case sensitive
D) All of these

Question 27

An attribute or a set of attributes that could potentially be chosen as the table's key is a

A) secondary key
B) primary key
C) candidate key
D) provisional key

Question 28

XML must be written using a

A) web browser
B) word processor
C) spreadsheet program
D) text editor

Question 29

XML tags cannot contain

A) numbers
B) uppercase letters
C) lowercase letters
D) spaces

Question 30

Which of the following statements is NOT true?

A) The rows of a database table do not have to be different; there can be two identical rows .
B) A given table instance becomes a different instance if a row is added or removed .
C) Columns (as a whole) and rows (as a whole) may be interchanged .
D) Even when the data for an attribute value is unknown, it is still a characteristic of that row .

Question 31

The design of a(n) ________ database is guided by technical considerations, while the design of a(n) ________ database is guided by personal considerations of the users .

A) logical, relative
B) logical, physical
C) physical, XML-based
D) physical, logical

Question 32

The database scheme (or schema)

A) specifies, for each attribute, its data type and whether or not it is the primary key
B) contains a list of attributes, one per row
C) succinctly describes a database table
D) All of these

Question 33

Select all that apply . Which is(are) TRUE about a row in a table?

A) A row is often called a field .
B) A row is often called a record .
C) A row is an entity instance .
D) A technical term for a row is a tuple .

Question 34

Select all that apply . Which of the following statements is(are) TRUE?

A) A logical database is the permanent repository of the database .
B) A logical database is created fresh each time it is needed .
C) A logical database is another term for a physical database .
D) A logical database is created from existing information .

Question 35

Select all that apply . The encoding rules of XML include which of the following?

A) Identification Rule: label data with tags consistently
B) Affinity Rule: enclose all data that refer to the same thing in a pair of tags
C) Naming Rule: all tag names must begin with a number
D) Collection Rule: group related instances

Question 36

Select all that apply . Which of the following statements is(are) TRUE about database tables?

A) The columns of the database table are entities .
B) The rows of the database table are entities .
C) A database table contains a set of things with common attributes .
D) The columns of the database table contain attribute names .

Question 37

The database ________ is a collection of table definitions that gives the name of the table, lists the attributes and their data types, and identifies the primary key .

Question 38

The ________ operation builds a new table from the columns of an existing table .

Question 39

A(n) ________ is a correspondence between two tables of a database .

Question 40

The physical database is designed by database ________ .

Question 41

The ________, or view of the database that users see, is created on demand from existing information .

Question 42

The ________ operation combines two tables .

Question 43

A technique called Query By Example (QBE) is available in the Microsoft ________ system, whereby the user fills in a template and the software generates the SQL code .

Question 44

The operations that transform a physical database into a logical one are ________ .

Question 45

The ________ operation is used to remove rows from one table that are also listed in a second table .

Question 46

The attributes of an entity in a database should satisfy the ________ rule in XML design .

Question 47

The ________ defines the form of the information that can be stored in a field .

Question 48

Database ________ allow us to ask questions of a database in a way that lets the software find the answer for us .

Question 49

A(n) ________ is a database command that defines a table expressed using the five fundamental database operations .

Question 50

The ________ rule states that you should label data with tags consistently .