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

Question 1

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

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

Answer 1

relational

Question 2

To query a database, it is common practice to use which language?

A) Java
B) C+
C) XML
D) SQL
E) None of the above

Answer 2

SQL

Question 3

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

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

Answer 3

primary

Question 4

A table is known more formally as a(n):

A) entity
B) record
C) relationship
D) field
E) file

Question 5

The _____ keyword designates which fields to display as a result of the query.

A) FROM
B) SELECT
C) WHERE
D) AND
E) OR

Question 6

The ______ keyword designates which tables to search when querying a database.

A) FROM
B) SELECT
C) WHERE
D) AND
E) OR

Question 7

The ______ keyword specifies the search criteria, or query condition to use in finding records.

A) FROM
B) SELECT
C) WHERE
D) AND
E) OR

Question 8

Is SQL case-sensitive?

A) Yes
B) No
C) For keywords only
D) Sometimes
E) None of the above

Question 9

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

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

Question 10

Which of the following SQL statements 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 11

Which comparison operators below is not used in conjunction with the WHERE keyword?

A) greater than (>)
B) less than (<)
C) greater than or equal to (>=)
D) added to (+)
E) not equal to (<>)

Question 12

It is also possible to combine conditions in a query by using the AND or OR operators, known as _____ operators.

A) comparison
B) compound
C) arithmetic
D) logical
E) aggregate

Question 13

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.

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

Question 14

To insert a new record for a book with an item code of KOB, a retail price of $12.95, and an item cost of $7.95 into the Product table of a database, the SQL statement is:

A) INSERT INTO Product Values('KOB', 'Book', 12.95, 7.95)
B) INSERT INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
C) ADD INTO Product Values('KOB', 'Book', 12.95, 7.95)
D) ADD INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
E) None of the above

Question 15

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

Which of the following SQL statements will delete all the records from the table Students that have the last name "Sample"?

A) REMOVE FROM Courses WHERE LastName = 'Sample'
B) REMOVE WHERE LastName = 'Sample' FROM Courses
C) DELETE FROM Courses WHERE LastName = 'Sample'
D) DELETE WHERE LastName = 'Sample' FROM Courses
E) None of the above

Question 17

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

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

Question 18

The SQL operation used to calculate certain values in the table, such as COUNT are called _____ functions

A) comparison
B) compound
C) arithmetic
D) logical
E) aggregate

Question 19

Which of the following is not an aggregate function?

A) AVG
B) CNT
C) MIN
D) MAX
E) SUM

Question 20

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

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 21

The first step in logical modelling is to create a(n):

A) DRM
B) RDM
C) ERD
D) DRD
E) DFD

Question 22

Businesses then build a(n) _____ that adds the attributes and helps to organize them to creating the database.

A) DRM
B) RDM
C) ERD
D) DRD
E) DFD

Question 23

It is not possible to create a primary key-foreign key relationship with a many-to-many relationship. As a result, you need to draw a new relational:

A) diagram
B) table
C) record
D) entity
E) database

Question 24

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

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

Question 25

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.

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

Question 26

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

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

Question 27

_____enforces consistency between linked tables.

A) Referential locking
B) Table locking
C) Table integrity
D) Referential integrity
E) None of the above

Question 28

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

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

Question 29

Another name for a saved query is a:

A) result
B) report
C) total
D) view

Question 30

An XML stylesheet file has the extension:

A) XSL
B) XSD
C) XMD
D) XTML
E) None of the above

Question 31

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

A) <xml version="1.0" />
B) <?xml version="1.0"?>
C) <?xml version="1.0" />
D) None of the above
E) a and b

Question 32

Which statement is true?

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 33

DTD stands for:

A) Direct Type Definition
B) Document Type Definition
C) Do The Dance
D) Dynamic Type Definition
E) Dynamic Type Document

Question 34

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

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

Question 35

The use of a DTD in XML development is:

A) required when validating XML documents
B) no longer necessary after the XML editor has been customized
C) used to direct conversion using an XSLT processor
D) a good guide to populating a templates to be filled in when generating an XML document automatically
E) none of the above