Question 1

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

Accepted Answer

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

Question 2

An XML stylesheet file has the extension:

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

DTD stands for:

Accepted Answer

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

Question 8

The use of a DTD in XML development is:

Accepted Answer

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

Question 9

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:

Accepted Answer

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

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:

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

_____enforces consistency between linked tables.

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

Which of the following is not an aggregate function?

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

Is SQL case-sensitive?

Accepted Answer

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

Question 19

Another name for a saved query is a:

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

An XML stylesheet file has the extension:

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

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

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

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

DTD stands for:

The use of a DTD in XML development is:

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:

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:

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

_____enforces consistency between linked tables.

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

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

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

Which of the following is not an aggregate function?

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

Is SQL case-sensitive?

Another name for a saved query is a:

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

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

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

An XML stylesheet file has the extension:

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

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

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

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

DTD stands for:

The use of a DTD in XML development is:

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:

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:

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

_____enforces consistency between linked tables.

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

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

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

Which of the following is not an aggregate function?

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

Is SQL case-sensitive?

Another name for a saved query is a:

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

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