DBMS Lab Quiz 1 2B3

As part of our ongoing efforts to improve our customer database, you've been tasked with adding a new column to the 'Customers' table to store email addresses. This will help us communicate with our customers more effectively. Which SQL statement should you use to accomplish this?

• ALTER TABLE Customers ADD Email VARCHAR(100);

• UPDATE Customers SET Email = '[e-mail]';

• CREATE COLUMN Email IN Customers;

• INSERT INTO Customers (Email) VALUES ('[e-mail]');

In your role as data analysts, you often work with a customer database that evolves over time to accommodate new information. Your manager has requested you to update the database by adding new attributes to an existing customer relation. Which of the following commands should you use to accomplish this task effectively?

• Alter

• Modify

• Tailor

• Eliminate

In the financial database you oversee, there's a need to periodically clear out all the transaction records from a particular table without generating extensive log entries for each deletion. This process ensures efficient data maintenance. Which SQL statement should you employ to achieve this specific task?

• DELETE

• DROP

• TRUNCATE

• REMOVE

You're working on a data analysis project, and your manager asks you to sort a list of products by their sales figures. However, in the SQL query you're about to write, you've accidentally omitted the ASC or DESC keyword after the ORDER BY clause. What will happen in this situation?

• DESC

• ASC

• Query will not run

• There is no default value

As part of your internship at our software development company, you'll be working with SQL databases. Think of SQL views as a way to create a virtual representation of specific data from our databases. These views simplify data access for reporting and analysis. What are SQL views commonly referred to as?

• Simple Tables

• Virtual Tables

• Complex Tables

• Actual Tables

Let's say you're a librarian managing a library database, and you need to find all books that belong to a specific genre from a long list. You want to compare the genre of each book to a provided list of genres. Which SQL operator should you use for this task?

• IN

• ALL

• BETWEEN

• ANY

As part of your data analysis work, you often encounter situations where you need to identify records in a dataset that lack certain information, like missing customer addresses in an e-commerce database. To accomplish this, you use a specific SQL operator. Which operator helps you test a column for the absence of data in such scenarios?

• NOT operator

• EXISTS operator

• IS NULL operator

• ! (NOT operator)

As a database administrator, you oversee a comprehensive database used to store vital company data. However, you've received instructions to permanently eliminate the entire database, including all its related components, such as tables, views, and stored procedures. Which SQL statement should you use to carry out this task?

• DROP Database

• DELETE Database

• REMOVE Database

• None of these

As part of our annual salary adjustments, we need to update the 'Salary' column for all employees in the 'Employees' table who belong to the 'HR' department. This ensures that our HR team is fairly compensated. Which SQL statement should you use to accomplish this?

• UPDATE Employees SET Salary = 55000 WHERE Department = 'HR';

• INSERT INTO Employees (Salary) VALUES (55000) WHERE Department = 'HR';

• DELETE FROM Employees WHERE Department = 'HR';

• SELECT * FROM Employees WHERE Department = 'HR';

As part of your role as a database developer, you are responsible for ensuring the integrity of the data in our company's employee database. This involves using various SQL constraints to maintain data quality. However, not all options provided are actual SQL constraints. Can you identify which one is not a constraint?

• Not Null

• Check

• Union

• Primary Key