Q&A Hero

Q: Problematic data include so-called dirty data.

Q: Data warehouses are populated with data prepared by Extract, Transform, and Load (ETL) systems.

Q: A data warehouse is a database system that has data for, programs for, and personnel specialized in BI processing.

Q: Report delivery is more difficult for data mining than it is for reporting systems.

Q: Data mining uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.

Q: BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

Q: Business Intelligence (BI) reporting systems can analyze data using standard SQL.

Q: Business Intelligence (BI) reporting systems are used to filter data, sort data, group data, and make simple calculations based on the data.

Q: Business Intelligence (BI) systems support operational activities.

Q: Business Intelligence (BI) systems are information systems that help users analyze and use data.

Q: What additional permissions must be assigned before a user can work with files on the IIS Web server?

Q: What is the Microsoft Web Platform Installer, and what are the advantages and disadvantages of using it to install PHP?

Q: What are the Java JVM, JRE, SDK, and NetBeans? How do they relate?

Q: What is theNetBeans IDE?

Q: What is PHP?

Q: Which of the following is not true about PHP dynamic extension files (dll files)? A) They can be shared by many applications. B) They allow php to make application calls directly to the DBMS rather than using ODBC. C) There is no relationship between the php.ini file and the dll files. D) They enable support for PHP Data Objects (PDO).

Q: Which PHP command displays the current configuration settings on the web page ________. A) phpconfig( ) B) phpinfo( ) C) index.html D) phptest.php

Q: The delimiters for embedding PHP code in a web page are ________. A) { and } B) <php and /php> C) <?php and ?> D) {php and ?}

Q: The Java JRE is installed directly from the Java download page at ________. A) www.oracle.com B) www.jre.com C) www.jdk.com D) www.sun.com

Q: Before installing theNetBeans IDE, we have to install ________. A) the Java JRE B) Microsoft IIS server C) PHP D) the PHP plugin

Q: For a workstation running the Windows operating system, the user file system permissions Modify and Write must be granted to the Users group at the ________ folder. A) wwwroot B) inetpub C) Web D) eclipse

Q: For a workstation running the Windows operating system, the user file system permissions Modify and Write must be granted to ________ at the wwwroot folder. A) the ISUR_{WebServerName} User B) the IAPP_{WebServerName} User C) the WebUsers group D) the Users group

Q: For a workstation running the Windows operating system, the additional user file system permissions ________ must be granted to the Users group at the wwwroot folder. A) Read and Write B) Modify and Read C) Modify and Write D) Read and Execute

Q: The default Web page for the IIS Web server is ________. A) startup.html B) startup.htm C) index.htm D) iisstart.htm

Q: The IIS Web server is managed using the ________. A) Microsoft Internet Information Service (IIS) Manager B) Microsoft SQL Server Management Studio C) Microsoft Visual Studio D) Microsoft IIS Workbench

Q: For a Web server running the Linux operating system, the Web server typically used is ________. A) the IIS Web server B) the Apache Web server C) the Tomcat Web server D) the ASP.NET Web server

Q: For a Web server running the Windows operating system, the Web server typically used is ________. A) the IIS Web server B) the Apache Web server C) the Tomcat Web server D) the ASP.NET Web server

Q: Installing PHP using the Microsoft Web Platform Installer always installs the most current version of PHP.

Q: When using IIS, Microsoft recommends using the FastCGI protocol option when installing PHP.

Q: There is only one way to install PHP.

Q: A Java Virtual Machine must be installed on a computer before running the NetBeans IDE.

Q: Only the 64-bit version of the Java Runtime Environment should be installed when using a 64-bit operating system.

Q: The NetBeans IDE supports PHP directly without any plugins.

Q: The Java JRE is installed directly from the Java download page at www.oracle.com.

Q: The easiest way to install the NetBeans IDE is to install it at the same time as Java.

Q: For a workstation running the Windows operating system, the user file system permissions Modify and Write must be granted to the Users group at the wwwroot folder.

Q: For a workstation running the Windows operating system, all the necessary user file system permissions to the Web page area are already granted.

Q: For a workstation running the Windows operating system, a commonly used file system utility is Microsoft Internet Explorer.

Q: For a workstation running the Windows operating system, a commonly used Web browser is Microsoft Internet Explorer.

Q: The default Web page for the IIS Web server is index.html.

Q: The IIS Web server is managed using the Microsoft Internet Information Service (IIS) Manager.

Q: The IIS Web server is automatically installed when the Windows operating system is installed, and no additional steps are necessary to either install or activate it.

Q: Apache is the Web server typically used on computers running the Linux operating system.

Q: Apache is the Web server typically used on computers running the Windows operating system.

Q: NetBeans is a development environment that can be used for PHP program development.

Q: Describe the two ways that semantic object views can be used.

Q: Distinguish between the physical description and the semantic description of an attribute domain.

Q: Explain why semantic object attributes are called paired attributes.

Q: Explain the concept of semantic objects as being a sufficient description.

Q: Semantic objects are said to be ________. A) Semantically self-contained B) Semantically complete C) Semantically inclusive D) Both A and B are correct

Q: A version object ________. A) may be a composite object B) typically contains the archetype object in its identifier C) typically is a simple object D) produces archetype objects

Q: Which of the following statements about Subtype objects is not true? A) Subtypes can be Inclusive (an object may be more than one subtype). B) Subtypes can be Exclusive (an object may only be one of the subtypes). C) Subtypes can be Nested. D) All relations between the parent and subtype are 1:N.

Q: The relationship between a parent object and its associated subtype objects is a(n) ________. A) HAS-A relationship B) WANTS-A relationship C) NEEDS-A relationship D) IS-A relationship

Q: A parent object is also known as a(n) ________. A) supertype object B) child object C) subtype object D) multiple-value object

Q: A hybrid object is a semantic object that contains at least one ________. A) single-value group attribute that includes a multi-value semantic object attribute B) single-value group attribute that includes any semantic object attribute C) multiple-value group attribute that includes a multi-value semantic object attribute D) multiple-value group attribute that includes any semantic object attribute

Q: A compound object is a semantic object that contains at least one ________. A) single-value, group attribute B) multi-value, simple or group attribute C) object attribute D) multi-value attribute

Q: A composite object is a semantic object that contains ________. A) single-value, simple or group attributes, but no object attributes B) at least one object attribute C) at least one multi-value, simple or group attribute but no object attributes D) at least one multi-value, object attribute

Q: A simple object is a semantic object that contains only ________. A) single-value, simple or group attributes B) single-value, object attributes C) single-value, simple attributes D) multi-value, simple or group attributes

Q: A group identifier ________. A) has more than one attribute B) identifies a group of instances C) identifies a group of attributes in an object D) is the identifier for a group of semantic objects

Q: What type of attribute is composed of other attributes? A) Simple B) Group C) Compound D) Composite

Q: What type of attribute has a single element? A) Single B) Simple C) Link D) Compound

Q: Semantic objects are grouped into ________. A) composites B) entities C) objects D) classes

Q: The term semantic means ________. A) meaning B) data C) detailed D) attribute

Q: A subtype inherits all the attributes of its parent.

Q: The first attribute of a subtype object is the childID attribute.

Q: An association object relates two (or more) objects and stores data that are peculiar to that relationship.

Q: A "hybrid object" is a semantic object that relates two or more objects and stores data that are peculiar to that relationship.

Q: A "composite object" cannot contain more than one multivalued attribute.

Q: A "simple object" can contain only simple attributes.

Q: The key of an attribute is a description of an attribute's possible values.

Q: Object identifiers may or may not be unique.

Q: An object identifier is one or more attributes that the users employ to identify object instances.

Q: Group attributes are composites of other attributes.

Q: The cardinalities of an attribute operate only between the attribute and the container of the attribute.

Q: A simple attribute has only one element.

Q: A semantic object must represent something with a physical existence.

Q: Semantic objects represent distinct identities.

Q: Semantic objects represent the user's perceptions more closely than the E-R model.

Q: Whether a developer uses an E-R model or a semantic object model, the eventual database design that is created should be exactly the same.

Q: Linked lists can be used to keep records in ________. A) logical order B) physical order C) sequential order D) pseudo order