Which of the following best describes a relational database?

A database that stores data in a hierarchical structure

A database that organizes data into tables with relationships between them

A database that stores data in a key-value format

A database that allows data to be accessed randomly

What is the purpose of a primary key in a relational database table?

It is used to uniquely identify a record in the table

It is used to sort the records in the table

It is used to create relationships between tables

It is used to define the data types of the columns in the table

In a relational database, what is a foreign key?

A key that is used to uniquely identify a record in a table

A key that is used to sort the records in a table

A key that creates a relationship between two tables

A key that defines the data types of the columns in a table

Consider the following table "employees": +----+----------+-----------+ | id | name | salary | +----+----------+-----------+ | 1 | John | 50000 | | 2 | Alice | 60000 | | 3 | Bob | 45000 | +----+----------+-----------+ Which SQL query will retrieve the names of employees with a salary greater than 50000?

SELECT name FROM employees WHERE salary > 50000;

SELECT name FROM employees WHERE salary >= 50000;

SELECT name FROM employees WHERE salary < 50000;

SELECT name FROM employees WHERE salary <= 50000;

Consider the following table "orders": +----+------------+------------+ | id | order_date | total | +----+------------+------------+ | 1 | 2022-05-01 | 100 | | 2 | 2022-06-15 | 250 | | 3 | 2022-07-03 | 75 | +----+------------+------------+ Which SQL query will retrieve the total revenue earned in June 2022?

SELECT SUM(total) FROM orders WHERE order_date LIKE '2022-06%';

SELECT SUM(total) FROM orders WHERE order_date = '2022-06%';

SELECT SUM(total) FROM orders WHERE order_date LIKE '%2022-06%';

SELECT SUM(total) FROM orders WHERE order_date = '%2022-06%';

Consider the following table "products": +----+---------+-------+ | id | name | price | +----+---------+-------+ | 1 | Laptop | 1000 | | 2 | Monitor | 300 | | 3 | Mouse | 25 | +----+---------+-------+ Which SQL query will retrieve the average price of all products?

SELECT AVG(price) FROM products;

SELECT SUM(price) FROM products;

SELECT COUNT(price) FROM products;

SELECT MAX(price) FROM products;

Consider the following table "customers": +----+----------+-----------+ | id | name | city | +----+----------+-----------+ | 1 | John | New York | | 2 | Alice | Chicago | | 3 | Bob | New York | +----+----------+-----------+ Which SQL query will retrieve the unique cities from which customers belong?

SELECT DISTINCT city FROM customers;

SELECT UNIQUE city FROM customers;

SELECT city FROM customers WHERE DISTINCT;

SELECT city FROM customers GROUP BY city;

Consider the following table "employees": +----+----------+-----------+ | id | name | salary | +----+----------+-----------+ | 1 | John | 50000 | | 2 | Alice | 60000 | | 3 | Bob | 45000 | +----+----------+-----------+ Which SQL query will retrieve the highest salary from the employees table?

SELECT MAX(salary) FROM employees;

SELECT MIN(salary) FROM employees;

SELECT AVG(salary) FROM employees;

SELECT SUM(salary) FROM employees;

Consider the following table "orders": +----+------------+------------+ | id | order_date | total | +----+------------+------------+ | 1 | 2022-05-01 | 100 | | 2 | 2022-06-15 | 250 | | 3 | 2022-07-03 | 75 | +----+------------+------------+ Which SQL query will retrieve the number of orders placed in each month?

SELECT MONTH(order_date), COUNT(id) FROM orders GROUP BY MONTH(order_date);

SELECT YEAR(order_date), COUNT(id) FROM orders GROUP BY YEAR(order_date);

SELECT DAY(order_date), COUNT(id) FROM orders GROUP BY DAY(order_date);

Consider the following table "products": +----+---------+-------+ | id | name | price | +----+---------+-------+ | 1 | Laptop | 1000 | | 2 | Monitor | 300 | | 3 | Mouse | 25 | +----+---------+-------+ Which SQL query will retrieve the products with a price greater than the average price?

