Questions and Answers of Database Processing Fundamentals

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
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
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
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
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
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
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
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
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.
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
What is the Oracle Database Configuration Assistant (DBCA), and what is its purpose?
In the MySQL Workbench folder structure in your Documents folder, create a folder named DBP-e14-Media-Database in the Schemas folder. Use this folder to save and store *.sql scripts containing the
What is the Oracle Universal Installer (OUI), and what is its purpose?
Create a database named MEDIA in MySQL 5.6. Use the default settings for file sizes, names, and locations (the actual database name in MySQL will appear in lowercase letters only).

Showing 100 - 200 of 777