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 salaries WHERE emp_no = 20005 AND to_date = '9999-01-01';

SELECT salary FROM employees WHERE emp_no = 20005;

SELECT salary FROM salaries WHERE emp_no = 20005;

SELECT salary FROM dept_emp WHERE emp_no = 20005;

View this question

Find the job title of an employee

Which SQL query retrieves the title of an employee with emp_no = 30001?

SELECT title FROM salaries WHERE emp_no = 30001;

SELECT title FROM employees WHERE emp_no = 30001;

SELECT title FROM titles WHERE emp_no = 30001 AND to_date = '9999-01-01';

SELECT title FROM titles WHERE emp_no = 30001;

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

Find employees in a specific department

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

SELECT dept_no FROM employees WHERE dept_no = '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';

View this question

What is the purpose of the SQL CREATE DATABASE statement?

To delete an existing database

To modify an existing database

To create a new SQL database

To create a new table in an existing database

View this question

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

;

View this question

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

The type of data the column can hold

The primary key for the column

The name of the column

The default value of the column

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 join a table

To insert data into a table

To delete a table from a database

To create a new table in a database

View this question

1

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

Terms of Use Contact Us