Let's practice! - String

Let's practice! - String

University

5 Qs

quiz-placeholder

Similar activities

Let's practice! - Group by & Having

Let's practice! - Group by & Having

University

2 Qs

Fractures

Fractures

University

8 Qs

Lesson 10-11

Lesson 10-11

University

10 Qs

Nursing Pharmacology 2021

Nursing Pharmacology 2021

University

10 Qs

Choose the level of Bloom’s Taxonomy

Choose the level of Bloom’s Taxonomy

University

10 Qs

Hoyt_810 M7 Discussion

Hoyt_810 M7 Discussion

University

10 Qs

Polishing amalgams

Polishing amalgams

University

10 Qs

Let's practice! - String

Let's practice! - String

Assessment

Quiz

Specialty

University

Hard

Created by

Thuan Tran

FREE Resource

5 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Retrieve the length of the description column, returning the results as description_length.

SELECT ........... (...........) AS ........... FROM grid;

2.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Retrieve the first 25 characters from the description column in the grid table. Name the results first_25_left.

SELECT ...........(...........,...........) AS ........... FROM grid;

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Amend the query to retrieve the last 25 characters from the description. Name the results last_25_right.

SELECT LEFT(description, 20) AS ........... FROM grid;

4.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Edit the query to return the CHARINDEX of the string 'Weather' whenever it appears within the description column.

SELECT description, ..........('..........', description) FROM grid

WHERE description LIKE '%Weather%';

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

  • Fill in the blank

  • Complete the substring function to begin extracting from the correct character in the description column.

SELECT description, CHARINDEX('Weather', description) AS start_of_string,

LEN ('Weather') AS length_of_string,

SUBSTRING(______,______,______) AS additional_description

FROM grid

WHERE description LIKE '%Weather%';