| 21 |
Which of these is a DDL command? |
Computer Science/Informatics Practices
SQL and MySQL basics |
Easy |
| 22 |
Which constraint supplies a value for a column automatically when none is given during INSERT? |
Computer Science/Informatics Practices
SQL and MySQL basics |
Easy |
| 23 |
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 |
| 24 |
Why is SQL described as a non-procedural language? |
Computer Science/Informatics Practices
SQL and MySQL basics |
Medium |
| 25 |
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 |
| 26 |
Which command removes a table along with its structure from the database? |
Computer Science/Informatics Practices
DDL commands |
Easy |
| 27 |
Which statement adds a column Fees of type FLOAT to the table Student? |
Computer Science/Informatics Practices
DDL commands |
Easy |
| 28 |
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 |
| 29 |
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 |
| 30 |
A student runs DELETE FROM Marks; and then DESCRIBE Marks;. What is the result? |
Computer Science/Informatics Practices
DDL commands |
Hard |
| 31 |
Which query lists names of students whose names start with the letter S? |
Computer Science/Informatics Practices
DML and queries |
Easy |
| 32 |
Which clause is used to show only one copy of each repeated city? |
Computer Science/Informatics Practices
DML and queries |
Easy |
| 33 |
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 |
| 34 |
Which condition correctly finds students whose phone number has not been entered? |
Computer Science/Informatics Practices
DML and queries |
Medium |
| 35 |
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 |
| 36 |
What does SELECT MOD(29, 6); return? |
Computer Science/Informatics Practices
Math and text functions |
Easy |
| 37 |
What is the output of SELECT LEFT('NETWORK', 3);? |
Computer Science/Informatics Practices
Math and text functions |
Easy |
| 38 |
What does SELECT SUBSTRING('INFORMATICS', 3, 4); return? |
Computer Science/Informatics Practices
Math and text functions |
Medium |
| 39 |
What does SELECT ROUND(3478.56, -2); return? |
Computer Science/Informatics Practices
Math and text functions |
Medium |
| 40 |
What is the output of SELECT INSTR('MISSISSIPPI', 'SS') + LENGTH(TRIM(' AB '));? |
Computer Science/Informatics Practices
Math and text functions |
Hard |