Question Bank: Introduction to Structured Query Language (SQL)

What does SQL stand for?

Which of the following is a relational database management system?

In SQL, which command is used to extract data from a database?

What is the purpose of the WHERE clause in SQL?

Which SQL statement is used to update existing data in a table?

What is a primary key in a database?

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

Which keyword would you use to remove a row from a table?

In SQL, which operator is used to filter records within a certain range?

What is the purpose of the DISTINCT keyword in SQL?

What is a foreign key?

Which SQL statement is used to create a new table?

What data type would you use to store a date in MySQL?

What does the ORDER BY clause do in an SQL query?

What is the use of the LIKE operator in SQL?

Which command would modify an attribute of an existing table in SQL?

What happens when you execute a SELECT query without a WHERE clause?

What type of data does the INT data type hold in MySQL?

Which data type is suitable for storing a postal code of fixed length?

What does the NOT NULL constraint enforce in a table column?

How much storage does the FLOAT data type occupy in MySQL?

What does the UNIQUE constraint ensure for a column in a table?

For which of the following would you typically use the DATE data type?

What is the main feature of the VARCHAR data type in MySQL?

Which of the following is NOT a valid SQL constraint?

If you want to ensure a column can reference a primary key from another table, which constraint should you use?

What will happen if you attempt to insert NULL into a NOT NULL column?

Which data type would you choose for precise monetary values?

Which data type allows storing up to 65535 characters?

What type of constraints can form a composite primary key?

When defining a column with a DEFAULT constraint, what happens if no value is supplied during insertion?

What is the purpose of defining constraints on data types in MySQL?

What is the maximum length for the CHAR data type in MySQL?

Which of the following SQL statements is used to extract information from a database?

What keyword is used to sort the results returned by a SQL query?

How do you insert a new record into the STUDENT table with a NULL GUID?

What will the following SQL command do: SELECT DISTINCT SName FROM STUDENT?

Which SQL clause is used to specify conditions when retrieving data?

In SQL, what operator is used to check for a NULL value?

What will be the output of the query SELECT * FROM EMPLOYEE WHERE Salary > 30000?

How can you rename a column in the result set of a SQL query?

What does the SQL command 'DROP TABLE' do?

If you want to obtain a list of employees not in departments D01 or D02, which SQL statement would you use?

What is the purpose of the SQL command 'GROUP BY'?

Which SQL statement is used to modify existing data in a database table?

In SQL, which clause would you use to limit the results returned to a specific number of records?

Which of the following statements will correctly display the annual salary of employees?

What will be the output of: SELECT COUNT(*) FROM EMPLOYEE WHERE Salary > 35000?

What is the first step in creating a database using SQL?

Which statement is used to create a table in SQL?

Which data type is used for storing whole numbers in SQL?

What constraint ensures that a column value cannot be NULL?

Which of the following SQL statements is used to select a database?

What will the command 'SHOW TABLES;' return if no tables exist in the database?

What is a primary key in SQL?

Which statement accurately describes constraints in SQL?

What does the keyword 'DEFAULT' specify in a table definition?

In SQL, what is the purpose of the 'CREATE DATABASE' command?

Which SQL command is used to delete a table?

How can you alter an existing table structure in SQL?

Which command can be used to ensure unique values in a column?

What is the purpose of a foreign key in a database?

Which SQL statement would you use to create a PRIMARY KEY?

When is it appropriate to use the 'NOT NULL' constraint?

What SQL statement is used to insert new records into a table?

Which of the following is the correct syntax to insert a new record into a table named 'STUDENTS'?

If you want to insert a record but specify only some of the columns, how should the statement be formatted?

What will happen if you try to insert a record with a value for a foreign key that does not exist in the referenced table?

Which SQL statement is used to permanently remove a table from a database?

In the context of SQL, what does the term 'data manipulation' refer to?

Which SQL command will update records in a table?

What SQL statement would you use to retrieve all records from a table named 'ATTENDANCE'?

In SQL, if you need to remove specific records from a table, which clause should you use with the DELETE statement?

To ensure data integrity when inserting a new record, what should you do?

When using the INSERT INTO statement, how do you indicate that some attributes will receive default values?

What does the semicolon signify at the end of an SQL statement?

Which data command would allow you to change values for existing records in a table?

Under what circumstance would you receive an error when executing an INSERT statement?

What is the consequence of using the DROP statement on a database?

If you attempt to execute an UPDATE command without a WHERE clause, what will happen?

What is the purpose of the SELECT statement in SQL?

Which clause in a SQL query specifies the table to retrieve data from?

What does the WHERE clause do in a SQL SELECT statement?

In SQL, how do you specify multiple conditions in a WHERE clause?

What is the default sorting order of the results in a SQL query when no ORDER BY clause is specified?

Which SQL statement would be used to retrieve the names of students born after January 1, 2000?

What is the correct way to write a SQL statement to insert a new student record?

Which SQL function removes duplicates from the results set?

If you want to count the number of records in SQL, which function would you use?

What is the result of executing 'SELECT * FROM STUDENT;', if there are no records in the STUDENT table?

Which command will update the name of a student with RollNumber 1 to 'Alex Smith'?

Which SQL clause is used to group rows that have the same values in specified columns?

What error occurs if the INSERT statement tries to add a new record with a duplicate primary key?

Which command will permanently remove data from a table?

Which SQL statement is used to modify existing records in a table?

What is the risk of executing an UPDATE statement without a WHERE clause?

Which clause is typically used with the DELETE statement?

What result will the following SQL command produce? DELETE FROM EMPLOYEES WHERE EmpID = 10;

In the SQL statement UPDATE Employees SET Salary = Salary * 1.1 WHERE Dept = 'Sales'; what does 'Salary = Salary * 1.1' do?

What does the command SELECT * FROM STUDENT WHERE RollNumber = 3; return?

If the GUID of students with RollNumber 3 and RollNumber 5 are to be updated, which SQL statement is correct?

What SQL keyword is used to identify the records to delete from a table?

Which statement will not update a record correctly?

What will happen if you run DELETE FROM CUSTOMERS; without a WHERE clause?

If you wanted to delete records of students not enrolled in any classes, which SQL statement would you use?

In an UPDATE statement, which of the following represents an attribute?

Which SQL command is used to permanently remove data from a table?

When updating multiple columns, which syntax is valid?

What will be the outcome of the command? UPDATE STUDENT SET Age = Age + 1 WHERE RollNumber = 3;