Focus
Planner
News
Login
Get Started

CSP SQL Quiz 1

csp-sql-quiz-1

Exit

Question 1 of 1

Time Left

0

322010

0

1200

block

SQL Stands for?

Select the correct answer(s).

(0/0)

0

1

2

1

322033

0

1200

none

Is this a valid SQL statement? SELECT FROM CATEGORY

Select the correct answer(s).

(0/0)

0

1

322013

0

1200

none

Match the statement with what it does:

Match the text (click and drag)

(0/0)

0

Match the text
SELECT
INSERT
DELETE
UPDATE

0

1

2

3

4

Click and drag
change data in an existing row in a database
add records to a database
retrieve data from a database
remove records from a database

4

322019

0

1200

none

Given the table shown how many records are returned by this statement: SELECT * FROM CUSTOMERS

Select the correct answer(s).

(0/0)

0

1

2

3

4

1

5

1

322034

0

1200

none

Given the table shown, how many rows are returned by the following statement: SELECT DISTINCT Country FROM Customers

Select the correct answer(s).

(0/0)

0

1

2

3

4

1

5

1

322030

0

1200

none

Given the table shown, how many records are returned by this statement: SELECT FROM CUSTOMERS WHERE COUNTRY = 'Germany'

Select the correct answer(s).

(0/0)

0

1

2

3

4

5

1

322037

0

1200

none

Given the table shown, how many rows are returned by this statement: SELECT * FROM Customers where (Country = 'Mexico' OR Country Like '%an%')

Select the correct answer(s).

(0/0)

0

1

2

3

4

5

1

322043

0

1200

none

Given the table shown, how many rows are affected by this statement: UPDATE Customers Set City = 'Cincinnati'

Select the correct answer(s).

(0/0)

0

1

2

3

4

1

5

1

322042

0

1200

none

Which one of these statements removes three rows from the table shown?

Select the correct answer(s).

(0/0)

0

1

2

1

322044

0

1200

none

Which of the following statements will change the city to 'Cincinnati' for all 'Mexico' records in the table shown

Select the correct answer(s).

(0/0)

0

1

2

3

1

4

2

Results

Correct

0 Incorrect

0 Skipped

0 Overall Percentage

0%

Saving quiz

Save Score

Rate Quiz

Save Rating

Exit

Correct Answer

You've answered correctly.

Answer Incorrect

You've answered incorrectly.

Out Of Time

You've ran out of time.

Save

To save scores or ratings you'll need to login or register.

Sign In

Register

Audio Settings

Language

Set the correct audio language for your text.

Danish Dutch English French German Icelandic Italian Japanese Korean Norwegian Polish Portuguese Romanian Russian Spanish Swedish Turkish Welsh

Highlighting

Improve your learning by highlighting words as they are spoken.

Word-By-Word Highlighting

Listen To Audio

You can play quizzes, courses and flashcards without needing to login. However to save scores and to make quizzes, courses and flashcards you'll need to be logged in. To play audio you'll need to be logged into a Professional Account.

Register Login

Listen To Audio

Take your learning to the next level. Upgrade to a Professional Account to hear your questions read aloud as well as enjoying many other benefits.

Audio is generated for any question or answer you create.

Many people learn better when they listen to what they're learning. For learning a foreign language we supported over 18 different languages.

Supported languages include Danish, Dutch, English, French, German, Icelandic, Italian, Japanese, Korean, Norwegian, Polish, Portuguese, Romanian, Russian, Spanish, Swedish, Turkish and Welsh.

We also support automatic word-by-word highlighting as words are read aloud.

Find Out More