1/25The OR operator shows a record if any conditions listed are true. The AND operator shows a record if all of the conditions listed are true.
2/25Which SQL statement is applied for updating data in a database?
3/25What does the TRUNCATE TABLE do?
4/25Which of the terms below is used to describe a database that occupies magnetic storage in the terabyte range, as well as to describe a database that contains billons of table rows?
5/25Which of the following is an open standard application programming interface(API) for accessing a database?
6/25What is the purpose of constraints in SQL?
7/25How do you create an index on the 'EmployeeName' column of the 'Employees' table for faster queries?
8/25How can you lock a table 'Employees' for read and write operations to maintain data integrity?
9/25How do you update the 'Salary' column in the 'Employees' table for an employee with 'EmployeeID' 123 to 50000?
10/25How can you combine results from multiple SELECT statements in SQL?
11/25What is the result of executing a SQL statement that includes a WHERE clause with a non-existent value?
12/25In SQL, what does the 'BETWEEN' operator do?
13/25How do you rename a column 'EmployeeName' to 'FullName' in the 'Employees' table?
14/25Which SQL clause is used to filter the results of a GROUP BY operation?
15/25Which of the following is NOT a valid aggregate function in SQL?
16/25Which SQL statement is used to change the data type of a column in an existing table?
17/25Which statement is used to add a new row to a table in SQL?
18/25What is the primary purpose of the SQL 'INNER JOIN' clause?
19/25Which SQL clause is used to specify a condition while fetching data from a single table or joining multiple tables?
20/25Which statement correctly shows the use of an alias in SQL?
21/25Which SQL function is used to return the largest value of the selected column?
22/25Which of the following is a valid type of SQL join?
23/25What is the purpose of the 'GROUP BY' clause in SQL?
24/25Which SQL statement is used to return only distinct (different) values?
25/25In SQL, what is a subquery?
It seems you haven't answered any questions yet. Please provide your answers to proceed.