SQL Help True/False a) DML commands are used to edit data in a database. (T/F) b

ID: 3733794 • Letter: S

Question

SQL Help

True/False

a) DML commands are used to edit data in a database. (T/F)

b) Use the equal sign to test for Null. (T/F)

c) The tests below will both return the record where the value in the field ProjectName is “Earn Straight A’s”. (T/F)

Test 1: ProjectName Like ‘%E%’

Test 2: ProjectName Like ‘E%

d) Aggregate functions are used to compare values across columns. (T/F)

e) Subqueries and joins can be used in the same SELECT command. (T/F)

f) Precedence doesn’t apply to logical operators. (T/F)

g) The keyword ‘IN’ can only be used in subqueries. (T/F)

h) Subqueries can be used in the SELECT, FROM, and WHERE clauses. (T/F)

j) A field value can be compared to the results of a subquery using a relational operator. (T/F)

k) Subqueries cannot use the GROUP BY clause. (T/F)

a- true as DML is acronymm for data manipulation language and it is used to edit the data in database.

b-false to test for null IS NULL is used.

c- false only 'E%' will return Earn.

d-false it is used to summarising values across columns.

e- True this can be done.

f- false it applies on logocal operators where NOT is evaluated first then AND and then OR.

g-False IN can also be used without subqueries.

h- false it can only be used in where clause.

j-True this is posible in SQL.

k-Ture subqueries cannot use the GROUP BY clause.

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