Practice Quizzes - missed/unsure

When an XML document is shredded, each element is: A) thrown away. B) split up. C) stored in a relational table. D) added to other XML documents.

Stored in a relational table

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server. A) SQL program B) select module C) select procedure D) stored procedure

Stored procedure

What result set is returned from the following query? Select Customer_Name, telephone from customers where city in ('Boston','New York','Denver'); A) The Customer_Name and telephone of all customers B) The Customer_Name and telephone of all customers living in either Boston, New York or Denver C) The Customer_Name and telephone of all customers living in Boston and New York and Denver D) The Customer_Name of all customers living in Boston, New York or Denver the Customer_Name and telephone of all customers living in either Boston, New York or Denver

The Customer_Name and telephone of all customers living in either Boston, New York or Denver

What result set will the following query return? Select Item_No, description from item where weight > 100 and weight < 200; A) The Item_No and description for all items weighing less than 100 B) The Item_No for all items weighing between 101 and 199 C) The Item_No and description for all items weighing between 101 and 199 D) The Item_No for all items weighing more than 200

The Item_No and description for all items weighing between 101 and 199

What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V; A) The average of all products in Product_V B) The average Standard_Price of all products in Product_V C) The average price of all products D) The mode of all prices the average Standard_Price of all products in Product_v

The average Standard_Price of all products in Product_V

What will result from the following SQL Select statement? Select min(Product_Description) from Product_V; A) The minimum value of Product_Description will be displayed. B) An error message will be generated. C) The first product description alphabetically in Product_V will be shown. D) SELECT @ will be displayed.

The first product description alphabetically in Product_V will be shown.

A technical specification for creating a distributed registry of Web services and businesses that are open to communicating through Web services is called

UDDI

A technical specification for creating a distributed registry of Web services and businesses that are open to communicating through Web services is called: A) HTML. B) B2B. C) UDDI. D) XML.

UDDI

All of the following are concerns about developing a Web services approach EXCEPT: A) transaction speed. B) user acceptability. C) security. D) reliability

User acceptability

An XML-based grammar used to describe a Web service is called: A) Web Service Description Language (WSDL). B) WIDL. C) WISL. D) Business-to-Business (B2B).

Web Service Description Language (WSDL).

The promise of Web services is the development of a standardized communication system using:

XML

The promise of Web services is the development of a standardized communication system using: A) HTML. B) XST. C) XML. D) XPath.

XML

________ facilitates the ability of applications to query relational data along with associated structured data. A) XPath B) XQuery C) XSLT D) SOAP

XPath

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents. A) HTML B) XSLT C) SGI D) WSL

XSLT

Service-oriented architectures (SOA) are: A) a set of tiers designed to serve each other. B) a collection of services that communicate with each other in some manner. C) architecture designed for the military. D) none of the above.

a collection of services that communicate with each other in some manner.

The benefits of a standardized relational language include: a) application longevity b)reduced training costs c)cross-system communication d)all of the above

all of the above

The MERGE command: A) allows one to combine the INSERT and UPDATE operations. B) allows one to combine the INSERT and DELETE operations. C) joins 2 tables together. D) none of the above.

allows one to combine the INSERT and UPDATE operations.

Web services: A) are a set of services available to all on the Web. B) are a set of emerging standards for protocols for automatic communication between software over the Web. C) are a set of standards based upon HTML. D) none of the above.

are a set of emerging standards for protocols for automatic communication between software over the Web

In order for two queries to be UNION-compatible, they must: A) both have the same number of lines in their SQL statements. B) both output compatible data types for each column and return the same number of rows. C) both return at least one row. D) all of the above.

both output compatible data types for each column and return the same number of rows.

A join operation: A) brings together data from two different fields. B) causes two tables with a common domain to be combined into a single table or view. C) causes two disparate tables to be combined into a single table or view. D) is used to combine indexing operations.

causes two tables with a common domain to be combined into a single table or view.

Explicit commands to manage transactions are needed when: A) a transaction consists of just one SQL command. B) multiple SQL commands must be run as part of a transaction. C) autocommit is set to off. D) none of the above

multiple SQL commands must be run as part of a transaction.

An application programming interface that enables an application program to process RDBMS databases meets the: A) object linking and embedding standard. B) open database connectivity standard. C) multi-platform connectivity standard. D) open source standard.

open database connectivity standard.

A(n) ____ is a field of data used to locate a related field or rercord

pointer

A Web server: A) is used only to host Web pages. B) processes client requests and returns HTML pages to the client. C) always contains a database. D) is considered to be part of the firewall. B

processes client requests and returns HTML pages to the client.

What will be returned when the following SQL query is executed? Select driver_no, count(*) as num_deliveries from deliveries group by driver_no having count(*) > 2; A) A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries B) A listing of all drivers C) A listing of the number of deliveries greater than 2 D) A listing of all drivers who made more than 2 deliveries

A listing of all drivers who made more than 2 deliveries as well as a count of the number of deliveries

What will be returned when the following SQL statement is executed? Select driver_no,count(*) as num_deliveries from deliveries group by driver_no; A) A listing of all drivers, sorted by driver number B) A listing of each driver as well as the number of deliveries that he or she has made C) A count of all of the deliveries made by all drivers D) An error message a listing of each driver as well as the number of deliveries that he or she has made

A listing of each driver as well as the number of deliveries that he or she has made

What will be returned when the following SQL statement is executed? Select driver_no, count(*) as num_deliveries from deliveries where state = 'MA' group by driver_no; A) A listing of all drivers who made deliveries to state = 'MA', sorted by driver number B) A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state C) A count of all of the deliveries made to state = 'MA' by all drivers D) An error message will be generated

A listing of each driver who made deliveries to state = 'MA' as well as the number of deliveries that each driver has made to that state

What results would the following SQL statement produce? select owner, table_name from dba_tables where table_name = 'CUSTOMER'; A) A listing of all customers in the customer table B) A listing of the owner of the customer table C) A listing of the owner of the customer table as well as customers D) An error message B

A listing of the owner of the customer table

A view may not be updated directly if it contains: A) the DISTINCT keyword. B) derived columns and expressions in the SELECT clause. C) uses the GROUP BY or HAVING clause. D) all of the above.

All of the above

What does the following SQL statement do? alter Table Customer_T Add (Type Varchar(2));

Alters the customer_t table, and adds a field called "type"

The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers. A) memory B) files C) application logic components D) query logic components

Application logic components

A ________ is a temporary table used in the FROM clause of an SQL query. A) correlated subquery B) derived table C) view table D) none of the above

Derived table

All of the following are newer XML schema languages EXCEPT: A) Document Type Declarations (DTDs). B) XML Schema Definition (XSD). C) RELAX NG. D) Document Structure Description (DSD).

Document Type Declarations (DTDs)

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a(n): A) file server. B) file processor. C) database server. D) fat client.

Fat client

FLWOR is an acronym for: A) flowers. B) For, LET, Where OrderBy, Return. C) For, Locate, Work, Order, Results. D) none of the above.

For, Let, Where OrderBy, Return

Which of the following can produce scalar and vector aggregates?

Group by

Select count (product_description) from product_t;

How many products have product descriptions in the product table ?

Which of the following is true about three-tier architectures? A) Less scalable than two-tier B) Increased risk C) More technological flexibility D) All of the above

More technological flexibility

Which of the following is an advantage of stored procedures? A) Data integrity improves when fewer applications access the procedure. B) The layers get cleaner. C) Stored procedures result in fatter clients. D) Performance improves for compiled SQL statements.

Performance improves for compiled SQL statements