EBK STARTING OUT WITH VISUAL C#
4th Edition
ISBN: 9780134400433
Author: GADDIS
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 11, Problem 9MC
A __________ connects to a data source and can retrieve and update data from a table in a data source.
- a. source connection
- b. dataset
- c. binding source
- d. table adapter
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A __________ connects to a data source and can retrieve and update data from a table in a data source.a. source connectionb. datasetc. binding sourced. table adapter
Which of the following are data table requirements?
a. Structure of the data table needs to be established with values and parameters
b. Enter input values to be used in the analysis
c. Input value results will be stored in rows and colums
d. None of the Above
e.All of the above
The __________ describes the contents of a dataset, and its name appears in the Solution Explorer ending with the .xsd file extension. a. schema definition file b. data markup file c. table description file d. DBMS protocol file
Chapter 11 Solutions
EBK STARTING OUT WITH VISUAL C#
Ch. 11.1 - Prob. 11.1CPCh. 11.1 - Why do most businesses use a DBMS to store their...Ch. 11.1 - When developing a C# application that uses a DBMS...Ch. 11.2 - Prob. 11.4CPCh. 11.2 - Prob. 11.5CPCh. 11.2 - What is the purpose of a primary key?Ch. 11.2 - Prob. 11.7CPCh. 11.2 - If a particular column is not allowed to be null,...Ch. 11.3 - List each of the .NET components that allow an...Ch. 11.3 - Prob. 11.10CP
Ch. 11.3 - What component is used to connect interface...Ch. 11.4 - Prob. 11.12CPCh. 11.4 - List the components that are automatically created...Ch. 11.4 - Prob. 11.14CPCh. 11.4 - What kind of information is displayed in the Data...Ch. 11.5 - How can you create a form that shows the columns...Ch. 11.5 - Prob. 11.17CPCh. 11.5 - Prob. 11.18CPCh. 11.6 - Prob. 11.19CPCh. 11.6 - When you create a Details view, what determines...Ch. 11.6 - Prob. 11.21CPCh. 11.6 - Prob. 11.22CPCh. 11.7 - In SQL, what is the purpose of the Select...Ch. 11.7 - What are the instructions for the DBMS to carry...Ch. 11.7 - How are the relational operators used in SQL...Ch. 11.7 - Prob. 11.26CPCh. 11.7 - Prob. 11.27CPCh. 11.7 - Prob. 11.28CPCh. 11.7 - Prob. 11.29CPCh. 11.7 - In an SQL statement, with what symbol does a query...Ch. 11 - Prob. 1MCCh. 11 - Prob. 2MCCh. 11 - A __________ holds a collection of related data...Ch. 11 - A __________ is a complete set of information...Ch. 11 - A(n) __________ holds an individual piece of...Ch. 11 - A __________ is a unique column value that can be...Ch. 11 - A(n) __________ is a column that contains unique...Ch. 11 - A __________ is a source of data with which the...Ch. 11 - A __________ connects to a data source and can...Ch. 11 - Prob. 10MCCh. 11 - A __________ is a component that can connect user...Ch. 11 - Prob. 12MCCh. 11 - A __________ can display an entire database table...Ch. 11 - A __________ is a set of individual controls that...Ch. 11 - Prob. 15MCCh. 11 - Prob. 16MCCh. 11 - Prob. 17MCCh. 11 - Prob. 18MCCh. 11 - __________, which stands for __________, is a...Ch. 11 - __________ are instructions for the DBMS to carry...Ch. 11 - In SQL, you use the __________ to retrieve the...Ch. 11 - A(n) __________ is an SQL statement that is stored...Ch. 11 - The __________ describes the contents of a...Ch. 11 - Prob. 1TFCh. 11 - The DBMS works directly with the data and sends...Ch. 11 - The data that is stored in a database is organized...Ch. 11 - Each column in a table must have a name.Ch. 11 - When you create a database table, the data types...Ch. 11 - When working with the data in a database table,...Ch. 11 - If a column in a database table contains no data,...Ch. 11 - An application works directly with a database,...Ch. 11 - Rather than showing multiple rows at once, a...Ch. 11 - Prob. 10TFCh. 11 - String comparisons in SQL are case sensitive.Ch. 11 - Prob. 1SACh. 11 - Briefly describe the layered nature of an...Ch. 11 - What is the data that is stored in a row of a...Ch. 11 - Are the data types used when creating a database...Ch. 11 - How do you create a primary key for a table with...Ch. 11 - Prob. 6SACh. 11 - Instead of working with the database directly,...Ch. 11 - What control can be used to display an entire...Ch. 11 - Prob. 9SACh. 11 - In SQL, what statement do you use to retrieve...Ch. 11 - Prob. 11SACh. 11 - Prob. 1AWCh. 11 - Write a Select statement that returns all the...Ch. 11 - Write a Select statement that returns only the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - Write a Select statement that returns all the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - Write a Select statement that returns the...Ch. 11 - Personnel Database Use Visual Studio to create a...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A __________ can display an entire database table in a scrollable grid on an application’s form. a. scrollable data control b. Table control c. SmartGrid control d. DataGridView controlarrow_forwardWhile using EnCase, you need to examine the raw data. Which view would you look at to view raw data? Details view Text view Hex view Open viewarrow_forwardwhat is DataGridView control ?arrow_forward
- What is the advantage of selecting the "Only Create Connection" option when importing data? a) Data is added to the data model so you can change the data as needed b) Data is added to the data model and cannot be changes in Excel c) Data is added to a table in a workbook d) It makes it much easier to clean the data by just changing it is Excel, allowing you to bypassw making changes in the source data.arrow_forwardMa3. Assume we have added new data to a dataset and would like to make sure our previously created PivotTables and PivotCharts are updated to reflect the newly added data. You can also assume that the cell range used within the PivotTable and PivotCha would capture this newly added data. Which of the following statements is TRUE? A. To update the analysis after new data is added, the Format button in the Home tab must be clicked. B. To update the analysis after new data is added, the Refresh All button in the Data tab must be clicked. C. To update the analysis after new data is added, the Data Analysis button in the Data tab must be clicked. D.The newly added data will automatically be updated within the previously created PivotTables and PivotCharts.arrow_forwardWEEK 9 ASSIGNMENT#5 This assignment contains two parts, you must complete Part I before you can start Part II. Part I: Using the star schema you created in Week 8, populate each table with a minimum of four rows of sample data. Once you have completed all of your inserts, copy and paste the script into a Word document. Part II: Using your populated star schema, create DML select statements for the following requirements. If you can’t answer all five questions with your existing schema, you may need to alter your schema and then repopulate it with new values. Return the total price of material by supplier. Return the avg price of material by supplier. Return the total price of material by supplier and month. Return the total price of material by job having a total price greater than $100. Return the total price of material by supplier where the amount is greater than 10. NOTE: ATTACHED IS THE STAR SCHEMA CREATED IN WEEK 8.arrow_forward
- Which view is used to filter and look at the data in a table, without changing the structure of the file? A.Report B.Data C.Dashboard D.Modelarrow_forward136. Which statement is true regarding external tables? a. The default REJECT LIMIT for external tables is UNLIMITED b. The data and metadata for an external table are stored outside the database c. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table d. The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external tablearrow_forwardYou are working with an Access data base that has two tables you joined for a particular query. The tables and contents are: Auto table contains vin (text and primary key), make (text), model (text), color (text), mileage (number) Rental table contains customer# (number and part of primary key), date (date and part of primary key), vin code (text and part of primary key) Assuming you joined the table correctly, which of the following correctly limits the records displayed to those where the mileage is greater than 50000? Select one: a. mileage<50000 b. mileage>50000 c. mileage>#50000# d. mileage>"50000"arrow_forward
- Using data as shown above, you need to : 1)Create January to March data each from different worksheet. 2)Calculate UTHM Trading First Quarter Summary from January to March data. 3)Create a pie chart for each sales percentage and profit percentage. 4)Create a line chart for overall UTHM Trading Quarter Summary 5)Hide January to March data. 6)Protect workbook for STRUCTURE ONLY using your 6 digit matric number as password. 7)Print screen all the step above and save. 8)Insert (name, matric number, section) on top (left side) of every worksheet. 9)Please rename and save your work as (matricnumber_LabSheet 5_2).arrow_forwardMicrosoft Access Database Help. Part 1: Create Table Your task is to create 3 tables i.e. (Student Detail, Course Details and Payment Details) Create the following Data Dictionary for the Table: Student Details  Create the following Data Dictionary for the Table: Course Details  Create the following Data Dictionary for the Table: Payment Details  Fill in the description for all the field names Part 2: Format Tables: Student Details Under the field properties change the format in way so that Student ID appear as; S2018164701, S2018164702, S2018164703,………., S2018164710 (Note: Do not enter student’s id manually it should be automatically generated provided you have used the correct format, use lecture notes as a point of reference) (Hint: See the pattern of the ID number only the last two digits are changing) Part 3: Input Mask & Validation Rule Create an appropriate Input Mask, Validation Rule and Validation Text for the selected field names for Tables: Student Details Contacts…arrow_forward5. Web services serve their data to a browser. True False 6. When MVC is applied to a Web service only, the Controller MVC component is present. True False 7. One of the responsibilities of the Controller in MVC is to Select proper Models for Views True Falsearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY