G10 Structured Query Language

Quiz
•
Computers
•
10th Grade
•
Hard

Fritz Bansag
Used 1+ times
FREE Resource
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Look at the table named "Employeelist"
Which SQL statement exactly represents in selecting all FIELDS where the Department = 'Engineering'
SELECT * FROM Employeelist WHERE Department = 'Engineering'
SELECT * FROM Employeelist WHEN Department = 'Engineering'
SELECT ^^ FROM Employeelist WHICH Department = 'Engineering'
SELECT ++ FROM Employeelist WHILE Department = 'Engineering'
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Look at the table named "Employeelist"
Which SQL statement exactly represents in selecting 'Name' where the Age is lesser than or equal '30'
SELECT Employeelist.Name FROM Employeelist WHERE Age <= '30'
SELECT Employeelist.[Name] FROM Employeelist WHERE Age <= '30'
SELECT Employeelist.Name FROM Employee_list WHERE Age =< '30'
SELECT Employeelist.Name FROM Employeelist WHERE Age <= '30'
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In creating a table named "Students2024".
Can you identify which is missing or error in the statement below:
CREATE Students2024(Employee_ID INTEGER, LASTNAME TEXT (50), FIRSTNAME TEXT (50))
TABLE
comma (s)
spelling error
No error
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Look at the image and create a table named "Students2024" with the parameters as shown.
CREATE TABLE Students2024(
Employee_ID INTEGER; LASTNAME TEXT (50); FIRSTNAME TEXT (50))
CREATE TABLE Students2024(
Employee_ID INTEGER, LASTNAME TEXT (50), FIRSTNAME TEXT (50))
CREATE Students2024(
Employee_ID INTEGER, LASTNAME TEXT (50), FIRSTNAME TEXT (50))
CREATE TABLE Students2024(
Employee_ID INTEGER, LASTNAME WORD (50), FIRSTNAME WORD (50))
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which statement is true to delete the table "Employee_list_V1" from the database.
DEL TABLE Employee_list_V1
DROP TABLE Employee_list_V1
DELETE Employee_list_V1
DROP_TABLE "Employee_list_V1"
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Which statement is true to delete the table "Employee_list_V1" from the database.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Look at the image and Identify if there is an error in the SQL statement.
( )
;
spelling error
No errors
[ ]
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Databases - DBMS

Quiz
•
1st - 11th Grade
7 questions
delete

Quiz
•
10th Grade
10 questions
National 5 Databases

Quiz
•
10th Grade
10 questions
Kiểm tra Tin học

Quiz
•
10th Grade
15 questions
7.7 Software Security Review

Quiz
•
8th Grade - University
10 questions
SQL

Quiz
•
9th - 11th Grade
15 questions
10.1 Communicating with other ICT users using email

Quiz
•
9th - 12th Grade
10 questions
SQL SELECT

Quiz
•
8th - 10th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade