Just need answers in the A-B-C-D format

QUESTION 1 A is a question about the data structured in a way that the DBMS can recognize and process. a. product b.query C. relationship O d. tuple QUESTION 2 A in a record is the result of a calculation using data from the rest of the record. a grouping field b.computed field C. composite field d. foreign key field prevents users from creating orphan records. QUESTION 3 A database that enforces a. primary key creation b. data redundancy c. data security d. referential integrity QUESTION 4 An) can store information about multiple types of entities and the relationships among the entities. a. relational database b. attribute c. flat file d. spreadsheet QUESTION 5 is a set of rules, calculations, and assumptions used to solve a problem. An) O a. algorithm O b. integrity constraint O c. attribute O d. form QUESTION 6 According to the Bureau of Labor Statistics, what is the job growth outlook for database administrators? O a. No growth is expected. O b. about average O c. faster than average O d. slower than average QUESTION 7 Based on the following notation, which relational algebra command would list all information from the table concerning the customer with numeric Customer Num 260? Customer CustomerNum. CustomerName, Street, City, State, PostalCode) O a. SELECT Customer 260 RESULTS Answer O b. SELECT Customer WHERE CustomerNum=260 GIVING Answer O c. SELECT Customer GIVING Answer WHERE Customer Num=260 O d. SELECT Customer WHERE Customer Num=260 RESULTS Answer Based on the following table, which relational algebra command creates a new table named CustState containing the fields Customer Num and State? Customer (Customer Num. CustomerName, Street, City, State, PostalCode) a. SELECT Customer OVER (CustomerNum, State) GIVING CustState b. PROJECT Customer OVER (Customer Num. State) GIVING CustState C. JOIN Customer WITH (Customer Num, State) GIVING CustState d. MAKE-TABLE CustState FROM Customer WITH (CustomerNum. State) QUESTION 9 During which phase does a database developer create the entities, attributes, and relationships between the tables of data? a. database selection b. data security c.database integrity O d. database design QUESTION 10 For a one-to-many relationship in the Access Relationships window, how can you tell which table is the many" table? O a. The "manytable always appears below the "one" table. b. The many" table always appears to the left of the "one" table. c. An infinity symbol identifies the "many" table. Od. The one symbol identifies the "many" table. QUESTION 11 How are aggregate functions different from other types of functions? a. Aggregate functions do not work with date values. b. Aggregate functions make calculations on groups of records. c. Aggregate functions return yes no or true false values. d. Aggregate functions work only with numeric data. QUESTION 12 How are entities represented in a relational database? a. Each entity is stored as a table. b. Each entity is stored as an attribute. c. Each entity is stored as a column. d. Each entity is stored as a row. QUESTION 13 If you are creating a computed field that adds 10 percent to the UnitPrice field, how do you enter the UnitPrice field name in the expression? a. [UnitPrice] b. (UnitPrice) c. Unit Price O d. "UnitPrice" QUESTION 14 If you are sorting records by more than one field, which field is the first field that is evaluated for sorting purposes? a. maximum sort key b. secondary sort key c. primary sort key d. minor sort key QUESTION 15 criteria, each criterion must be true for a record to be selected. If you use O a. AND b. OR c. aggregate d. BOTH QUESTION 16 If you use an aggregate function in a query to determine the average values in a Bonus field, what default field name does Access use for the column with the calculations? O a. AvgOfBonus O b. BonusAvg O c. Average Bonus O d. Bonus QUESTION 17 If you want to select records containing the text Consulting in the ProjectType field, how does Access save the criterion in the query grid of Query Design View? O a. "Consulting" O b. [Consulting] O c #Consulting O d. (Consulting) QUESTION 18 In Access Query Design View, how do you add the Total row to the query design grid? O a. Click the Grouping button on the Query Tools Design tab. O b. Drag the Total field to the query design grid. Oc Click the Group by arrow in the Criteria row, and then click Total. O d. Click the Totals button on the Query Tools Design tab. QUESTION 19 In Access Query Design View, which of the following expressions calculates the number of days between today's date and a field named DueDate? O a. Date() - [DueDate] O b. Today - [DueDate] O c. DayO-[DueDate] O d. Date - DueDate QUESTION 20 query permanently removes all the records from the selected table(s) that satisfy the criteria entered in the query. In Access a (n) O a. delete O b. update O c. make-table O d. parameter QUESTION 21 In Access, if you want a query to list the ProductID. Category, and Description field values and sort the records by description within each category, how should you arrange the fields from left to right in the query design grid? O a. ProductID, Category. Description O b. Description. Category, ProductID O c. ProductID. Description. Category Od. Description, ProductID, Category QUESTION 22 query. In Access, if you want to be able to enter different criteria each time you run a query, create a(n) O a. update b. aggregate O c. run-time O d. parameter QUESTION 23 In Access, what uniquely identifies a row in a table? O a. column b. primary key O c. field O d. attribute QUESTION 24 In a large business, who mines a database for information, trends, and insights? a. data security expert b. data entry manager c. data analyst d. database administrator QUESTION 25 In an Access query, how can you list records in A-Z order by last name? a. Remove the checkmark from the Show box in the LastName field. O b. Set a descending sort order in the LastName field. c. Group the LastName field. d. Set an ascending sort order on the LastName field. QUESTION 26 In an organization, who is usually responsible for improving databases to provide efficient and effective access to their information? O a. data-entry clerks O b. business owner O c database administrator (DBA) d. database supporter (DBS) QUESTION 27 In general, what should be in place before you select fields from more than one table in Access Query Design View? O a. The tables should be related in a proper one-to-many relationships. O b. The tables should be merged into one table. c. The join line between the tables should be deleted. Od. The tables should not contain fields with the same field name. QUESTION 28 In relational algebra, what command is used to identify certain columns? a. DELETE b. PROJECT C. PROGRAM d. SELECT QUESTION 29 specified criteria? In relational algebra, which command retrieves rows from a table based a. CREATE b. JOIN C. UNION d. SELECT QUESTION 30 In the Access QBE, where do you specify criteria for a query? O a. in the Navigation Pane O b. in the upper pane of Query Design View O c. in the Criteria row of the query design grid d. in Datasheet view of the query QUESTION 31 In the Pitt Fitness database, how can you determine the number of classes offered on Tuesday? O a. In the Classes table, count the occurrences of Tuesday in the Day column. b. In the Classes table, count the entries in the Tuesday column. Oc. In the Classes table, count the occurrences of Tuesday in the Time column. d. In the ClassInstructors table, count the occurrences of Tuesday in the DayOfWeek column. QUESTION 32 In the Pitt Fitness database, what can you learn by examining the ClassInstructors data? a. Some classes use more than one instructor. b. Each instructor teaches only one class. c. All the instructors live in Pittsburgh. d. Each class has only one instructor. QUESTION 33 In the Pitt Fitness database, which attribute uniquely identifies each class? a. ClassType b. ClassName C. ClassID Od. ClassLocation QUESTION 34 In the Pitt Fitness database, which of the following attributes belongs in the Customers table? O a. BirthDate b. ClassName c. ReservationID d. InstructorID QUESTION 35 In the Pitt Fitness database, which of the following is an attribute in the Instructors entity? O a. InstructorFee b. Instructor Description c. InstructorCity d. Instructor Room QUESTION 36 In the Pitt Fitness database, which table relates classes and instructors? O a. Class Instructors O b. Customers O c. Customer Reservations d. Reservations QUESTION 37 table. In the Pitt Fitness database, you can determine which instructor is assigned a particular class by looking in the a. Class Instructors O b. Instructors c. Reservations O d. Classes QUESTION 38 In the Sports Physical Therapy database, how can you determine the number of sessions completed by therapist Steven Wilder? a. In the Therapist table, find the TherapistID for Steven Wilder, and then count the number of times his TherapistID appears in the Session table. b. In the Therapies table, count the number of values in the Session Therapist column for Steven Wilder. Oc. In the Therapist table, count the number of values in the SessionNum column for Steven Wilder. d. In the Session table, count the number of times Steven Wilder appears in the TherapistName column. QUESTION 39 In the Sports Physical Therapy database, how can you determine which therapist provided the longest amount of time to complete a particular service? O a. In the Therapies table, find the highest value in the UnitOfTime column. b. In the Therapies table, find the highest value in the TherapyCode column. c. In the Session table, find the highest value in the Session Num column. Od. In the Session table, find the highest value in the Length OfSession column. QUESTION 40 In the Sports Physical Therapy database, which attribute uniquely identifies each therapy session? O a. Patient Num O b. Session Type O c Therapy Code O d. SessionNum QUESTION 41 In the Sports Physical Therapy database, which table determines which therapist provided a service to a patient? O a. Patients O b. Therapist O c. Session Od. Therapies QUESTION 42 In the Sports Physical Therapy database, which table stores the date of an interaction between a patient and a therapist? O a. Patient O b. Session O c. PatientBillings O d. Billings QUESTION 43 In the Sports Physical Therapy database, you determine the description of the therapy a patient is receiving by finding the Therapy Code for the patient in the Session table, and then O a. looking up the Therapy Code in the Patient table O b. looking up the Therapy Code in the Therapies table O c. looking up the Therapy Code in the Therapist table O d. looking up the SessionNum in the Session table QUESTION 44 Microsoft Access is well-suited to which of the following cases? O a. The database is very large, containing dozens of tables and thousands of records. O b. A few trusted users work with the database at the same time. O c. The database has strict security requirements because it is available on the Internet. O d. Many users work with the database in separate geographical locations. QUESTION 45 The Access query design grid contains the ProductID, ProductName, and Rating fields. How can you omit the Rating field from the query results but use it to set a criterion for the query? O a. Delete the Rating field from the query design grid. O b. Change the query to an update query. O c. Clear the checkmark from the Rating field's Show check box. O d. Add a second copy of the Rating field to the query design grid. QUESTION 46 The field you use to sort records is called the O a. parent key O b. foreign key O c. sort key O d. sort argument QUESTION 47 What do two tables use to link related records from each table? O a. a form O b. a common field Oc an orphan record O d. a unique value QUESTION 48 What do you call the field used to join two tables on the "many" side of a one-to-many relationship? a. secondary sort field b. primary key field c. calculated field d. foreign key field QUESTION 49 What is the term for a collection of data organized in a manner that allows access, retrieval, and use of the data? a. entity O b. flat file c. database Od.code file QUESTION 50 What type of software programs are Access, Oracle, DB2, MySQL, and SQL Server? O a. E-R diagrams b. data files C. DBMSS d. DBAS