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

Hottest videos

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts