<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M4GBQBB" height="0" width="0" style="display:none;visibility:hidden"></iframe>

Sign in Sign up

Shopping Cart

No products in the cart.

Search for:

Academic Team
Grade
- Grade 9
- O-Level
NCE Revision
Contact Us
Login

Search for:

Database – SQL (Paper 2)

0% Complete

0/0 Steps

Quiz 1 of 0

Database – SQL (Paper 2)

sumayyah July 27, 2024

Time limit: 0

Quiz Summary

0 of 3 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 3 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3

Current
Review
Answered
Correct
Incorrect

Question 1 of 3
1. Question
What will the SQL (Structured Query Language) statement do:
COUNT (Singer) FROM Songs WHERE Genre = “Sega”
- (i) Count the number of singers that sing Sega
- (ii) Count the number of singers not singing Sega
- (iii) Count all Sega songs
- (iv) Count all Singers and count all Sega irrespectively
Correct
Incorrect
Question 2 of 3
2. Question
Write an SQL statement to find the Title of Rock songs greater than 5 minutes.
- (i) COUNT (Title) FROM Songs WHERE Genre = “Rock” OR Minutes > 5.00
- (ii) SELECT SUM (Title) FROM Songs WHERE Genre = “Rock” AND Minutes > 5.00
- (iii) SELECT (Title) FROM Songs WHERE Genre = “Rock” AND Minutes > 5.00
- (iv) SELECT (Title) FROM Songs WHERE Genre = “Rock” OR Minutes > 5.00
Correct
Incorrect
Question 3 of 3
3. Question
Write an SQL statement to find the Total of all Sega songs sung by “Ti frer”
- (i) SELECT SUM (SongNumber) FROM Songs WHERE Author = “Ti frer”
- (ii) COUNT (SongNumber) FROM Songs WHERE Genre = “Sega” AND Author = “Ti frer”
- (iii) SELECT (SongNumber) FROM Songs WHERE Genre = “Sega” AND Author = “Ti frer”
- (iv) COUNT (SongNumber) FROM Songs WHERE Genre = “Sega” OR Author = “Ti frer”
Correct
Incorrect

Database – SQL (Paper 2)

Report

There was a problem reporting this post.

Harassment Harassment or bullying behavior

Inappropriate Contains mature or sensitive content

Misinformation Contains misleading or false information

Offensive Contains abusive or derogatory content

Suspicious Contains spam, fake content or potential malware

Other

Report note

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

See blocked member's posts
Mention this member in posts
Message this member
Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .