| 41 |
What does SELECT MONTH('2023-11-05'); return? |
Computer Science/Informatics Practices
Date functions |
Easy |
| 42 |
Which function returns the name of the weekday for a given date? |
Computer Science/Informatics Practices
Date functions |
Easy |
| 43 |
What is returned by SELECT DATE('2022-07-19 16:45:10');? |
Computer Science/Informatics Practices
Date functions |
Medium |
| 44 |
Which query lists employees who joined in the month of March of any year, from table Emp with column DOJ? |
Computer Science/Informatics Practices
Date functions |
Medium |
| 45 |
What is the output of SELECT DAY('2024-02-29') + MONTH('2024-02-29');? |
Computer Science/Informatics Practices
Date functions |
Hard |
| 46 |
Which function counts all rows of a table, including rows with NULL values? |
Computer Science/Informatics Practices
Aggregate functions and grouping |
Easy |
| 47 |
Which clause is used to apply a condition on groups formed by GROUP BY? |
Computer Science/Informatics Practices
Aggregate functions and grouping |
Easy |
| 48 |
Column Bonus has the values 100, NULL, 300 and NULL. What does SELECT AVG(Bonus) return? |
Computer Science/Informatics Practices
Aggregate functions and grouping |
Medium |
| 49 |
Table Emp has Dept values A, B, A, C, B, A. How many rows does SELECT Dept, COUNT(*) FROM Emp GROUP BY Dept H… |
Computer Science/Informatics Practices
Aggregate functions and grouping |
Medium |
| 50 |
Which query is valid in SQL for finding departments whose total salary exceeds 50000, considering only employ… |
Computer Science/Informatics Practices
Aggregate functions and grouping |
Hard |
| 51 |
Table A has 4 rows and 3 columns; table B has 5 rows and 2 columns. How many rows does SELECT * FROM A, B; re… |
Computer Science/Informatics Practices
Operations on relations |
Easy |
| 52 |
Which set operation returns the rows of the first query that do not appear in the second? |
Computer Science/Informatics Practices
Operations on relations |
Easy |
| 53 |
Query 1 returns the cities Delhi, Pune, Agra and query 2 returns Pune, Agra, Goa. How many rows does query1 U… |
Computer Science/Informatics Practices
Operations on relations |
Medium |
| 54 |
Emp(EmpNo, Name, DeptNo) and Dept(DeptNo, DName) are combined with NATURAL JOIN. How many columns does the re… |
Computer Science/Informatics Practices
Operations on relations |
Medium |
| 55 |
Which statement about an equi-join of Emp and Dept on DeptNo is correct? |
Computer Science/Informatics Practices
Operations on relations |
Hard |
| 56 |
Which network type is formed by a smartphone connected to wireless earphones and a smartwatch? |
Computer Science/Informatics Practices
Introduction to networks |
Easy |
| 57 |
Which early network, started in 1969, is regarded as the forerunner of the Internet? |
Computer Science/Informatics Practices
Introduction to networks |
Easy |
| 58 |
A company links the computers in its head office in Mumbai with its branch offices in Chennai and Kolkata. Wh… |
Computer Science/Informatics Practices
Introduction to networks |
Medium |
| 59 |
Computers in the labs and library of a single school campus are connected to share a printer. This network is… |
Computer Science/Informatics Practices
Introduction to networks |
Medium |
| 60 |
Which statement comparing LAN and WAN is generally correct? |
Computer Science/Informatics Practices
Introduction to networks |
Hard |