
SQL Concept with Prac Q
Authored by nitin.43545 Aviral
Computers
12th Grade
Used 6+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the column in the given table is Candidate Key?
Name & ClientID
City & Name
Mobile and ClientId
ClientNo & Pin
Answer explanation
This table contains ClientId and Mobile as Candidate key as these two column may contain unique values.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will be Degree and Cardinality of Given Table?
Degree-08
Cardinality-05
Degree-05
Cardinality-08
Degree-05
Cardinality-09
Degree-09
Cardinality-05
Answer explanation
Cardinality means No. of Rows in a Table
Degree means No. of Columns in a Table.
3.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Which Command is used to activate/ open a Database named CLUB?
4.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Which command is used to view structure of a Table EMPLOYEE?
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following command is correct to show name and city of Client in ascending order of their name?
SELECT * FROM Client ORDER BY name DESC
SELECT * FROM Client WHERE CITY ="Bombay" ORDER BY name DESC
SELECT name, city FROM Client ORDER BY name
SELECT name,city FROM Client ORDER BY DESC
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Which command is used to view all tables in existing database named MOVIE?
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will be result of following SQL Query?
SELECT Count(distinct(City)) FROM Client;
6
4
5
NONE
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 Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
YouCode Scratch Quiz
Quiz
•
KG - 12th Grade
15 questions
Python. GuiZero
Quiz
•
7th - 12th Grade
15 questions
Quiz No. 1 on Open Source Software
Quiz
•
11th - 12th Grade
15 questions
emptech L1 A
Quiz
•
12th Grade
10 questions
Kuiz Pemantapan Latihan Amali Pangkalan Data
Quiz
•
12th Grade
15 questions
Disk Management and Boot Sequence Vocab
Quiz
•
9th - 12th Grade
15 questions
Program Implementation
Quiz
•
10th - 12th Grade
11 questions
Database Management
Quiz
•
12th Grade - University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade