Question 1

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

Accepted Answer

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 . 
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 2

A database table is technically called a relation .

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Relationships are part of the metadata of a database .

Accepted Answer

A) True 
 B)False

Question 5

The logical database is the permanent repository of the data .

Accepted Answer

A) True 
 B)False

Question 6

Queries are used to create views .

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

The answer of The ________ rule states that you should...

Question 8

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

Accepted Answer

The answer of The attributes of an entity in a...

Question 9

Logical tables are created from a(n)

Accepted Answer

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

Question 10

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

Accepted Answer

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 
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 11

XML must be written using a

Accepted Answer

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

Question 12

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

Accepted Answer

The answer of A(n) ________ is a database command that...

Question 13

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 .

Accepted Answer

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

Question 14

The physical database is designed by database ________ .

Accepted Answer

The answer of The physical database is designed by database...

Question 15

Relationships are specified by the user of a database .

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The answer of The ________, or view of the database...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following statements is NOT true?

Accepted Answer

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 . 
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 19

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

Accepted Answer

A) True 
 B)False

Question 20

Rules for writing XML include

Accepted Answer

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 
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

Exam 15: Introduction to Database Concepts

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

A database table is technically called a relation .

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

Relationships are part of the metadata of a database .

The logical database is the permanent repository of the data .

Queries are used to create views .

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

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

Logical tables are created from a(n)

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

XML must be written using a

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

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 .

The physical database is designed by database ________ .

Relationships are specified by the user of a database .

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

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

Which of the following statements is NOT true?

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

Rules for writing XML include

Defining Information Technology

Exploring the Human-Computer Interface

The Basics of Networking

A Hypertext Markup Language Primer

Locating Information on the World Wide Web

An Introduction to Debugging

Representing Information Digitally

Representing Multimedia Digitally

Principles of Computer Operations

Algorithmic Thinking

Social Implications of IT

Privacy and Digital Security

The Basics of Spreadsheets

Advanced Spreadsheets for Planning

A Case Study in Database Organization

Fundamental Concepts Expressed in Javascript

A Javascript Program

Programming Functions

Iteration Principles

A Case Study in Algorithmic Problem Solving

Limits to Computation

A Fluency Summary

Filters

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 .