Question: Solve all multiple choice please 46. With SQL, how do you select FirstName starts with an a? all the records from a table named Persons
Solve all multiple choice please 46. With SQL, how do you select FirstName" starts with an "a"? all the records from a table named Persons" where the value of the column A SELECT FROM Persons WHERE FirstName a B. SELECT . FROM Persons WHERE FirstNamea%as C. SELECT . FROM Persons WHERE FirstName uiE %a D. SELECT FROM Persons WHERE FirstName LIKE 'a% 47. Which of the following is not true about SQL statements? A. SQL statements are not case sensitive B. SQL statements can be written on one or more lines C. Keywords cannot be split across lines D. Clauses must be written on separate lines. 48. Which of the following is not true about modifying rows in a table? A. Existing rows in a table are modified using the UPDATE statement. B. You can update more than one row at a time. C. All the rows in a table are modified if you omit the WHERE clause. D. None of the above. 49. Which of the following is not true about constraints A NOT NULL constraint specifies that the column cannot have a NULL value. A UNIQUE constraint specifies that a column or a combination of column must have unique values for all rows A PRIMARY KEY is same as UNIQUE. A FOREIGN KEY enforces a foreign key relationship between a column and a referenced table A. B. C. D. 50. Can you sort a column using a column alias? A. True B. False C. Both of the above D. None of the above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
