| 2501 |
Relation R has degree 3 and cardinality 4; relation S has degree 2 and cardinality 5. What are the degree and… |
Computer Science/Informatics Practices
Relational algebra |
Easy |
| 2502 |
A has 6 tuples and B has 4 tuples; 3 tuples are common and both are union compatible. How many tuples are in … |
Computer Science/Informatics Practices
Relational algebra |
Medium |
| 2503 |
For union compatible relations A and B, what does A − B return? |
Computer Science/Informatics Practices
Relational algebra |
Medium |
| 2504 |
Which statement about union compatibility is correct? |
Computer Science/Informatics Practices
Relational algebra |
Hard |
| 2505 |
Which of these is a DDL command? |
Computer Science/Informatics Practices
SQL and MySQL basics |
Easy |
| 2506 |
Which constraint supplies a value for a column automatically when none is given during INSERT? |
Computer Science/Informatics Practices
SQL and MySQL basics |
Easy |
| 2507 |
A column is declared CHAR(10) and the value 'RAVI' is stored. How many characters of storage does the value o… |
Computer Science/Informatics Practices
SQL and MySQL basics |
Medium |
| 2508 |
Why is SQL described as a non-procedural language? |
Computer Science/Informatics Practices
SQL and MySQL basics |
Medium |
| 2509 |
A column Email has a UNIQUE constraint but no NOT NULL constraint. Which statement is correct? |
Computer Science/Informatics Practices
SQL and MySQL basics |
Hard |
| 2510 |
Which command removes a table along with its structure from the database? |
Computer Science/Informatics Practices
DDL commands |
Easy |
| 2511 |
Which statement adds a column Fees of type FLOAT to the table Student? |
Computer Science/Informatics Practices
DDL commands |
Easy |
| 2512 |
The Name column of Student is VARCHAR(20) and must be increased to VARCHAR(50). Which clause of ALTER TABLE i… |
Computer Science/Informatics Practices
DDL commands |
Medium |
| 2513 |
After ALTER TABLE Student ADD City VARCHAR(20); is run on a table that already has 8 rows, what value does Ci… |
Computer Science/Informatics Practices
DDL commands |
Medium |
| 2514 |
A student runs DELETE FROM Marks; and then DESCRIBE Marks;. What is the result? |
Computer Science/Informatics Practices
DDL commands |
Hard |
| 2515 |
Which query lists names of students whose names start with the letter S? |
Computer Science/Informatics Practices
DML and queries |
Easy |
| 2516 |
Which clause is used to show only one copy of each repeated city? |
Computer Science/Informatics Practices
DML and queries |
Easy |
| 2517 |
Marks values in a table are 40, 50, 65, 80 and 90. How many rows does WHERE Marks BETWEEN 50 AND 80 return? |
Computer Science/Informatics Practices
DML and queries |
Medium |
| 2518 |
Which condition correctly finds students whose phone number has not been entered? |
Computer Science/Informatics Practices
DML and queries |
Medium |
| 2519 |
Table Emp has 10 rows, 4 of which have Dept = 'HR'. A user meant to run UPDATE Emp SET Bonus = 500 WHERE Dept… |
Computer Science/Informatics Practices
DML and queries |
Hard |
| 2520 |
What does SELECT MOD(29, 6); return? |
Computer Science/Informatics Practices
Math and text functions |
Easy |
| 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 |
| 2541 |
Which early network, started in 1969, is regarded as the forerunner of the Internet? |
Computer Science/Informatics Practices
Introduction to networks |
Easy |
| 2542 |
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 |
| 2543 |
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 |
| 2544 |
Which statement comparing LAN and WAN is generally correct? |
Computer Science/Informatics Practices
Introduction to networks |
Hard |
| 2545 |
Which device converts digital signals into analog signals and back? |
Computer Science/Informatics Practices
Network devices |
Easy |
| 2546 |
Which device regenerates a weak signal so that it can travel further? |
Computer Science/Informatics Practices
Network devices |
Easy |
| 2547 |
Which device sends incoming data only to the port of the intended computer instead of to all ports? |
Computer Science/Informatics Practices
Network devices |
Medium |
| 2548 |
A school wants to connect its computer lab LAN to the Internet and forward packets between the two networks. … |
Computer Science/Informatics Practices
Network devices |
Medium |
| 2549 |
Two networks that use entirely different communication protocols must exchange data. Which device performs th… |
Computer Science/Informatics Practices
Network devices |
Hard |
| 2550 |
In which topology are all nodes connected to a single central hub or switch? |
Computer Science/Informatics Practices
Network topologies |
Easy |