
SQL Queries - DDL

Quiz
•
Professional Development, Education
•
Professional Development
•
Hard
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
Similar Resources on Wayground
20 questions
Type3 Quiz

Quiz
•
Professional Development
13 questions
Trivia Take-Away

Quiz
•
Professional Development
17 questions
Nexa HealthCare

Quiz
•
Professional Development
11 questions
Characteristics of a Checks

Quiz
•
Professional Development
14 questions
Training Quiz - 5

Quiz
•
Professional Development
20 questions
HIPAA Security and Privacy Training

Quiz
•
University - Professi...
10 questions
Paytm revision Part 3

Quiz
•
Professional Development
10 questions
Data and review

Quiz
•
Professional Development
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade