Q&A Hero

Q: ____ exists when different versions of the same data appear in different places.a. Data inconsistency b. Data consistency c. Better data integrationd. Improved decision making

Q: A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.a. query b. operating system c. database management systemd. application program

Q: The database structure in a DBMS is stored as a ____.a. file b. collection of files c. set of key/value pairsd. collection of queries

Q: The ____ serve(s) as the intermediary between the user and the database.a. DBMS b. metadata c. end-user datad. programming language

Q: ____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.a. Queries b. End-user data c. Metadatad. Information

Q: End-user data is ____. a. raw facts about the end-user b. raw facts of interest to the end-user c. data about data d. accurate, relevant and timely information

Q: ____ is the body of information and facts about a specific subject.a. Data b. Informationc. Knowledged. A database

Q: Accurate, relevant, and timely information is the key to ____.a. data management b. good decision making c. knowledged. understanding

Q: ____ is used to reveal the meaning of data.a. Raw facts b. Knowledge c. Formattingd. Information

Q: One advantage of a database system over previous data management approaches is that the database system is considerably less complex.

Q: One disadvantage of a database system over previous data management approaches is increased costs.

Q: A query language is a procedural language.

Q: Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

Q: Initially the files within a computer file system were similar to manual files.

Q: Historically, a manual file system was composed of a system of file folders and filing cabinets.

Q: Corporations use only structured data.

Q: The same data might be simultaneously structured and unstructured depending on the intended processing.

Q: A data warehouse can store data derived from many sources.

Q: An operational database is sometimes referred to as an enterprise database.

Q: One disadvantage of the DBMS is that it increases the risk of data security breaches.

Q: The DBMS reveals much of the database's internal complexity to the application programs and users.

Q: Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.

Q: The only way to access the data in a database is through the DBMS.

Q: Metadata present a more complete picture of the data in the database than the data itself.

Q: Data constitute the building blocks of information.

Q: Information implies familiarity, awareness, and understanding knowledge as it applies to an environment.

Q: We are now said to be entering the "knowledge age."

Q: Data processing can be as simple as organizing data to reveal patterns.

Q: Data and information are essentially the same thing.

Q: Configure GridView control for customer table so that you can update an existing record of your choice.

Q: Using DetailsView control, delete the record you added in question 92.

Q: Using DetailsView control, update a record of your choice in customer table.

Q: Using DetailsView control, insert a new record of your choice into customer table.

Q: Exposures is a specialty retailer of fine gifts, picture frames, albums, scrapbooks, as well as occasional gift ideas. Visit their Web site at www.exposureonline.com, and using the registration, billing, catalog, and shopping cart screens below, go through each of the five ER design steps.For questions 92-96, please refer to the preceding paragraph and web screens.Configure DetailsView control for customer table in exposures database so that new records can be inserted and existing records updated and deleted.

Q: Configure GridView control for flower table so that you can update an existing record of your choice.

Q: Using DetailsView control, delete the record of you inserted in question 89.

Q: Using DetailsView control, update a record of your choice in flower table.

Q: Using DetailsView control, insert a new record of your choice into flower table.

Q: Jerry, the owner of Exotic Flower's Inc., built a small greenhouse to store several types of exotic flowers that he purchases from wholesale suppliers around the world. Each exotic flower Jerry buys and resells falls into one of several flower groups that differ with respect to their storage needs, duration, time in bloom, price, etc. Each of the orders placed by customers specifies the type of exotic flower, the supplier it came from, the date of order, expected delivery date, flower condition on delivery, as well as the quantity ordered. Customer's data contain all the standard information needed to collect payment and deliver the flowers.For questions 87-91, please refer to the preceding paragraph.Configure DetailsView control for flower table in flowers database so that new records can be inserted and existing records updated and deleted.

Q: Configure GridView control for customer table so that you can update an existing record of your choice.

Q: Using DetailsView control, delete the record of you inserted in question 82.

Q: Using DetailsView control, update a record of your choice in customer table.

Q: Using DetailsView control, insert a new record of your choice into customer table.

Q: Plymouth Car Rental (PCR) started with two compact cars and has expanded its fleet of vehicles with several sedans and trucks. When a customer books a rental, his/her age has to be at least 18 for compact cars and sedans, which are rented by the day and must be returned the following morning by 11 A.M. Trucks are rented for a maximum of six hours. The owner requires a deposit on the reservation to be paid within seven days of booking. Vehicle records consist of the makes and types (Honda sedan), color, seating capacity, required deposit, rental rate and rental limit (in hours). Customer data consists of customer's names, addresses, phone numbers, and birth dates. Bookings identify the customer, vehicle, as well as the time rented and returned. There can be several payments up until the reservation date. Payments must reflect the payment status for each booking, including deposit, when the deposit was made, then each of the payments made, and when the entire payment was completed.For questions 82-86, please refer to the preceding paragraph.Configure DetailsView control for customer table in rental database so that new records can be inserted, existing records updated and deleted.

Q: Use __ SQL statement to configure the data source to delete all the fields for a particular record from employee table.

Q: Use __ SQL statement to configure the data source to edit all the fields (except ssn) for a particular record in employee table.

Q: Use __ SQL statement to configure the data source to insert a new record into employee table.

Q: For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 78-81, please refer to the preceding paragraph.Use __ SQL statement to configure the data source to select all the fields and records from employee table would.

Q: All of the table maintenance activities performed with DetailsView control can be accomplished with GridView control except __ records.

Q: Advanced SQL Generation Options allows us to automatically generate __ SQL statements based on a __ statement.

Q: The data source will have a record removed by writing an appropriate SQL statement under __ tab.

Q: When using the Edit link button to update a record, another screen is presented with __ and __ links.

Q: The data source will be altered by writing an appropriate SQL statement under _ tab.

Q: Setting AutoGenerateDeleteButton property to True will place __ link into DetailsView control.

Q: DetailsView control property AutoGenerateDeleteButton should be set to __ in order to be able to remove a record from the data source.

Q: When using the New link button to insert a new record, another screen is presented with __ and __ links.

Q: For the columns that are checked off in the process of creating an Insert statement, __ cells associated with them appear in the query grid.

Q: Because the Insert statement will add an entire new record to the table, __ of the table columns should be __ in the query grid.

Q: Query grid helps us by placing a skeleton __ into the query grid.

Q: The data source will receive an additional record by writing an appropriate SQL statement under __ tab.

Q: Setting AutoGenerateEditButton property to True will place __ link into DetailsView control.

Q: DetailsView control property AutoGenerateEditButton should be set to __ in order to be able to edit records into the data source.

Q: DetailsView control property that allows us to browse through the records of the data source is called __.

Q: _ allows us to use either graphical interface when building a query or a place to write SQL statements to accomplish the same.

Q: There are __ tabs in a custom SQL statement window, one for each of_ SQL statements.

Q: Consecutive numbers at the bottom of DetailsView control allow us to browse through the __ of associated table.

Q: Server control used to make changes to the data in a database is called _.

Q: Configuring the data source to remove all the fields for a particular record in employee table would use which SQL statement?a) Select * From employeeb) Insert Into employee (ssn, name, bdate) Values (?,?,?)c) Update employee Set name = ?, bdate = ? Where ssn = ?d) Delete From employee Where ssn = ?

Q: Configuring the data source to edit all the fields (except ssn) for a particular record from employee table would use which SQL statement? a) Select * From employee b) Insert Into employee (ssn, name, bdate) Values (?,?,?) c) Update employee Set name = ?, bdate = ? Where ssn = ? d) Delete From employee Where ssn = ?

Q: Configuring the data source to insert a new record into employee table would use which SQL statement? a) Select * From employee b) Insert Into employee (ssn, name, bdate) Values (?,?,?) c) Update employee Set name = ?, bdate = ? Where ssn = ? d) Delete From employee Where ssn = ?

Q: For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.For questions 53-56, please refer to the preceding paragraph.Configuring the data source to select all the fields from employee table would use which SQL statement?a) Select * From employeeb) Insert Into employee (ssn, name, bdate) Values (?,?,?)c) Update employee Set name = ?, bdate = ? Where ssn = ?d) Delete From employee Where ssn = ?

Q: All of the table maintenance activities performed with DetailsView control can be made with GridView control, excepta) inserting new records.b) updating existing records.c) deleting existing records.d) All the activities performed with DetailsView can be made with GridView.

Q: Optimistic concurrency does which of the following as you work on a particular record in the database? a) Checks if somebody else made a change since you retrieved the record b) Checks if you made the change before releasing the record to somebody else c) Checks if you made a change since the last time you retrieved this record d) Checks if the record was changed within last couple of days

Q: Advanced SQL Generation Option allows us to do which of the following? a) Generate Insert statements. b) Generate Update statements. c) Generate Delete statements. d) All of the above

Q: Query Builder helps us delete an existing record in a table, by placing a skeleton of which of the following SQL statements? a) Insert Into table () Values () b) Update table Set fields Where () c) Remove From table Where () d) Delete From table Where ()

Q: Setting DetailsView control AutoGenerateDeleteButton property to True will enable us to do which of the following? a) Add a new record. b) Update an existing record. c) Delete an existing record. d) Delete an existing column.

Q: When Edit link is tested in the browser, DetailsView control does which of the following? a) Displays a list of empty textboxes for all fields except the primary key b) Displays the Update link that executes the Update SQL statement c) Displays the Cancel link that allows us to stop the update operation d) All of the above

Q: After all appropriate columns are checked off, which of the following appears next to these columns in the query grid of an Update SQL statement? a) Table from which each column originates b) Set column with checked or unchecked boxes c) New Value column with question marks d) All of the above

Q: Query Builder helps us edit an existing record in a table by placing a skeleton of which of the following SQL statements? a) Insert Into table () Values () b) Update table Set fields Where () c) Edit table Into () Insert () d) Delete From table Where ()

Q: The data source will be edited by writing an appropriate SQL statement under which of the following? a) Select tab b) Insert tab c) Update tab d) Edit tab