sql queries - 2
Authored by sreerekha R
Computers
12th Grade
Used 225+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which would show all fields from the Pupils table?
SELECT * FROM Pupils
SELECT Name, Form FROM Pupils
SELECT * FROM *
SELECT * FROM Forms
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Symbol means "All"
*
&
%
!
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which would find pupils with "er" anywhere in their name?
SELECT * FROM Pupils Where Name = "%er"
SELECT * FROM Pupils Where Name = "$er$"
SELECT * FROM Pupils Where Name = "%er%"
SELECT * FROM Pupils Where Name = "er%"
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is it called when SQL is used in an attempt to harm a database?
SQL Injection
SQL Interception
SQL Attack
SQL Misuse
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Choose the correct query
SELECT * FROM EMP WHERE NAME=NULL
SELECT * FROM EMP WHERE NAME IS NULL;
SELECT FROM EMP WHERE NAME IS NULL;
SELECT *FROM EMP WHERE NAME IS 'NULL';
6.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
The restrictions or conditions applied on data are known as (a)
7.
FILL IN THE BLANKS QUESTION
30 sec • 1 pt
The primary key of a table which is present in another table for referencing is known as (a)
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
