
DBMS Theory QUIZ-II
Quiz
•
Computers
•
University
•
Practice Problem
•
Hard
Rahul Kumar
Used 6+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
You have a relation called "Employees" that contains information about employees, including their salaries. You want to find the average salary of all employees. Which relational algebra operation would you use?
SELECT
PROJECT
AGGREGATE
JOIN
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
With SQL, how can you return the number of not null records in the “Persons” table?
SELECT COUNT() FROM Persons
SELECT COLUMNS() FROM Persons
SELECT COLUMNS(*) FROM Persons
SELECT COUNT(*) FROM Persons
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
You have a "Products" relation that contains information about products, including their prices. You want to find the products with a price greater than $100. What relational algebra operation would you use?
SELECT
PROJECT
JOIN
DIFFERENCE
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
SQL query to find the temperature in increasing order of all cities.
SELECT city FROM weather ORDER BY temperature
SELECT city, temperature FROM weather
SELECT city, temperature FROM weather ORDER BY temperature
SELECT city, temperature FROM weather ORDER BY city
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In a database, you have a "Sales" relation that contains information about sales transactions, including the salesperson's name. You want to find the distinct names of salespeople who made sales. What relational algebra operation would you use?
SELECT
PROJECT
UNION
DISTINCT
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
You have a "Students" relation that contains information about students, including their ages. You want to find the average age of all students. Which relational algebra operation would you use?
SELECT
PROJECT
AGGREGATE
JOIN
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
You have two relations, "Employees" and "Departments." The "Employees" relation contains employee information, and the "Departments" relation contains department information. You want to find all employees in the "HR" department. What relational algebra operation would you use?
SELECT
PROJECT
JOIN
INTERSECT
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
Chapter 8 - Memory Management Strategies
Quiz
•
University
10 questions
Website Usability and UX
Quiz
•
University
10 questions
Quiz - CSE
Quiz
•
University
15 questions
GK Quiz
Quiz
•
University
10 questions
Hands-on Modul 3
Quiz
•
University
10 questions
Visual Basic 2010
Quiz
•
8th Grade - University
10 questions
CS100||MsWord
Quiz
•
University
11 questions
Types of Mass Media
Quiz
•
10th Grade - Professi...
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
