Info
Warning
Danger

Study Resources (Statistics)

  21) Establishing IF-THEN-ELSE logical processing within an SQL statement can be accomplished by: A) using the if-then-else construct. B) using the immediate if statement. C) using the CASE keyword in a statement. D) using a subquery. 22) All of the following are guidelines for better query design EXCEPT: A) understand how.
1 Views
View Answer
  21) Extensible Business Reporting Language (XBRL) is an example of: A) a 3GL language. B) an XML-based vocabulary. C) a legacy database application. D) none of the above. 22) The XML shown in the figure below describes some data from the Pine Valley Furniture case study. A) all products with a cherry finish.  B) a.
2 Views
View Answer
  61) Hash partitioning spreads data evenly across partitions independent of any partition key value. 62) Free range partitioning is a type of horizontal partitioning in which each partition is defined by a range of values for one or more columns in the normalized table. 63) Vertical partitioning means distributing the.
2 Views
View Answer
  41) Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server, depending upon which location will give the best performance. 42) When developing an application, one must decide where it will be placed when it is developed..
2 Views
View Answer
  21) A disadvantage of partitioning is: A) simplicity. B) remote optimization. C) extra space and update time. D) shorter technology spans. 22) All of the following are horizontal partitioning methods in Oracle EXCEPT: A) key range partitioning. B) hash partitioning. C) multivalued partitioning. D) composite partitioning. 23) ________ partitioning distributes.
2 Views
View Answer
  81) Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers. 82) ________ is a rapidly developing scripting language that allows for the creation of customized tags that can be used across applications. A) Extensible Markup Language B) HTML C) SGL D) CGI 83) A(n) HTTP Schema Definition.
1 Views
View Answer
  31) 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. 32) An XML-based grammar used to describe a Web service is called: A) Web Service Description Language (WSDL)..
2 Views
View Answer
  61) Even with XML, different types of devices will require a different page. 62) Web services allow for communication between programs over the Internet. 63) UDDI stands for Underwritten Data Dictionary Inquiry. 64) Web Services Description Language is an XML-based grammar. 65) SOAP is an insignificant Web standard. 66) Lack of.
3 Views
View Answer
  31) RANK and DENSE-RANK are examples of: A) ceilings. B) door functions. C) window functions. D) moving functions. 32) All of the following are new data types added in SQL:200n EXCEPT: A) BIGINT.  B) BIT.  C) MULTISET.  D) XML.  33) ________ differs from array because it can contain duplicates. A) BIGINT B) XML C) MULTISET D) TABLE 34) The.
1 Views
View Answer
  51) A range control limits the set of permissible values that a field may assume. 52) One method to handle missing values is to substitute an exact value. 53) Sensitivity testing involves ignoring missing data unless knowing a value might significantly change results. 54) Denormalization is the process of transforming.
2 Views
View Answer
  81) Triggers have three parts: the event, the condition, and the action. 82) A function has only input parameters but can return multiple values. 83) The advantages of SQL-invoked routines are flexibility, efficiency, shareability and applicability. 84) A procedure is run by calling it by its name. 85) SQL statements.
4 Views
View Answer