Data Management Applications EXAM | ACCURATE QUESTIONS AND DETAILED ANSWERS | GUARANTEED PASS | GRADED A | LATEST UPDATE

1. A database manager starts to convert data that has been normalized into a form that conforms to the relational model. A simple primary key has been established and all the repeating groups have been deleted. In which form is this data? A. First normal form B. Second normal form C. Third normal form D. Fourth normal form Correct Answer: B. Second normal form Rationale: First normal form eliminates repeating groups. Second normal form is achieved once all non-key attributes are fully functionally dependent on the primary key. 2. Two attributes in two related tables have the exact same domain of values. The attribute is a primary key in one table. Which kind of key is the attribute in the other table? A. Foreign B. Primary C. Compound D. Composite Correct Answer: A. Foreign Rationale: A foreign key in one table references the primary key in another, linking the two tables through a common domain. 3. When a product is deleted from the product table, all corresponding rows for the product in the pricing table are deleted automatically as well. What is this referential integrity technique called? A. Foreign key constraint B. Referential delete C. Cascaded delete D. Dynamic update Correct Answer: C. Cascaded delete Rationale: A cascading delete automatically removes related rows in child tables when the parent row is deleted. 4. Which command should be added to the end of the following SQL statement to make the event_id attribute the primary key? sql CopyEdit CREATE TABLE test1 (contact_id INT(10), name VARCHAR(10), event_id INT(5), A. PRIMARY KEY = event_id)); B. PRIMARY KEY (event_id)); C. (PRIMARY KEY: event_id); D. PRIMARY (event_id)' Correct Answer: B. PRIMARY KEY (event_id)); Rationale: This is the correct syntax to define a primary key within a CREATE TABLE statement. 5. What does the clause PRIMARY KEY (column) mean in a CREATE TABLE statement? A. The primary key value, in parentheses, can be used by a column. B. The column, in parentheses, is the primary key for the table. C. The foreign key, in parentheses, is linked to the primary key. D. The row, in parentheses, can be inserted as the foreign key. Correct Answer: B. The column, in parentheses, is the primary key for the table. Rationale: This defines the primary key column that uniquely identifies each row in the table. 6. Which statement assigns a foreign key to the customer name? A. FOREIGN KEY ( customer_name ) REFERENCES table_name ( customer_name ) B. FOREIGN KEY = customer_name REFERENCES table_name ( customer_name ) C. FOREIGN KEY ( customer_name ) ( index_columns ) D. FOREIGN KEY [ table_name ] ( customer_name ) Correct Answer: A. FOREIGN KEY ( customer_name ) REFERENCES table_name ( customer_name ) Rationale: This is the correct SQL syntax to define a foreign key relationship between two tables. 7. Which command creates a database only if it does not already exist? A. IF NOT EXISTS db_name ; B. CREATE DATABASE IF NEW db_name ; C. CREATE DATABASE IF NOT EXISTS db_name ; D. IF NOT EXISTS CREATE DATABASE db_name ; Correct Answer: C. CREATE DATABASE IF NOT EXISTS db_name ; Rationale: This SQL statement creates the database only if it is not already present. 8. Which line should be added to this SQL statement to return products that cost 20 dollars? sql CopyEdit SELECT PRODNUM, PRODNAME FROM PRODUCT A. WHERE PRODCOST=20; B. AND PRODCOST=20; C. WHERE PRODCOST=20; D. AND PRODCOST=20; Correct Answer: A. WHERE PRODCOST=20; Rationale: The WHERE clause filters rows, selecting only those where PRODCOST equals 20. 9. What does WHERE identify in a basic SQL SELECT statement? A. The associative entity B. The rows to be included C. A table's intersection data D. A range of included columns Correct Answer: B. The rows to be included Rationale: The WHERE clause filters the rows returned by a SELECT query. 10. Which line added to this SQL statement returns employee numbers of at least 1000? sql CopyEdit SELECT EMPNUM FROM EMPLOYEE A. WHERE EMPNUM = 1000+; B. WHERE EMPNUM 1000; C. WHERE EMPNUM = 1000; D. WHERE EMPNUM = 1000; Correct Answer: D. WHERE EMPNUM = 1000; Rationale: The = operator returns values greater than or equal to 1000. 11. Which line returns the total number of each kind of product by product number? sql CopyEdit SELECT PRODNUM, SUM(QUANTITY) FROM SALESPERSON A. SUM PRODNUM; B. COUNT PRODNUM; C. ORDER BY PRODNUM; D. GROUP BY PRODNUM; Correct Answer: D. GROUP BY PRODNUM; Rationale: GROUP BY is used with aggregate functions to group results by one or more columns. 12. Which data definition language (DDL) statement affects databases or their objects? A. SELECT B. INSERT C. ALTER D. NULL Correct Answer: C. ALTER Rationale: ALTER is a DDL command used to modify the structure of database objects. 13. What does the DELETE statement do? A. It removes views. B. It removes rows from a table. C. It removes columns from a table. D. It removes columns not named in the column list. Correct Answer: B. It removes rows from a table. Rationale: DELETE removes existing records from a table. 14. What condition must be met to use INSERT INTO ... VALUES? A. The VALUES list must contain a value for each non-null valued column in the table. B. The VALUES list must contain a value for each row in the table. C. The statement must generate a LOAD DATA command. D. The table must be in the sampdb database. Correct Answer: A. The VALUES list must contain a value for each non-null valued column in the table. Rationale: Every column declared NOT NULL must have a corresponding value provided in the INSERT statement. 15. What kind of data type is FLOAT in this SQL statement? sql CopyEdit f FLOAT(10,4) A. Decimal B. Integer C. String D. Data Correct Answer: A. Decimal Rationale: FLOAT represents approximate decimal numbers with floating points. 16. Which two SQL data types can represent images or sounds? (Choose 2) A. INT B. FLOAT C. BINARY D. TERNARY E. TINYBLOB F. SOUNDBLOB Correct Answers: C. BINARY and E. TINYBLOB Rationale: BINARY and TINYBLOB are used to store binary large objects like images and audio. 17. Which component of this SQL command indicates the table's name? sql CopyEdit CREATE TABLE CUSTOMER (...) A. TABLE CUSTOMER B. CustomerID C. CUSTOMER D. INT Correct Answer: C. CUSTOMER Rationale: The name directly following CREATE TABLE is the name of the new table. 18. Which method creates an empty copy of a table and then populates it from the original table? A. INSERT TABLE ... SELECT followed by INSERT INTO ... LIKE B. CREATE TABLE ... LIKE followed by INSERT INTO ... SELECT C. CREATE TABLE ... INTO followed by INSERT INTO D. INSERT TABLE ... LIKE followed by SELECT Correct Answer: B. CREATE TABLE ... LIKE followed by INSERT INTO ... SELECT Rationale: This process duplicates a table structure and then fills it with existing data. 19. What does the ALTER TABLE syntax allow? (Choose 2) sql CopyEdit ALTER TABLE tbl_name action [, action ] ... ; A. Adding rows B. Dropping indexes C. Changing storage space D. Changing column data types Correct Answers: B. Dropping indexes and D. Changing column data types Rationale: ALTER TABLE is used to change the structure of a table including dropping indexes and altering columns. 20. Which command eliminates a table? A. TRUNCATE TABLE B. DELETE TABLE C. REMOVE TABLE D. DROP TABLE Correct Answer: D. DROP TABLE Rationale: DROP TABLE permanently deletes the table and its structure. 21. Why is a view used to give controlled access to data? A. To add complexity to encryption B. To move complex security routines to subqueries C. To restrict access to persons retrieving and modifying sensitive information D. To limit many-to-many relationships Correct Answer: C. To restrict access to persons retrieving and modifying sensitive information Rationale: Views provide a way to present only selected data while hiding sensitive information. 22. Which ALTER TABLE statement adds a foreign key constraint to a child table? A. sql CopyEdit ALTER TABLE child ADD FOREIGN KEY (par_id) REFERENCES parent (par_id) ON DELETE CASCADE; B. sql CopyEdit ALTER TABLE child ADD FOREIGN KEY (par_id) WHERE parent (par_id) ON DELETE CASCADE; C. sql CopyEdit ALTER TABLE child ADD FOREIGN KEY WHERE parent (par_id) ON DELETE CASCADE; Correct Answer: A Rationale: This is the proper syntax for adding a foreign key constraint that ensures referential integrity with cascading deletes.