Question 1

Queries are used to create views .

Accepted Answer

A) True 
 B)False

Question 2

Relationships are part of the metadata of a database .

Accepted Answer

A) True 
 B)False

Question 3

The logical database is the permanent repository of the data .

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Relationships are specified by the user of a database .

Accepted Answer

A) True 
 B)False

Question 6

XML must be written using a

Accepted Answer

A)   web browser
B)   word processor
C)   spreadsheet program
D)   text editorE) C) and D)
F) A) and D)

Question 7

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 .E) C) and D)
F) None of the above

Question 8

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 instancesE) All of the above
F) C) and D)

Question 9

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 10

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 11

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 theseE) B) and C)
F) A) and D)

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 .E) A) and B)
F) None of the above

Question 15

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 16

The physical database is designed by database ________ .

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

A database table is technically called a relation .

Accepted Answer

A) True 
 B)False

Question 19

Logical tables are created from a(n)

Accepted Answer

A)   query
B)   view
C)   relationship
D)   keyE) None of the above
F) A) and D)

Question 20

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, logicalE) C) and D)
F) None of the above

Exam 15: Introduction to Database Concepts

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Relationships are specified by the user of a database .

Correct AnswerverifiedShow Answer

The logical database is the permanent repository of the data .

Correct AnswerverifiedShow Answer

XML must be written using a

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The physical database is designed by database ________ .

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Rules for writing XML include

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following statements is NOT true?

Correct AnswerverifiedShow Answer

Queries are used to create views .

Correct AnswerverifiedShow Answer

Logical tables are created from a(n)

Correct AnswerverifiedShow Answer

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 .

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Relationships are part of the metadata of a database .

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A database table is technically called a relation .

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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 .

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified