Chapter 3 - MISY 5300 questions and answers graded A+ 2023/2024

Chapter 3 - MISY 5300& operator - correct answer combine the contents of two text fields aggregate function - correct answer calculate on groups of records (also called built in functions). EX. can average values n a numeric field using avg sql keywords alias - correct answer the name assigned to a new computed field. can be applied to any field. Uses the AS keyword American National Standards Institute (ANSI) - correct answer An organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States. SQL is a standard language according to ANSI and ISO American Standard Code for Information Interchange (ASCII) - correct answer standardized way to represent characters in numeric form. values 0 through 31 AND operator - correct answer all the conditions must be true for a particular record to be selected AUTOINCREMENT - correct answer field whose values automatically increment by 1 as new records are added. AutoNumber - correct answer The Access data type for a field whose values automatically increment by 1 as new records are added. BETWEEN operator - correct answer An operator that allows you to specify a range of values for the criteria, including the lower number, the higher number, and all numbers in between. Boolean - correct answer data type for fields that store only Yes or No (On or Off, True or False) values. built-in-functions - correct answer A function such as SUM built into the SQL language BYTE - correct answer Microsoft Access data type used in the CREATE TABLE statement for a number field of BYTE size (0-255). calculated field - correct answer A field whose value is calculated from other fields in the database; also called a computed field CHAR - correct answer A data type for a fixed-length string field, often expressed as CHAR(n), where (n) identifies the length. compound condition - correct answer Two simple conditions (criteria) in a query that are combined with the AND or OR operators. Can also use the between operator. computed field - correct answer A field whose value is computed from other fields in the database; also called a calculated field. concatenation - correct answer The combination of two or more rows in an operation, such as a join, or the combination of two or more columns for a primary key field to uniquely identify a given row in the table; also, joining two or more strings of textual data into one piece of data.