Question 1

The correct syntax of the declaration which defines the XML version:

Accepted Answer

A) B) C) D) None of the above E) a and b A) B) C) D) None of the above E) a and b

Question 2

A ______ key is a field that holds a unique value for each record.

Accepted Answer

A)  combination 
B)  foreign 
C)  primary 
D)  private 
E)  public 
A)  combination 
B)  foreign 
C)  primary 
D)  private 
E)  public

Question 3

Which of the following SQL statements is correct?

Accepted Answer

A)  FROM Table SELECT Field WHERE Record = 'X' ORDER BY Field 
B)  WHERE Record = 'X' SELECT Field FROM Table ORDER BY Field 
C)  SELECT FROM Table Field WHERE Record = 'X' ORDER BY Field 
D)  ORDER BY Field SELECT Field FROM Table WHERE Record = 'X' 
E)  None of the above is correct 
A)  FROM Table SELECT Field WHERE Record = 'X' ORDER BY Field 
B)  WHERE Record = 'X' SELECT Field FROM Table ORDER BY Field 
C)  SELECT FROM Table Field WHERE Record = 'X' ORDER BY Field 
D)  ORDER BY Field SELECT Field FROM Table WHERE Record = 'X' 
E)  None of the above is correct

Question 4

Which statement is true?

Accepted Answer

A)  All the statements are true 
B)  All XML elements must have a closing tag 
C)  All XML elements must be lower case 
D)  All XML documents must have a DTD 
E)  None of the above statements are correct 
A)  All the statements are true 
B)  All XML elements must have a closing tag 
C)  All XML elements must be lower case 
D)  All XML documents must have a DTD 
E)  None of the above statements are correct

Question 5

Which of the following is not an advantage to using a relational database?

Accepted Answer

A)  Increasing data redundancy 
B)  Improving data access and sharing by using database standards 
C)  Maintaining the integrity of the data by having security and controls to prevent errors, duplication, and unauthorized entry 
D)  Allowing configurable views of the data to match the user needs 
E)  None of the above 
A)  Increasing data redundancy 
B)  Improving data access and sharing by using database standards 
C)  Maintaining the integrity of the data by having security and controls to prevent errors, duplication, and unauthorized entry 
D)  Allowing configurable views of the data to match the user needs 
E)  None of the above

Question 6

The relational entity is connected to each original entity by a _____ relationship.

Accepted Answer

A)  many-to-one 
B)  one-to-many 
C)  many-to-many 
D)  one-to-one 
E)  none of the above 
A)  many-to-one 
B)  one-to-many 
C)  many-to-many 
D)  one-to-one 
E)  none of the above

Question 7

Which of the following SQL statements will change all the records from the table Courses that begin with ITM and change it to BTM?

Accepted Answer

A)  CHANGE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM' 
B)  CHANGE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM' 
C)  UPDATE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM' 
D)  UPDATE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM' 
E)  None of the above 
A)  CHANGE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM' 
B)  CHANGE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM' 
C)  UPDATE Course WHERE CourseCode = 'ITM' SET CourseCode = 'BTM' 
D)  UPDATE Course SET CourseCode = 'BTM' WHERE CourseCode = 'ITM' 
E)  None of the above

Question 8

A simple rule of thumb for determining foreign keys is that the primary key from the "_____" side of the relationship is used as a foreign key on the "_____" side of the relationship.

Accepted Answer

A)  many; one 
B)  one; many 
C)  many; many 
D)  one; one 
E)  none of the above 
A)  many; one 
B)  one; many 
C)  many; many 
D)  one; one 
E)  none of the above

Question 9

The _____ operator uses the wildcard character as a replacement for unknown or non-existing characters in an attempt to find matches to a group of characters.

Accepted Answer

A)  AND 
B)  OR 
C)  SELECT 
D)  LIKE 
E)  WHEN 
A)  AND 
B)  OR 
C)  SELECT 
D)  LIKE 
E)  WHEN

Question 10

The relational entity uses the _____ key of each of the tables and its own _____key.

Accepted Answer

A)  primary; primary 
B)  primary; foreign 
C)  foreign; primary 
D)  foreign; foreign 
E)  none of the above 
A)  primary; primary 
B)  primary; foreign 
C)  foreign; primary 
D)  foreign; foreign 
E)  none of the above

Question 11

The _____ operation creates a single table from two (or more) tables.

Accepted Answer

A)  CONNECT 
B)  COMBINE 
C)  JOIN 
D)  ADJOIN 
E)  MIX 
A)  CONNECT 
B)  COMBINE 
C)  JOIN 
D)  ADJOIN 
E)  MIX

Question 12

To designate a character or text constant as such, you must use which punctuation marks?

Accepted Answer

A)  Exclamation point 
B)  Question mark 
C)  Quotation marks 
D)  Ampersand 
E)  None of the above 
A)  Exclamation point 
B)  Question mark 
C)  Quotation marks 
D)  Ampersand 
E)  None of the above

Question 13

DTD includes the specifications about the markup that can be used within the document, the specifications consists of all EXCEPT

Accepted Answer

A)  the browser name 
B)  the size of element name 
C)  entity declarations 
D)  element declarations 
E)  none of the above 
A)  the browser name 
B)  the size of element name 
C)  entity declarations 
D)  element declarations 
E)  none of the above

Question 14

In order to use an aggregate function, you must use a _____ field.

Accepted Answer

A)  numeric 
B)  alpha-numeric 
C)  string 
D)  dummy 
E)  none of the above 
A)  numeric 
B)  alpha-numeric 
C)  string 
D)  dummy 
E)  none of the above

Question 15

A(n) ____ database is structured with tables that are related to one another so data can be stored and retrieved efficiently.

Accepted Answer

A)  relational 
B)  rational 
C)  informational 
D)  accessible 
E)  none of the above 
A)  relational 
B)  rational 
C)  informational 
D)  accessible 
E)  none of the above

The correct syntax of the declaration which defines the XML version:

A ______ key is a field that holds a unique value for each record.

Which of the following SQL statements is correct?

Which statement is true?

Which of the following is not an advantage to using a relational database?

The relational entity is connected to each original entity by a _____ relationship.

Which of the following SQL statements will change all the records from the table Courses that begin with ITM and change it to BTM?

A simple rule of thumb for determining foreign keys is that the primary key from the "_" side of the relationship is used as a foreign key on the "_" side of the relationship.

The _____ operator uses the wildcard character as a replacement for unknown or non-existing characters in an attempt to find matches to a group of characters.

The relational entity uses the _ key of each of the tables and its own _key.

The _____ operation creates a single table from two (or more) tables.

To designate a character or text constant as such, you must use which punctuation marks?

DTD includes the specifications about the markup that can be used within the document, the specifications consists of all EXCEPT

In order to use an aggregate function, you must use a _____ field.

A(n) ____ database is structured with tables that are related to one another so data can be stored and retrieved efficiently.

IT for Business and Business Professionals

Technology Essentials

Managing and Using Data

Enterprise Systems

Creating Business Value

Managing Is Projects and Creating Is Solutions

E-Commerce

Web 2.0, Social Media, and Online Trends

Tech Guide A: The Details of IT Hardware and Software

Tech Guide B: The Details of Networking

Filters

Exam 11: Tech Guide C: The Details of SQL, Logical Modelling, and XML

The correct syntax of the declaration which defines the XML version:

A ______ key is a field that holds a unique value for each record.

Which of the following SQL statements is correct?

Which statement is true?

Which of the following is not an advantage to using a relational database?

The relational entity is connected to each original entity by a _____ relationship.

Which of the following SQL statements will change all the records from the table Courses that begin with ITM and change it to BTM?

A simple rule of thumb for determining foreign keys is that the primary key from the "_____" side of the relationship is used as a foreign key on the "_____" side of the relationship.

The _____ operator uses the wildcard character as a replacement for unknown or non-existing characters in an attempt to find matches to a group of characters.

The relational entity uses the _____ key of each of the tables and its own _____key.

The _____ operation creates a single table from two (or more) tables.

To designate a character or text constant as such, you must use which punctuation marks?

DTD includes the specifications about the markup that can be used within the document, the specifications consists of all EXCEPT

In order to use an aggregate function, you must use a _____ field.

A(n) ____ database is structured with tables that are related to one another so data can be stored and retrieved efficiently.

IT for Business and Business Professionals

Technology Essentials

Managing and Using Data

Enterprise Systems

Creating Business Value

Managing Is Projects and Creating Is Solutions

E-Commerce

Web 2.0, Social Media, and Online Trends

Tech Guide A: The Details of IT Hardware and Software

Tech Guide B: The Details of Networking

Filters

A simple rule of thumb for determining foreign keys is that the primary key from the "_" side of the relationship is used as a foreign key on the "_" side of the relationship.

The relational entity uses the _ key of each of the tables and its own _key.