SQL Queries - DDL

SQL Queries - DDL

Professional Development

15 Qs

quiz-placeholder

Similar activities

Galileo 1&2

Galileo 1&2

Professional Development

10 Qs

SQL Statements and Queries

SQL Statements and Queries

Professional Development

15 Qs

Filtering and Sorting

Filtering and Sorting

Professional Development

10 Qs

CodeMonkey Platform Management & Resources

CodeMonkey Platform Management & Resources

Professional Development

10 Qs

UWA School Counsellor Quiz

UWA School Counsellor Quiz

Professional Development

10 Qs

Pop Quiz EB1128

Pop Quiz EB1128

Professional Development

13 Qs

529 Call Center Final Knowledge Check

529 Call Center Final Knowledge Check

Professional Development

20 Qs

Career kick stater

Career kick stater

Professional Development

10 Qs

SQL Queries - DDL

SQL Queries - DDL

Assessment

Quiz

Professional Development, Education

Professional Development

Hard

Created by

Sree MK

Used 12+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What will be the output of this query?

SELECT * FROM employees;

Retrieve all rows in the employee database

Retrieve all rows from the employee table

Retrieve all columns from the employee database

Retrieve all columns from employee table

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Question 2

How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?

select first_name,last_name,hire_date, from employee;

select first_name,last_name and hire_date from employees;

Select first_name,last_name& hire_date from employees;

select first_name,last_name,hire_date from employees;

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of these SQL statements will select all the members with last names that start with capital letter "M" in the table member?

select * from member where last_name="M%";

select * from member where last_name="M-"

Select * from member where last_name="M"

select * from member where last_name like "M%"

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What will be the result of this query?

SELECT dept_name

FROM Departments

WHERE dept_no BETWEEN 'd003' AND 'd006';

Select all department name whose department number is not between d003 and d006;

select all department names whose department number is between d003 and d006;

select a list of all departments whose department number is between d003 and d006;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SELECT statement is a ...............in SQL

Data Control Language(DCL)

Transcation Control language(TCL)

Data Manipulation language(DML)

Data Definition language(DDL)

6.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

COUNT is a .................function

Aggregate

procedure

user-defined

Summarizing

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following is a valid SQL statement to select all the members who live in T from the table member?

select * from member

select * from member where state_abbravation="T"

select * from member where state_abbrevation=='T'

select * from member where state_abbravation is T

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?

Discover more resources for Professional Development