DRAG DROP -You have a database table that stores information about school attendance.You have a data set that is defined as follows:You have the following requirements:✑ StudentName must consist of a string of characters.✑ GradeLevel must be only a whole number.DaysAbsent can have one number after the decimal.Match the data types to the column names.Instructions: To answer, drag the appropriate data type from the column on the left to its column name on the right Each data type may be used once, more than once, or not at all. Each correct match is worth one point.Select and Place:
HOTSPOT -Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.Hot Area:
This question requires that you evaluate the underlined text to determine if it is correct.In a database table, each column represents a unique record.Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
This question requires that you evaluate the underlined text to determine if it is correct.You have two tables. Each table has three rows. You create a SQL query that uses a cross join. The query does not include a WHERE clause.Nine rows will be included in the Cartesian product of these two tables.Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement corrector.
You have two tables named Salesperson and Sales.You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.Which database object should you add to the Sales table?
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
