Search Header Logo

DBMS Theory QUIZ-II

Authored by Rahul Kumar

Computers

University

Used 6+ times

DBMS Theory QUIZ-II
AI

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

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?