Question
Which of the following SQL queries is used to remove a
table from a database?Solution
The DROP statement is used to permanently remove a table from the database. When a table is dropped, the table structure, along with its data, is deleted, and it cannot be recovered. a) DELETE : DELETE is used to remove rows from a table, not the table structure itself. c) TRUNCATE : TRUNCATE removes all rows from a table but retains the table structure. d) ALTER : ALTER is used to modify the structure of an existing table, not remove it. e) REMOVE : REMOVE is not a valid SQL command.
A number lies between the cubes of 13 and 14. If the number is divisible by 6 as well as square of 16. Find the number.
- The digits of a two-digit number add up to 9. If 27 is subtracted from the number, the digits switch places. What is the number?
- How many numbers between 200 and 1000 are divisible by both 20 and 30?
A two-digit number has a sum of its digits equal to 12. Additionally, if 45 is subtracted from this number, the resulting number has its digits reversed...
Which of the following numbers is divisible by 11?
Three pairwise co-prime natural numbers have the following property: The product of the first and second numbers is 210, and the ...
How many terms are there in the geometric progression 7, 14, 28, ......, 14336?
Find the third proportion of 32 and 16.
The average of 9 consecutive integers is 23. What is the sum of the smallest three integers?
Find the remainder when 2β΅ is divided by 7.