Which of the following do you need to consider when you make a table in SQL?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
Data types
Primary keys
Default values
Category: SQL MCQs
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
all columns of the table are to be returned.
Well Done. Your Answer is Correct Keep it Up!
all records meeting the full criteria are to be returned.
all records with even partial criteria met are to be returned
None of the options are correct
The HAVING clause does which of the following?
The HAVING clause does which of the following?
Acts like a WHERE clause but is used for groups rather than rows.
Well Done. Your Answer is Correct Keep it Up!
Acts like a WHERE clause but is used for rows rather than columns.
Acts like a WHERE clause but is used for columns rather than groups.
Acts EXACTLY like a WHERE clause.
A subquery in an SQL SELECT statement is enclosed in:
A subquery in an SQL SELECT statement is enclosed in:
parenthesis — (…).
Well Done. Your Answer is Correct Keep it Up!
brackets — […].
CAPITAL LETTERS.
braces — {…}.
The result of a SQL SELECT statement is a ______
The result of a SQL SELECT statement is a ______
TABLE
Well Done. Your Answer is Correct Keep it Up!
REPORT
FILE
FORM
Which of the following must be enclosed in double-quotes?
Which of the following must be enclosed in double-quotes?
Column Alias
Well Done. Your Answer is Correct Keep it Up!
Dates
String
All options are correct
Which of the following command makes the updates performed by the transaction permanent in the database?
Which of the following command makes the updates performed by the transaction permanent in the database?
COMMIT
Well Done. Your Answer is Correct Keep it Up!
ROLLBACK
TRUNCATE
DELETE
The SQL statement – SELECT ROUND(45.926, -1) FROM DUAL;
The SQL statement – SELECT ROUND(45.926, -1) FROM DUAL;
prints 50
Well Done. Your Answer is Correct Keep it Up!
prints 045.926
prints garbage
is illegal
The SQL statement – SELECT SUBSTR(‘abcdefghij’, INSTR(‘123321234’, ‘2’, 3, 2), 2) FROM DUAL; Prints
The SQL statement – SELECT SUBSTR(‘abcdefghij’, INSTR(‘123321234’, ‘2’, 3, 2), 2) FROM DUAL; Prints
gh
Well Done. Your Answer is Correct Keep it Up!
23
bc
ab
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. So, What the below SQL statement will return: SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. So, What the below SQL statement will return: SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
9
Well Done. Your Answer is Correct Keep it Up!
5
10
0