Question Bank: Structured Query Language (SQL

What does SQL stand for?

Which of the following is a feature of SQL?

What type of database management system is MySQL?

What is a primary function of SQL?

Which SQL statement is used to retrieve data from a database?

In SQL, which keyword is used to add a new record to a table?

What advantage does SQL provide in data retrieval compared to traditional programming?

What is the effect of the command 'DELETE FROM table_name WHERE condition'?

Which SQL statement is used to modify existing data?

What does the SQL command 'CREATE TABLE' do?

Which of the following describes SQL statements?

Which clause is used to group rows with the same values in SQL?

What is a common application of SQL?

Which term describes the rules that affect the validity of data in SQL?

When using SQL, what does 'DDL' stand for?

What is the correct SQL command to create a table named STUDENT?

Which SQL statement is used to retrieve all records from a table?

What does the SQL command 'DESCRIBE STUDENT;' do?

What is the purpose of the WHERE clause in SQL?

How would you retrieve the average price of cars modeled 'LXI' from the inventory?

What is the result of the SQL command 'SELECT COUNT(DISTINCT Model) FROM INVENTORY;'?

In SQL, what is a primary key?

Which of the following SQL statements will group rows with the same values in a specified column?

What SQL clause is used to filter records after grouping?

Which is a valid SQL statement for adding a new column named 'Email' of type VARCHAR to an existing table named 'EMPLOYEE'?

What will happen if you attempt to insert a record into a table with a PRIMARY KEY that already exists?

When would you use the command 'SELECT SName, SDateofBirth FROM STUDENT WHERE RollNumber = 1;'?

What is the result of executing 'SELECT * FROM EMPLOYEE WHERE DeptId IS NULL;'?

Which SQL command is used to remove all records from a table without deleting the table itself?

When using the GROUP BY clause, what does the HAVING clause accomplish?

Which SQL statement is used to create a new database?

What does the NOT NULL constraint ensure?

Which SQL command is used to modify an existing table?

Which of the following ensures that all values in a column are distinct?

What is the purpose of the PRIMARY KEY constraint?

Which two constraints must be combined to create a PRIMARY KEY?

Which datatype is used for text strings in MySQL?

What does the CREATE TABLE statement do in SQL?

Which of the following SQL commands is correct to delete a table?

In SQL, what is the purpose of the FOREIGN KEY constraint?

Which of the following data types would best suit an integer value?

What is the main function of the DEFAULT constraint in SQL?

What does the command ALTER TABLE table_name ADD column_name datatype do?

If a PRIMARY KEY is defined on a column, which of the following is true?

What does the INT data type represent in MySQL?

Which of the following constraints ensures that a column cannot have NULL values?

What is the maximum storage length for a VARCHAR data type in MySQL?

Which of the following is true about the CHAR data type?

What constraint can be used to ensure all values in a column are distinct?

What do the terms 'FOREIGN KEY' and 'PRIMARY KEY' signify in a relational database?

Which MySQL data type is suitable for storing dates?

What happens if a UNIQUE constraint is violated?

In MySQL, what is the purpose of using a DEFAULT constraint?

If an attribute is defined with a PRIMARY KEY and NOT NULL constraints, what does it imply?

Which data type can store a number with decimals in MySQL?

What storage requirement does the BIGINT data type have in MySQL?

What is indicated by a column with a NOT NULL constraint?

What will happen if you attempt to insert a duplicate value into a column defined with a UNIQUE constraint?

Which command would you use to create a database in MySQL?

Which constraint allows for linking records between two tables?

What does a VARCHAR(n) declaration do?

Which SQL command is used to add new records to a table?

What does the DELETE statement do in SQL?

What must be ensured before inserting a record with a foreign key?

Which statement is correct regarding the INSERT INTO command?

How is a table permanently removed in SQL?

Which statement will update the GAddress of a guardian in the GUARDIAN table?

In SQL, which clause is used to specify which records to retrieve?

What will happen if you use the DELETE statement without a WHERE clause?

Which command is used to change existing records in a table?

What will the command 'SELECT * FROM GUARDIAN;' return?

Which of the following statements is true regarding data manipulation in SQL?

Which SQL command would you use to remove a specific record from the GUARDIAN table where GUID = '444444444444'?

When using the UPDATE command, which clause is essential?

What is the function of the GROUP BY clause in SQL?

If a record with a unique constraint is attempted to be inserted with a duplicate value, what will happen?

What is the purpose of the SELECT statement in SQL?

Which SQL clause is used to filter records based on specific conditions?

What will be the output of the following SQL query: SELECT * FROM Students WHERE RollNumber = 5?

Which SQL keyword is used to sort the result set?

What will the query 'SELECT SName FROM STUDENT WHERE SDateofBirth IS NULL;' return?

Which of the following statements is true about SQL?

What does the DISTINCT keyword do in a SQL query?

What will happen if you run the query 'SELECT * FROM STUDENT LIMIT 10'?

Which SQL statement correctly retrieves all columns from the 'Courses' table?

In an SQL SELECT statement, which clause specifies the table to retrieve records from?

If two students have the same RollNumber, what will happen when inserting a new student with that RollNumber?

In SQL, what is the function of the GROUP BY clause?

What SQL command is used to modify existing records in a table?

Which SQL function can get the total number of records in a table?

What type of SQL join returns all records from one table and only the matching records from the other?

What is the main purpose of the POWER() function in SQL?

Which of the following is a valid syntax for the ROUND() function?

What does the MOD() function do in SQL?

Which function would you use to find the minimum value in a column?

If you want to calculate the average price of cars, which SQL function should you use?

What type of function is COUNT() classified as?

Which of the following types of functions can be used in a WHERE clause?

What output does the function DAYNAME('2022-10-01') return?

What is the main purpose of the GROUP BY clause in SQL?

In SQL, which function would you use to combine string values?

Which SQL query will correctly calculate the total sales grouped by each employee ID?

Which SQL statement correctly retrieves the maximum price from the inventory?

What happens when you use GROUP BY without an aggregate function in your SQL query?

What does the function COUNT(*) specifically do?

In which scenario would you most likely use the HAVING clause with GROUP BY?

Which of the following functions is used to round off a number to a whole integer?

What is the result of the following query? SELECT EmpID, COUNT(*) FROM SALE GROUP BY EmpID;

Which SQL aggregate function cannot be used in the context of a WHERE clause?

How can you find the maximum sale price for each employee using SQL?

What would be the output of: SELECT ROUND(123.456, 0);?

Which SQL clause is used to apply a filter on the results of a GROUP BY query?

How do you find the average sale price from the Sale table?

If you want to group data by two or more columns, how would you write the SQL query?

What does the COUNT(DISTINCT column_name) function do?

Which statement correctly uses the GROUP BY clause along with HAVING?

When is it appropriate to use GROUP BY with aggregate functions?

Which of the following could be a reason if your GROUP BY query returns fewer rows than expected?

What data type should be used for columns that will be grouped and counted?

Which SQL statement would return the average sale price for each employee, requiring grouping?

What does the UNION operation do in SQL?

What is the purpose of the Cartesian product in SQL when using two tables?

When can UNION operation be applied?

In SQL, when using two tables in a JOIN operation, which condition is typically specified?

What will the result of the INTERSECT operation return?

Which SQL statement would correctly use aliases for two tables DANCE and MUSIC?

Which operation would you use to find rows in the first table that are not in the second?

Which of the following SQL statements demonstrates a correct JOIN between two tables?

If the result of a UNION operation contains 5 rows from Table A and 3 from Table B, but 2 rows are common, how many rows will the result contain?

What happens if no condition is specified in a JOIN operation between two tables?

Which of the following is NOT a valid SQL operation for relations?

Which SQL command will filter results from a Cartesian product of tables A and B to show rows where attribute X is equal in both?

In SQL, which operation retrieves unique entries from two combined tables?

In which situation would you use a LEFT JOIN rather than an INNER JOIN?

What will happen if you try to perform INTERSECT on tables with no common rows?

Assuming tables DANCE and MUSIC exist, what does the SQL command 'SELECT D.Name, M.Audio FROM DANCE D JOIN MUSIC M ON D.Name = M.Name;' do?

In terms of operations on relations, what represents a merged list with potential duplicates?

What is one of the key differences between INNER JOIN and OUTER JOIN?

If relation A has columns (ID, Name) and relation B has columns (ID, Age), which operation cannot be performed directly?

If two tables, STUDENTS and COURSES, are joined without a specified JOIN condition, what will the result be?

Which of the following can be considered the opposite of the INTERSECT operation?

Which of the following statements correctly describes a foreign key relationship in the context of JOIN?

If Table 1 has 3 records and Table 2 has 5 records with 1 common record, what will the result of Table 1 INTERSECT Table 2 be?

What will be the effect of using the DISTINCT keyword in a query that joins two tables?

Which SQL statement will return all combinations of the tuples of tables A and B?

What is necessary to use when specifying a join condition?

When using a self-join, what must be done differently concerning the table reference?