SELECT * FROM products WHERE price > AVG(price);

SELECT * FROM products WHERE price > (SELECT AVG(price) FROM products);

SELECT * FROM products HAVING price > AVG(price);

SELECT * FROM products HAVING price > (SELECT AVG(price) FROM products);

Consider the following table "employees": +----+----------+-----------+ | id | name | salary | +----+----------+-----------+ | 1 | John | 50000 | | 2 | Alice | 60000 | | 3 | Bob | 45000 | +----+----------+-----------+ Which SQL query will retrieve the names of employees with a salary between 50000 and 60000?

SELECT name FROM employees WHERE salary > 50000 AND salary < 60000;

SELECT name FROM employees WHERE salary BETWEEN 50000 AND 60000;

SELECT name FROM employees WHERE salary > 50000 OR salary < 60000;

SELECT name FROM employees WHERE salary = 50000 OR salary = 60000;

Consider the following table "orders": +----+------------+------------+ | id | order_date | total | +----+------------+------------+ | 1 | 2022-05-01 | 100 | | 2 | 2022-06-15 | 250 | | 3 | 2022-07-03 | 75 | +----+------------+------------+ Which SQL query will retrieve the orders with a total greater than the average total?

SELECT * FROM orders WHERE total > AVG(total);

SELECT * FROM orders WHERE total > (SELECT AVG(total) FROM orders);

SELECT * FROM orders HAVING total > AVG(total);

SELECT * FROM orders HAVING total > (SELECT AVG(total) FROM orders);

Consider the following table "employees": +----+----------+-----------+ | id | name | salary | +----+----------+-----------+ | 1 | John | 50000 | | 2 | Alice | 60000 | | 3 | Bob | 45000 | +----+----------+-----------+ Which SQL query will retrieve the names of employees whose names contain the letter "o"?

SELECT name FROM employees WHERE name LIKE '%o%';

SELECT name FROM employees WHERE name LIKE 'o%';

SELECT name FROM employees WHERE name LIKE '%o';

SELECT name FROM employees WHERE name = 'o';

Relational Databases - 1 Free MCQ Practice Test with Solutions

EduRev

All Courses

Open App

	Database Management System (DBMS) 75 videos\|44 docs

	Database Management System (DBMS) 75 videos\|44 docs

Important Questions for Relational Databases - 1

Find all the important questions for Relational Databases - 1 at EduRev.Get fully prepared for Relational Databases - 1 with EduRev's comprehensive question bank and test resources. Our platform offers a diverse range of question papers covering various topics within the Relational Databases - 1 syllabus. Whether you need to review specific subjects or assess your overall readiness, EduRev has you covered. The questions are designed to challenge you and help you gain confidence in tackling the actual exam. Maximize your chances of success by utilizing EduRev's extensive collection of Relational Databases - 1 resources.

Relational Databases - 1 MCQs with Answers

Prepare for the Relational Databases - 1 within the Software Development exam with comprehensive MCQs and answers at EduRev. Our platform offers a wide range of practice papers, question papers, and mock tests to familiarize you with the exam pattern and syllabus. Access the best books, study materials, and notes curated by toppers to enhance your preparation. Stay updated with the exam date and receive expert preparation tips and paper analysis. Visit EduRev's official website today and access a wealth of videos and coaching resources to excel in your exam.

Online Tests for Relational Databases - 1 Database Management System (DBMS)

Practice with a wide array of question papers that follow the exam pattern and syllabus. Our platform offers a user-friendly interface, allowing you to track your progress and identify areas for improvement. Access detailed solutions and explanations for each test to enhance your understanding of concepts. With EduRev's Online Tests, you can build confidence, boost your performance, and ace Relational Databases - 1 with ease. Join thousands of successful students who have benefited from our trusted online resources.

Education Revolution