Question: When writing SQL table-creating command sequences, the entire table definition is enclosed in _______.
Answer Options:
Answer: (C) parentheses.
Question: You cannot have an invalid entry in the foreign key column; at the same time, you cannot delete a vendor row as long as a product row references that vendor. This is known as _______.
Answer Options:
Answer: (B) referential integrity.
Question: All changes in a table structure are made using the _______ TABLE command, followed by a keyword that produces the specific changes a user wants to make.
Answer Options:
Answer: (A) ALTER.
Question: A table can be deleted from the database by using the _______ TABLE command.
Answer Options:
Answer: (A) DROP.
Question: SQL requires the use of the _______ command to enter data into a table.
Answer Options:
Answer: (A) INSERT.
Question: Which command would be used to delete the table row where the P_CODE is ‘BRT-345’?
Answer Options:
Answer: (A) DELETE FROM PRODUCT WHERE P_CODE = ‘BRT-345’;
Question: The order of the rows and columns is important to the DBMS.
Answer Options:
Answer: (B) False.
Question: Each table in a relational database must have a primary key.
Answer Options:
Answer: (A) True.
Question: Each table _______ represents an attribute.
Answer Options:
Answer: (A) column.
Question: In the relational model, _______ are important because they are used to ensure that each row in a table is uniquely identifiable.
Answer Options:
Answer: (B) keys.
Question: Referential _______ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.
Answer Options:
Answer: (A) integrity.
Question: The _______ constraint can be placed on a column to ensure that every row in the table has a value for that column.
Answer Options:
Answer: (B) NOT NULL.
Question: A(n) _______ join links tables by selecting only the rows with common values in their common attributes.
Answer Options:
Answer: (C) inner.
Question: The _______ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.
Answer Options:
Answer: (D) system catalog.
Question: The _______ relationship is the “relational model ideal.”
Answer Options:
Answer: (B) 1
Question: As a manager, when you provide rewards or reprimand your subordinates, you are practicing transactional leadership. True False Correct Answer: True
Answer:
Question: Which of the following is NOT one of the five sources of power? appearance reward informational legitimate Correct Answer: appearance
Answer:
Question: ________ power is power managers have resulting from their formal positions within organizations. (Choose the best answer) Legitimate Informational Referent Expert Correct Answer: Legitimate
Answer: