| 2521 |
What is the output of SELECT LEFT('NETWORK', 3);? |
Computer Science/Informatics Practices
Math and text functions |
Easy |
| 2522 |
What does SELECT SUBSTRING('INFORMATICS', 3, 4); return? |
Computer Science/Informatics Practices
Math and text functions |
Medium |
| 2523 |
What does SELECT ROUND(3478.56, -2); return? |
Computer Science/Informatics Practices
Math and text functions |
Medium |
| 2524 |
What is the output of SELECT INSTR('MISSISSIPPI', 'SS') + LENGTH(TRIM(' AB '));? |
Computer Science/Informatics Practices
Math and text functions |
Hard |
| 2525 |
What does SELECT MONTH('2023-11-05'); return? |
Computer Science/Informatics Practices
Date functions |
Easy |
| 2526 |
Which function returns the name of the weekday for a given date? |
Computer Science/Informatics Practices
Date functions |
Easy |
| 2527 |
What is returned by SELECT DATE('2022-07-19 16:45:10');? |
Computer Science/Informatics Practices
Date functions |
Medium |
| 2528 |
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 |
| 2529 |
What is the output of SELECT DAY('2024-02-29') + MONTH('2024-02-29');? |
Computer Science/Informatics Practices
Date functions |
Hard |
| 2530 |
Which function counts all rows of a table, including rows with NULL values? |
Computer Science/Informatics Practices
Aggregate functions and grouping |
Easy |
| 2531 |
Which clause is used to apply a condition on groups formed by GROUP BY? |
Computer Science/Informatics Practices
Aggregate functions and grouping |
Easy |
| 2532 |
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 |
| 2533 |
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 |
| 2534 |
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 |
| 2535 |
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 |
| 2536 |
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 |
| 2537 |
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 |
| 2538 |
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 |
| 2539 |
Which statement about an equi-join of Emp and Dept on DeptNo is correct? |
Computer Science/Informatics Practices
Operations on relations |
Hard |
| 2540 |
Which network type is formed by a smartphone connected to wireless earphones and a smartwatch? |
Computer Science/Informatics Practices
Introduction to networks |
Easy |