| 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 |