Crowdly

Add to Chrome

Universities
lms.musteducation.tn
CS 231-G2 - Introduction to databases - Spring 2025

CS 231-G2 - Introduction to databases - Spring 2025

Looking for CS 231-G2 - Introduction to databases - Spring 2025 test answers and solutions? Browse our comprehensive collection of verified answers for CS 231-G2 - Introduction to databases - Spring 2025 at lms.musteducation.tn.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Retrieve the current salary of an employee

Which SQL query retrieves the current salary of an employee with emp_no = 20005?

SELECT salary FROM employees WHERE emp_no = 20005;

❌

SELECT salary FROM salaries WHERE emp_no = 20005;

❌

SELECT salary FROM salaries WHERE emp_no = 20005 AND to_date = '9999-01-01';

✅

SELECT salary FROM dept_emp WHERE emp_no = 20005;

❌

View this question

Find employees in a specific department

Which SQL query retrieves the employee numbers of all employees working in department 'd002'?

SELECT emp_no FROM dept_emp WHERE dept_no = 'd002';

✅

SELECT emp_no FROM departments WHERE dept_no = 'd002';

❌

SELECT emp_no FROM salaries WHERE dept_no = 'd002';

❌

SELECT dept_no FROM employees WHERE dept_no = 'd002';

❌

View this question

Retrieve employee birth dates

Which SQL query retrieves the birth date of the employee with emp_no = 10500?

SELECT birth_date FROM employees WHERE emp_no = 10500;

✅

SELECT birth_date FROM employees WHERE first_name = 'John';

❌

SELECT birth_date FROM salaries WHERE emp_no = 10500;

❌

SELECT emp_no FROM employees WHERE birth_date = '1990-05-10';

❌

View this question

What does the 'datatype' parameter in the CREATE TABLE statement specify?

The default value of the column

❌

The name of the column

❌

The type of data the column can hold

✅

The primary key for the column

❌

View this question

What is the purpose of the SQL CREATE DATABASE statement?

To modify an existing database

To create a new table in an existing database

To delete an existing database

To create a new SQL database

View this question

Write the correct SQL statement to create a new database called testDB.

;

View this question

Which of the following SQL statements will create a table named 'Books' with columns for ID, Title, and Author?

CREATE Books TABLE (ID int, Title varchar(255), Author varchar(255));

❌

CREATE DATABASE TABLE (Books) (ID int, Title varchar(255), Author varchar(255));

❌

CREATE TABLE Books (ID int, Title varchar(255), Author varchar(255));

✅

CREATE TABLE (Books) (ID int, Title varchar(255), Author varchar(255));

❌

View this question

Write the correct SQL statement to create a new table called Persons.

(
  PersonID int,
  LastName varchar(255),
  FirstName varchar(255),
  Address varchar(255),
  City varchar(255) 
);

View this question

What is the primary purpose of the SQL CREATE TABLE statement?

To delete a table from a database

To create a new table in a database

To insert data into a table

To join a table

View this question

Want instant access to all verified answers on lms.musteducation.tn?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Add to Chrome