MIS 202 2024 Spring Introduction to Database Quiz1

What is SQL and how is it used in databases?

• SQL is a language used to interact with databases by performing operations like querying, inserting, updating, and deleting data.

• SQL is a type of programming language used for web development

• SQL is primarily used for creating animations in databases

• SQL is only used for storing images in databases

Explain the concept of a database join.

• A database join is a method used to update rows from two or more tables based on a related column between them.

• A database join is a method used to separate rows from two or more tables based on an unrelated column between them.

• A database join is a method used to delete rows from two or more tables based on a related column between them.

• A database join is a method used to combine rows from two or more tables based on a related column between them.

Differentiate between DDL and DML in database management.

• DDL is for defining the structure of the database, while DML is for manipulating the data within the database.

• DDL is used for querying data, while DML is used for creating tables.

• DDL and DML are interchangeable terms in database management.

• DDL is for manipulating data, while DML is for defining the structure of the database.

Database applications are usually partitioned into tiers. According to the image we can say it is ........-tier architecture.

• One

• Two

• Three

• Four

According to the image, what is the equivalent of SQL syntax of this Relational Algebra Query?

• SELECT * FROM instructor;

• SELECT * FROM instructor WHERE dept_name='Physics';

• SELECT dept_name FROM instructor;

• SELECT * FROM dept_name WHERE instructor='Physics';

Explain the process of creating a database table using SQL.

• CREATE TABLE table_name (column1_name data_type, column2_name data_type, ...);

• ADD TABLE table_name (column1_name data_type, column2_name data_type, ...);

• CREATE DATABASE table_name;

• INSERT INTO table_name (column1_name, column2_name, ...) VALUES (value1, value2, ...);

What is the role of a primary key in a database table?

• A primary key is used to store duplicate values in a table

• A primary key is used to uniquely identify each record in a table

• A primary key is used to delete records from a table

• A primary key is used to retrieve data from a table

What is the role of a foreign key in a database table?

• A foreign key is used to store duplicate values in a table

• A foreign key is used to uniquely identify each record in a table

• A foreign key is used to establish a relationship between two tables

• A foreign key is used to retrieve data from a table

I want to find the names of all instructors whose name INCLUDES the substring “dar”

Which one is CORRECT select query?

• select name from instructor where name = '%dar%'

• 
  select name from instructor where name like 'dar%'

• select name from instructor where name like '%dar%'

• select name from instructor where name in '%dar%'

Find the total number of instructors who teach a course in the Spring 2024 semester

• select count (*) from teaches where semester = 'Spring' and year = 2024;

• select max(distinct ID) from teaches where semester = 'Spring' and year = 2024;

• select Id from teaches where semester = 'Spring' and year = 2024;

• select avg(*) from teaches where semester = 'Spring' and year = 2024;