Class 12
Information Technology (802)
351 questions available
Refine
All questions
351 resultsWhich command is used to insert a new tuple into a relation?
Show answer
Evaluate the Java relational expression: 3 < 1
Show answer
If an attribute value is not explicitly specified in an INSERT command and it has no DEFAULT value defined, what value is used?
Show answer
Evaluate the Java relational expression: 11 == 10
Show answer
Which command is used to modify the value(s) of one or more tuples in a table?
Show answer
Evaluate the Java relational expression: 8 != 3
Show answer
Which command deletes ALL tuples from a table if the WHERE clause is omitted?
Show answer
Evaluate the Java relational expression: 30 >= 30
Show answer
What is the basic structure of the SELECT command?
Show answer
Evaluate the Java relational expression: 2 > 5
Show answer
A query that joins two tables WITHOUT any join condition in the WHERE clause, producing a Cartesian product of all rows, is called a:
Show answer
Evaluate the Java logical expression: (7 > 3) && (2 < 5)
Show answer
If Teacher has 14 rows and Department has 9 rows, how many rows result from a Cross Join (SELECT ... FROM Teacher, Department with no WHERE clause)?
Show answer
Evaluate the Java logical expression: (7 > 3) && (2 > 5)
Show answer
When the same attribute name (e.g., Dept_ID) exists in both joined tables, ambiguity is resolved by:
Show answer
Evaluate the Java logical expression: (1 > 2) || (3 < 4)
Show answer
Aliases for table names in SQL are created using which keyword?
Show answer
Evaluate the Java logical expression: (1 > 2) || (3 > 4)
Show answer
Which keyword eliminates duplicate values from a query's result set?
Show answer
Evaluate the Java logical expression: !(6 > 2)