HP Computer Practice Set 76 | Interactive MCQ Mock Test

1. If a table in a database has 500 tuples, what does this indicate about the data stored?

Computer 📄 JOA IT (2026)

A. There are 500 separate columns in the table B. There are 500 different attribute types in the table C. There are 500 individual records in the table D. There are 500 distinct tables in the database

2. If a table in a database has 500 tuples, what does this indicate about the data stored?

Computer 📄 JOA IT (2026)

A. There are 500 separate columns in the table B. There are 500 different attribute types in the table C. There are 500 individual records in the table D. There are 500 distinct tables in the database

3. If a table in a database has 500 tuples, what does this indicate about the data stored?

Computer 📄 JOA IT (2026)

A. There are 500 separate columns in the table B. There are 500 different attribute types in the table C. There are 500 individual records in the table D. There are 500 distinct tables in the database

4. If a table in a database has 500 tuples, what does this indicate about the data stored?

Computer 📄 JOA IT (2026)

A. There are 500 separate columns in the table B. There are 500 different attribute types in the table C. There are 500 individual records in the table D. There are 500 distinct tables in the database

5. If a table in a database has 500 tuples, what does this indicate about the data stored?

Computer 📄 JOA IT (2026)

A. There are 500 separate columns in the table B. There are 500 different attribute types in the table C. There are 500 individual records in the table D. There are 500 distinct tables in the database

6. If a table in a database has 500 tuples, what does this indicate about the data stored?

Computer 📄 JOA IT (2026)

A. There are 500 separate columns in the table B. There are 500 different attribute types in the table C. There are 500 individual records in the table D. There are 500 distinct tables in the database

7. If a table in a database has 500 tuples, what does this indicate about the data stored?

Computer 📄 JOA IT (2026)

A. There are 500 separate columns in the table B. There are 500 different attribute types in the table C. There are 500 individual records in the table D. There are 500 distinct tables in the database

8. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

9. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

10. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

11. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

12. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

13. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

14. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

15. A company maintains a database of customer orders. Which SQL query would best identify the unique products purchased by customers during the last month?

Computer 📄 JOA IT (2026)

A. SELECT COUNT(DISTINCT product_id) FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30' B. SELECT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; C. SELECT DISTINCT product_id FROM orders WHERE order_date >= '2024-06-01' AND order_date <= '2024-06-30'; D. SELECT product_id FROM orders GROUP BY product_id HAVING order_date >= '2024-06-01' AND order_date <= '2024-06-30';

16. Which symbol is used to terminate a PHP statement?

Computer 📄 JOA IT (2026)