Sql programming MCQ Questions

Post A Question

Classifications:

MCQ Questions Categories:

No collections found!

Which of the following do you need to consider when you make a table in SQL?
iconYasminRadwan26
2022-06-03
icon 1 answers
icon257 Views
icon0 Likes
The HAVING clause does which of the following?
iconYasminRadwan26
2022-06-03
icon 1 answers
icon282 Views
icon0 Likes
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
iconYasminRadwan26
2022-06-03
icon 1 answers
icon256 Views
icon0 Likes
The result of a SQL SELECT statement is a ______
iconYasminRadwan26
2022-06-03
icon 1 answers
icon315 Views
icon0 Likes
A subquery in an SQL SELECT statement is enclosed in:
iconYasminRadwan26
2022-06-03
icon 1 answers
icon237 Views
icon0 Likes
Which of the following command makes the updates performed by the transaction permanent in the database?
iconYasminRadwan26
2022-06-03
icon 1 answers
icon254 Views
icon0 Likes
Which of the following must be enclosed in double-quotes?
iconYasminRadwan26
2022-06-03
icon 1 answers
icon329 Views
icon0 Likes
The SQL statement - SELECT ROUND(45.926, -1) FROM DUAL;
iconYasminRadwan26
2022-06-03
icon 1 answers
icon329 Views
icon0 Likes
The SQL statement - SELECT SUBSTR(\'abcdefghij\', INSTR(\'123321234\', \'2\', 3, 2), 2) FROM DUAL; Prints
iconYasminRadwan26
2022-06-03
icon 1 answers
icon272 Views
icon1 Likes
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE
iconYasminRadwan26
2022-06-03
icon 1 answers
icon303 Views
icon0 Likes
A SQL query will not work if there are no indexes on the relations - Is it true?
iconYasminRadwan26
2022-06-03
icon 1 answers
icon316 Views
icon0 Likes
Which data type can store unstructured data in a column?
iconYasminRadwan26
2022-06-03
icon 1 answers
icon296 Views
icon0 Likes
The COUNT function in SQL returns the number of _____
iconYasminRadwan26
2022-06-03
icon 1 answers
icon257 Views
icon0 Likes
Show More