EBK STARTING OUT WITH VISUAL C#
4th Edition
ISBN: 8220106714515
Author: GADDIS
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 11, Problem 7MC
A(n) __________ is a column that contains unique values that are generated by the DBMS.
- a. generated column
- b. pseudo-primary key
- c. identity column
- d. automatic entry
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A(n) __________ is a column that contains unique values that are generated by the DBMS. a. generated column b. pseudo-primary key c. identity column d. automatic entry
Which of the following is/are the primary features of a DBMS?
(A) To provide an environment that is congenial to user
(B) To store the information
(C) To retrieve information
(D) All of the above
Which of the following option is correct about DBMS (Data Base Management System)?
Choose an answer
A Sorting of programs
B Collection of programs
C Collection of self-describing data
D Sorting of self-describing data
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...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
The following code appears in the program in Listing 10.7: Why doesnt this code really include an infinite loop...
Java: An Introduction to Problem Solving and Programming (8th Edition)
In Exercises 3 through 24, carry out the task.
Place “CHECKING ACCOUNT”in the title bar of a form.
Introduction To Programming Using Visual Basic (11th Edition)
What will be stored in the file out.txt after the following program runs? #include iostream #include fstream #i...
Starting Out with C++ from Control Structures to Objects (9th Edition)
3.12 (Date Create a class called Date that includes three pieces Of information as data
members—a month (type ...
C++ How to Program (10th Edition)
What data type do you use when you want to create a file stream object that can write data to a file?
Starting Out with C++: Early Objects (9th Edition)
What are a classs responsibilities?
Starting Out with Python (3rd Edition)
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
- Please use following table information to answer the exercises.SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4) SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4) Display the last name, hire date, and day of the week on which the employee started. Label the columnDAY. Order the results by the week starting with Monday.16. Display first name and last name of employees who were hired before 2010.17. What is the last day of the current month?arrow_forwardPlease use following table information to answer the exercises.SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4) SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4) 12. Display the last name, hire date, and day of the week on which the employee started. Label the columnDAY. Order the results by the week starting with Monday.arrow_forwardPlease use following table information to answer the exercises.SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4) SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4) Display the last name, hire date, and day of the week on which the employee started. Label the columnDAY. Order the results by the week starting with Monday.13. Find the date 30 days from now.14. Write a query that displays the employees’ last names and commission amounts. If an employee does notearn…arrow_forward
- Please use following table information to answer the exercises.SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4) SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4)Exercises1. Display the contents of the departments table.2. Display the last name of all employees who work for department 100.3. Display the first name and last name of all employees who work for department 100 and have a salary greaterthan 3500.4. Display the first name and…arrow_forwardPlease use following table information to answer the questions?SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4) SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4) Exercises:1. Display the last name and current job title of each employee, along with the department name they arecurrently working in. Label the columns "LAST NAME", "JOB TITLE", and "DEPARTMENT".2. Display the average salary for each department, along with the department name and…arrow_forwardplease send me solution of this complete question subject: DBMSarrow_forward
- Which of the following is a task performed by the driver according to the ODBC standard? Select one: a. Determines the appropriate DBMS b. Converts the data source into an SQL-compliant data structure c. Validates the format of the ODBC command received from the application d. Verifies the application to the data source e. Converts data source error codes into ODBC standard error codes Additional DBA responsibilities do not include ________. Select one: a. controlling database configuration b. requests of changes to existing systems c. maintaining appropriate documentation d. editing E-R diagrams e. problem and error reporting The recovery technique in which the database is returned to a known state and then all valid transactions are reapplied to the database is known as ________. Select one: a. rollforward b. transaction logging c. reprocessing d. checkpointing e. rollback Which of the following is the correct technique for representing a 1:N relationship in the…arrow_forwardWhich is not an advantage of a DBMS? Select all that apply. [ ] Data-program independent. [ ] Concurrent access control. [ ] SQL is a 5GL. [ ] Improved data integrity.arrow_forwardWhich of the following is populated with a Stores procedures saving the results in the database to make reporting easier select one of the following A. Views B. Temp tables, C. Derived Table or materialized view.arrow_forward
- Which of the following is false about SQL? Select one: a. SQL can update records in a database b. SQL cannot create views in a database c. SQL can create stored procedures in a database d. SQL can create new databases The attribute of an entity is referred to as _______ of a table. Select one: a. Foreign Key b. Primary Key c. Field d. Recordsarrow_forward61. The command in DBMS in which the all the records existed in the file are retrieved in specific order is classified as a. Find All command b. Find n c. Find Ordered command d. Reorganize commandarrow_forwardWhat index would you recommend, and what command would you use? SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = '21344' ORDER BY P_CODE;arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Enhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage LearningProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License