Oracle Database SQL Workshop

Oracle Database SQL Workshop

Professional Development

20 Qs

quiz-placeholder

Similar activities

Introduction to Routing

Introduction to Routing

Professional Development

15 Qs

What's in the Box?

What's in the Box?

Professional Development

17 Qs

Power BI - Data Transformation & Modeling

Power BI - Data Transformation & Modeling

Professional Development

15 Qs

Word 2019 - Tables

Word 2019 - Tables

Professional Development

15 Qs

Module 7770 Chapter G

Module 7770 Chapter G

Professional Development

17 Qs

SQL MASTERCLASS

SQL MASTERCLASS

Professional Development

20 Qs

Excel Basics

Excel Basics

Professional Development

20 Qs

PWC_SQL_Quiz

PWC_SQL_Quiz

Professional Development

20 Qs

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Assessment

Quiz

Professional Development

Professional Development

Hard

Created by

Rondi Hidayat

Used 49+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Identify the SELECT statements that execute successfully.

SELECT first_name, last_name, job_id, salary*12,

AS Yearly Sal

FROM employees;

SELECT first_name, last_name, job_id, salary*12

"yearly sal"

FROM employees;

SELECT first_name, last_name, job_id, salary AS

"yearly sal"

FROM employees;

SELECT first_name+last_name AS name, job_Id,

salary*12 yearly sal

FROM employees;

2.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which four of the following are valid operators for the WHERE clause?

>=

IS NULL

!=

IS LIKE

IN BETWEEN

3.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Which four of the following statements are true about single-row functions?

Manipulate data items

Accept arguments and return one value per argument

Act on each row that is returned

Can be nested

Accept arguments that can be a column or an expression

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.

True

False

5.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Identify the two guidelines for group functions and the GROUP BY clause.

You cannot use a column alias in the GROUP BY clause.

The GROUP BY column must be in the SELECT clause.

By using a WHERE clause, you can exclude rows before dividing them into groups.

The GROUP BY clause groups rows and ensures the order of the result set.

If you include a group function in a SELECT clause, you must include a GROUP BY

clause.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you join a table to itself, what kind of join are you using?

Left OUTER join

Right OUTER join

Full OUTER join

Self-join

Natural join

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using a subquery is equivalent to performing two sequential queries and using the result of the first query as the search values in the second query.

True

False

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?