MySQL Questions
Q. A PRIMARY KEY constraint ensures that:
View SolutionQ. What is the purpose of the COUNT() aggregate function?
View SolutionQ. Which SQL statement is used to modify existing records in a table?
View SolutionQ. Which query would sort the results from the ‘Orders’ table by ‘OrderDate’ in descending order?
View SolutionQ. How would you select all employees from the ‘Employees’ table who are in the ‘Sales’ department OR the ‘Marketing’ department?
View SolutionQ. You need to select all records from a ‘Products’ table where the price is exactly 19.99. What is the correct WHERE clause?
View SolutionQ. Which SQL keyword is used to add a new row of data into a table?
View SolutionQ. Which data type is most appropriate for storing a customer’s last name?
View SolutionQ. To retrieve all columns from a table named ‘Customers’, which query would you use?
View SolutionQ. Which SQL statement is used to create a new table in a database?
View Solution
Get Question Bank
Strengthen Your Practice with our comprehensive question bank.
