.l T-Mobile 4:55 PM a instructure-uploads.s3.amazonaws.com 87% Multiple Choice #

Question

.l T-Mobile 4:55 PM a instructure-uploads.s3.amazonaws.com 87% Multiple Choice #1. In a "SELECT" command, the "ORDER BY” clause filters which rows are shown in the resulting table A. true B.false #2. When would you use the "DEFAULT" clause? A. table When you want to avoid having any "NULL" values in the When you add a new column to an existing table, all of the field values for the new column will be set to "NULL C.When you want to specify values for other attributes, but not specify a value for the one attribute with the "DEFAULT" clause D.When you want to type "NULL" in the "INSERT" command when the column constraint for that attribute has the "NOT NULL" clause E. None of the above #3. Are these 2 tables Union-compatible? Table: P Table: Q 0102 3 a 10010 b 20020 30030 P1 P2 y 20 B.N

Explanation / Answer

Ques 1. False

It displays the table in ascending or descinding order.

Ques 2. Answer : (A)

default is used to provide a default value to a column if it is not given any value while creating a row in the table. We use it to prevent any NULL in the table as NULL is the default value predefined.

Ques 3. No

The field count and names need to be equal.

Ques 4. True

SQL is case insensitive.

Ques 5. True

SQL is case insensitive.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.