
SQL QUERIES REVISION 2
Authored by janathul firthouse
Computers
11th Grade - University
Used 2+ 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 SELECT QUESTION
45 sec • 1 pt
Which of the following requirement can be implemented using a CHECK constraint?
(a) Student must be greater than 18 years old.
(b) Student must be form a BRICS Country (Brazil, Russia, India, China, South Africa)
(c) Student’s roll number must exist in another table(say, namely Eligible)
(d) None of these 1
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the maximum value that can be stored in NUMBERIC(4,2)
(a) 9999.99
(b) 99.9999
(c) 99.99
(d) 9.99
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
. What should be the data type for the column Pricestoring values less than Rs.1000 e.g. 200.21
(a) VARCHAR(50)
(b) NUMBER
(c) NUMBER(5,2)
(d) NUMBER(6)
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
All aggregate functions ignore NULLs except for the __________ function.
(a) Distinct
(b) Count(*)
(c) Average()
(d) None of these
5.
FILL IN THE BLANK QUESTION
1 min • 1 pt
To remove a character from the right side of a string, _____ function is used
6.
FILL IN THE BLANK QUESTION
1 min • 1 pt
The functions that work with one row at a time are _____ _____ functions
7.
FILL IN THE BLANK QUESTION
1 min • 1 pt
The ______ _______ clause is used to divide result of SELECT query in groups.
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
15 questions
Databases
Quiz
•
11th Grade
8 questions
Cha-ching 2
Quiz
•
1st Grade - University
15 questions
Начала программирования на языке Паскаль
Quiz
•
8th - 11th Grade
13 questions
RAM&HDD/SSD
Quiz
•
10th - 12th Grade
15 questions
11° Evaluación bimestral de informática
Quiz
•
11th Grade
10 questions
Server Administration- Quiz 1
Quiz
•
12th Grade - University
11 questions
Computer Science (1-9) - Identifying & Preventing Threats
Quiz
•
University
10 questions
Quiz Informatica Jornadas Orientación Asunción
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
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th 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