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:
You are structuring a table in a relational database.
Instructions: For each of the following statement, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Hot Area:
You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
A. defragmentation
B. normalization
C. fragmentation
D. denormalization
Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Which statement creates a composite key?
A. Option A
B. Option B
C. Option C
D. Option D
You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
A. INTEGER
B. DOUBLE
C. COUNT
D. FLOAT
You need to store the contact information for each student in your school database. You should store each student's information in a:
A. Stored procedure
B. Function
C. Row
D. Variable
You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column.
The results include: All customers and their orders Customers who have no orders
Which type of join do these results represent?
A. Complete join
B. Partial join
C. Inner join
D. Outer join
You need to establish a set of permissions that you can routinely assign to new users. What should you create?
A. Resource
B. Group
C. List
D. Role
You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted. What is the result in the database?
A. The table will be corrupted.
B. Forty (40) rows will be deleted from the table.
C. The transaction will restart.
D. No rows will be deleted from the table.
You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?
A. TRUNCATE
B. JOIN
C. EXCEPT
D. UNION
While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?
A. Foreign key
B. Index key
C. Link key
D. Default key
You ate creating a database object named Student to store the following data:
Which syntax should you use to create the object?
A. Option A
B. Option B
C. Option C
D. Option D
You create the following table, which lists how many books you have on loan to your friends.
Harry in San Francisco returns your books.
Which statement will update your table correctly?
A. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' AND City = 'San Francisco')
B. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' OR City = 'San Francisco')
C. UPDATE LoanedBooks SET Books = 0 WHERE (Name in 'Harry', 'San Francisco')
D. INSERT INTO LoanedBooks SET Books = 0 WHERE ID =
This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
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
A. No change is needed
B. INTERSECT
C. ALL
D. JOIN