If you define a column with a default value. that value is used whenever a row

Hi, I want to answer this Q: 13. If you define a column with a default value, that value is used whenever a row. a. is added to the table. b. in the table is updated. c. That doesn’t include a value for that column is added to the table. d. With a zero value for that column is added to the table. 14. When coded in a WHERE clause, which search condition will return invoices when payment date isn’t null and invoice total is greater than or equal to $500? a. payment_date IS NULL AND invoice_total > 500 b. payment_date IS NOT NULL OR invoice_total >= 500 c. NOT (payment_date IS NULL AND invoice_total <= 500) d. payment_date IS NOT NULL AND invoice_total >= 500 15. In a cross join, all of the rows in the first table are joined with all of the a. distinct rows in the second table b. matched rows in the second table c. unmatched rows in the second table d. rows in the second table 16. what sql command is used to de-normalization data a. Create table b. Create Sequence c. Create View d. Create Snowflake 17. two characteristics of NoSQL database are a. Open Source and created after the year 2000 b. Non-Normalized and uses JSON. c. Open Source and Non-Normalized. d. Uses JSON and created after the year 2000 18. This SQL command removes tables Drop a. Update b. Delete c. Remove 19. The type of database used in Facebook a. Graph b. NoSQL c. A&B d. None of the above 20. Which of the following does not violate the referential integrity of a database? a. inserting a new row into a table with a foreign key that doesn’t match a primary key in the related table b. updating a foreign key with a value that doesn’t match a primary key in the related table c. updating a primary key in a primary key table without also updating the foreign keys for the related rows in all related tables d. deleting a row in a foreign key table without deleting the related row in the related primary key table. 21. To apply a second normal form, you move columns that don’t depend on the entire primary key to another table and establish a relationship between the two tables. This a. reduces redundancy but makes maintenance more difficult. b. reduces redundancy and makes maintenance easier c. increases redundancy but makes maintenance easier d. increases redundancy but the data more consistent.

Answer

13. If you define a column with a default value, that value is used whenever a row. Ans) Option C is the correct answer, i.e; That doesn’t include a value for that column is added to the table.
Explanation:
If you define a column with a default value, that value is used whenever a row then That doesn’t include a value for that column is added to the table. and the remaining options are wrong. 14. When coded in a WHERE clause, which search condition will return invoices when payment date isn’t null and invoice total is greater than or equal to $500? Ans) Option d is the correct answer, i.e; payment_date IS NOT NULL AND invoice_total >= 500
Explanation:
When coded in a WHERE clause, which search condition will return invoices when payment date isn’t null and invoice total is greater than or equal to $500 then payment_date IS NOT NULL AND invoice_total >= 500 and the remaining options are wrong. 15. In a cross join, all of the rows in the first table are joined with all of Ans) Option d is the correct answer, i.e; rows in the second table
Explanation:
in a cross join, all of the rows in the first table are joined with all of rows in the second table and the remaining options are wrong. 16. what sql command is used to de-normalization data Ans) Option d is the correct answer, i.e; Create Snowflake
Explanation:
Create Snowflake ql command is used to de-normalization data. and the the remaining options are wrong. 17. two characteristics of NoSQL database are Ans) Option d is the correct answer, i.e ;Uses JSON and created after the year 2000 18. This SQL command removes tables Ans) Drop Command removes SQL tables. 19. The type of database used in Facebook Ans)Option b is the correct answer, i.e ;NoSQL 20. Which of the following does not violate the referential integrity of a database? Ans) Option d is the correct answer, i.e ; deleting a row in a foreign key table without deleting the related row in the related primary key table 21. To apply a second normal form, you move columns that don’t depend on the entire primary key to another table and establish a relationship between the two tables. This Ans) Option b is the correct answer, i.e ;reduces redundancy and makes maintenance easier

Hope This Helps, if you have any doubts Please comment i will get back to you, thank you and please thumbs up

Leave a Comment