Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
What is a stored procedure, and how is it used? Describe why the data environment is complicated. Name the three major components of a Web database application.
As explained in this chapter, what are the two major functions of a Web server? Explain the difference between two-tier and three-tier architecture.
What is Apache, and what function does it serve? What are AMP, LAMP, and WAMP? Explain the relationship among ODBC, OLE DB, and ADO.
What role does the driver manager serve? What role does the DBMS driver serve? What is a single-tier driver? What is a multiple-tier driver?
Explain the differences between the three types of ODBC data sources. Which ODBC data source type is recommended for Web servers?
What are HTML document tags, and how are they used? What is the World Wide Web Consortium (W3C)? Why is index.html a significant file name?
How are comments designated in HTML code? What is an Integrated Development Environment (IDE), and how is it used?
What is the Eclipse PDT Project? Show a snippet of PHP code for creating a recordset. Explain the meaning of the code.
Create an appropriate ODBC data source for your database. Code a Web page using PHP to display the data in PROPERTY.
Create a user named GG-User with the password GG-User+password. Assign this user to database roles so that the user can read, insert, delete, and modify data.
Prepare a database in your DBMS named MDC, and use the MDC SQL scripts for your DBMS to create and populate the database tables.
Create a Web page for Heather Sweeney Designs to display the data in the SEMINAR_CUSTOMER table for the SEMINAR with SeminarID = 3.
Create a Web page for Heather Sweeney Designs to display the EmailAddress, LastName, FirstName, and Phone of customers in the CUSTOMER table.
In general terms, explain why XML is important for database processing. What is the purpose of the FOR XML expression in an SQL statement?
What are the problems in interpreting tags such as ... in HTML? What does XML stand for? How does XML differ from HTML? Explain why XML is extensible.
Show a snippet of PHP code for disconnecting from the database. Explain the meaning of the code. With respect to HTTP, what does stateless mean?
How do BI systems differ from transaction processing systems? Name and describe the two main categories of BI systems.
What problems in operational data create the need to clean data before loading the data into a data warehouse?
Explain the difference between a data warehouse and a data mart. What is the enterprise data warehouse (EDW) architecture?
Describe the differences between operational databases and dimensional databases. What is a fact table? What type of data are stored in fact tables?
What is a slowly changing dimension? Why is the time dimension important in a dimensional model? What is a conformed dimension?
What does OLAP stand for? What is the distinguishing characteristic of OLAP reports? Define measure, dimension, and cube.
Explain what must be done when fully replicating a database but allowing only one computer to process updates.
What organizations should consider using a distributed database? Explain the meaning of the term object persistence.
What is an object-relational database? What is Big Data? What is the relationship between 1 MB of storage and 1EB of storage?