Question
Help with mysql questions as much as you can Question 16 (5 points) What scalar SELECT list function would you use to find the first
Help with mysql questions as much as you can
Question 16 (5 points)
What scalar SELECT list function would you use to find the first occurrence of a ~ in a varchar column named Y?
Question 16 options:
| SELECT SUBSTRING(Y, '~', 1, LEN(Y)) |
| SELECT REVERSE(CHARINDEX(Y, '~'), LEN(Y)) |
| SELECT LTRIM(Y, 1) |
| SELECT CHARINDEX('~', Y) |
Question 17 (5 points)
No entity without a natural identity is enforced by
Question 17 options:
| Foreign key |
| Surrogate primary key |
| Parent relationship |
| Natural key/Unique key |
Question 18 (5 points)
With a table that has an identity column as the primary key named PersonId and a non-key column LastName, which is the correct INSERT statement
Question 18 options:
| INSERT INTO Person (PersonId, LastName) VALUES (1, 'Smith') |
| INSERT INTO Person (PersonId, LastName) VALUES (IDENTITY, 'Smith') |
| INSERT INTO Person (LastName) VALUES ('Smith') |
| INSERT INTO Person (LastName) VALUES (GETIDENTITY(), 'Smith') |
Question 19 (5 points)
Scalar columns not used in aggregate functions must be mentioned in the GROUP BY clause.
Question 19 options:
| True |
| False |
Question 20 (5 points)
When trying to see if a pattern can be matched within another string we should use which operator?
Question 20 options:
| The REGEX operator |
| A relational operator |
| The EXISTS operator |
| The LIKE operator |
Question 21 (5 points)
Which join operator is more likely to return more results?
Question 21 options:
| OUTER JOIN |
| UNION JOIN |
| INNER JOIN |
| INTERSECTION JOIN |
Question 22 (5 points)
A subquery can be used in the SELECT list
Question 22 options:
| True |
| False |
Question 23 (5 points)
Which subset of SQL is used for dropping tables?
Question 23 options:
| DCL |
| DML |
| TCL |
| DDL |
Question 24 (5 points)
The result of this operation 'AB' + NULL + 'CD' is
Question 24 options:
| 'ABCD' |
| NULL |
| AB?CD |
| 'AB CD' |
Question 25 (5 points)
Suppose you are creating a database to support a web application and you need to store a narrative of someones personal history. What is the best MS SQL datatype to store that information?
Question 25 options:
| VARCHAR(MAX) |
| VARCHAR(100) |
| INT |
| Binary Large Object (BLOB) |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started