New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
computer science
database processing fundamentals
Database Processing Fundamentals, Design, and Implementation 14th edition David M. Kroenke, David J. Auer - Solutions
What is the difference between an object class and an object?
Explain the role of data consumers and data providers.
What is an interface?
What is the difference between an interface and an implementation?
Explain why an implementation can be changed but an interface should not be changed.
Summarize the goals of OLE DB.
What are the purposes of the InsertCommand and DeleteCommand of a Data Adapter?
Explain the difference between a tabular data provider and a service provider. Which transforms OLE DB data into XML documents?
In the context of OLE DB, what is the difference between a rowset and a cursor?
What is ADO.NET?
What is a data provider?
What is a data reader?
How can ADO.NET be used to process a database without using DataReaders or DataSets?
What is an ADO DataSet?
How do ADO DataSets differ conceptually from databases?
List the primary structures of an ADO.NET DataSet, as described in this chapter.
How do datasets solve the problem of views with multivalue paths?
What is the chief disadvantage of ADO.NET DataSets? When is this likely to be a problem?
Why, in database processing, is it important to become an object-oriented programmer?
What is an ADO.NET Connection?
What is a Data Adapter?
What is the purpose of the SelectCommand property of a Data Adapter?
How is a data table relationship constructed in ADO.NET?
How is referential integrity defined in ADO.NET? What referential integrity actions are possible?
Explain how original, current, and proposed values differ.
How does an ADO.NET DataSet allow for trigger processing?
What is the purpose of the UpdateCommand property of a Data Adapter?
Explain the flexibility inherent in the use of the InsertCommand, UpdateCommand, and DeleteCommand properties.
What does JDBC stand for?
What are the four JDBC driver types?
Explain the purpose of Type 1 JDBC drivers.
Explain the purpose of Types 2, 3, and 4 JDBC drivers.
Define applet and servlet.
Explain how Java accomplishes portability.
List the four steps of using a JDBC driver.
What is the purpose of Java Server Pages?
What is the purpose of Tomcat?
Describe the process by which JSPs are compiled and executed. Can a user ever access an obsolete page? Why or why not?
Why are JSP programs preferable to CGI programs?
What is Hypertext Markup Language (HTML), and what function does it serve?
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?
What is PHP, and what function does it serve?
How are comments designated in PHP code?
How are comments designated in HMTL code?
What is an Integrated Development Environment (IDE), and how is it used?
What is the NeatBeans IDE?
Show a snippet of PHP code for creating a connection to a database. Explain the meaning of the code.
Show a snippet of PHP code for creating a RecordSet. Explain the meaning of the code.
Show a snippet of PHP code for displaying the contents of a RecordSet. Explain the meaning of the code.
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?
Under what circumstances does statelessness pose a problem for database processing?
In general terms, how are sessions managed by database applications when using HTTP?
What are PHP Data Objects (PDO)?
What is the significance of PDOs?
Show two snippets of PHP code that compare creating a connection to a database in standard PHP and in PDO. Discuss the similarities and differences in the code.Show two snippets of PHP code that compare creating a connection to a database in standard PHP and in PDO. Discuss the similarities and
What are BI systems?
Explain the phrase “standardized but customizable.”
What is SOAP? What did it stand for originally? What does it stand for today?
What are the problems in interpreting a tag such as in HTML?
What requirement is necessary for processing XML documents with Oracle?
Explain how SQL Server 2014 produces XML output using the FOR XML RAW clause.
In Figure 10C-66, what is the purpose of the varRowCount variable?
In Figure 10A-58, what is the purpose of the @RowCount variable?
Show an SQL statement for querying the row created in question 10B.14.
Under what circumstances can PopularShowsView be used for inserts and modifications?
Under what circumstances can PopularShows be used for inserts and modifications?
Show how to insert a row into table T1 (question 10B.12) using the sequence created in question 10B.13.
Can the SQL DELETE statement be used with the PopularShowsView view? Why or why not?
Can the SQL DELETE statement be used with the PopularShows view? Why or why not?
Show the statement necessary to create a sequence starting at 50 and incremented by 2. Name your sequence T1Seq.
Use the MySQL Workbench GUI tools to determine that PopularShows was constructed correctly. Modify this view to include PICTURE.Description and FileName. Right-click the MEDIA View object and then Refresh All before opening the view.
Run an SQL SELECT query to demonstrate that the modified PopularShowsView view was constructed correctly.
Run an SQL SELECT query to demonstrate that the view PopularShowsView was constructed correctly.
Use an SQL ALTER VIEW statement to modify the PopularShowsView to include PICTURE.PictureDescription and PICTURE.PictureFileName.
Explain the use of User account, Profiles, System privileges, Object privileges, and Roles in Oracle Database security.
Write an SQL statement to create a view named PopularShowsView that has SLIDE_SHOW.ShowName and PICTURE.PictureName for all slide shows that have a Purpose of either 'Home' or 'Pets'. Execute this statement to create the view in the MEDIA database.
Write an SQL statement to create a view named PopularShowsView that has SLIDE_SHOW.ShowName and PICTURE.PictureName for all slide shows that have a Purpose of either 'Home' or 'Pets'. Execute this statement using the Microsoft SQL Server Management Studio.
What is an Oracle Database datafile? How is it related to a tablespace?
Write an SQL statement to create a view named PopularShowsView that has SLIDE_SHOW.ShowName and PICTURE.PictureName for all slide shows that have a Purpose of either 'Home' or 'Pets'. Execute this statement to create the view in the MEDIA database.
Write SQL INSERT statements to populate the SLIDE_SHOW_PICTURE_INT table using the data shown in Figure 10A-87. Run the SQL statements to populate the SLIDE_SHOW_PICTURE_INT table.
What is an Oracle Database tablespace? What is the purpose of a tablespace? What are some standard tablespaces?
Write SQL INSERT statements to populate the SLIDE_SHOW table using the data shown in Figure 10C-102. Run the SQL statements to populate the SLIDE_SHOW table.
Write SQL INSERT statements to populate the SLIDE_SHOW table using the data shown in Figure 10A-86. Run the SQL statements to populate the SLIDE_SHOW table.
What is an Oracle Database database instance?
Write SQL INSERT statements to populate the PICTURE table using the data shown in Figure 10C-101. Run the SQL statements to populate the PICTURE table.
Write SQL INSERT statements to populate the PICTURE table using the data shown in Figure 10A-85. Run the SQL statements to populate the PICTURE table.
Name two ways of creating an Oracle Database database. Which is the easiest?
Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics as shown in Figure 10C-100. SLIDE_SHOW_PICTURE_INT is an intersection table between PICTURE and SLIDE_SHOW, so create appropriate relationships between PICTURE and SLIDE_SHOW_PICTURE_INT
Use the Microsoft SQL Server Management Studio to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics shown in Figure 10A-84.SLIDE_SHOW_PICTURE_INT is an intersection table between PICTURE and SLIDE_SHOW, so create appropriate relationships between PICTURE and
What is SQL*Plus, and what is its purpose? What is SQL Developer, and what is its purpose?
Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW using the column characteristics as shown in Figure 10C-99. Run the SQL statement to create the SLIDE_SHOW table in the MEDIA database.
Write an SQL statement to create a table named SLIDE_SHOW using the column characteristics as shown if Figure 10-A-82. Run the SQL statement to create the SLIDE_SHOW table in the MEDIA database. FIGURE 10A-82 Column Characteristics for the MEDIA Database PICTURE Table Column Name PicturelD
What is the Oracle Express XE 11.2 utility, and what is its purpose?
Write an SQL CREATE TABLE statement to create a table named PICTURE using the column characteristics as shown in Figure 10C-98. Run the SQL statement to create the PICTURE table in the MEDIA database.
Write an SQL statement to create a table named PICTURE using the column characteristics as shown if Figure 1-A-82. Run the SQL statement to create the PICTURE table in the MEDIA database.
What is the Enterprise Manager 12c Database Express, and what is its purpose? What is the difference between a Container Database (CDB) and a Pluggable Database (PDB)?
Using the MEDIA database, open a new tabbed SQL Query window, and save it as MEDIA-CH10C-RQ-Solutions.sql in the DBP-e14-Media-Database folder. Use this script record and save the SQL statements that you are asked to create in the remaining Review Questions in this section.
Showing 100 - 200
of 781
1
2
3
4
5
6
7
8
Step by Step Answers
Get 50% OFF
Claim Now
