WCF-DSE-Q7

WCF-DSE-Q7

Professional Development

10 Qs

quiz-placeholder

Similar activities

Kuis IHT

Kuis IHT

Professional Development

11 Qs

MAP 101 - Review

MAP 101 - Review

Professional Development

10 Qs

Supply-PKT-August-1

Supply-PKT-August-1

Professional Development

15 Qs

Data Privacy

Data Privacy

Professional Development

10 Qs

FR - EPS (2022 - 23)

FR - EPS (2022 - 23)

Professional Development

12 Qs

Modern Office

Modern Office

Professional Development

15 Qs

IFI WP MIP Establish Integrity Program

IFI WP MIP Establish Integrity Program

Professional Development

10 Qs

Discover ASR

Discover ASR

Professional Development

13 Qs

WCF-DSE-Q7

WCF-DSE-Q7

Assessment

Quiz

Other

Professional Development

Practice Problem

Easy

Created by

Athma Madassery

Used 9+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Views are ____ tables that don't exist physically in Oracle.

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

One or more tables can be joined to create a ____.

view

variable

synonym

none of these

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A new user on the database is created by executing the following command:

SQL> CREATE USER user01 IDENTIFIED BY user01;

Then you granted the following privileges to user01 by executing the following command:

SQL> GRANT CREATE SESSION, CREATE TABLE TO user01;

Which of the following is correct in this scenario?

The user can create table

The user cannot query any tables

The user can not create tables

none of these

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

The ____ statement is used to modify the data in a table in SQL.

Insert

Update

Delete

Truncate

5.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Query to display the Employees name, salary and department id who earn a salary less than the average salaryof their respective department

Select first_name,salary,e.department_id from Employees e, (Select department_id,avg(salary) avgsal from Employees group by department_id) qr where e.salary < qr.avgsal

Select first_name,salary,e.department_id from Employees e, (Select department_id,avg(salary) avgsal from Employees group by department_id) qr where e.salary < qr.avgsal and e.department_id = qr.department_id

Select first_name,salary,e.department_id from Employees e, (Select department_id,avg(salary) avgsal from Employees ) qr where e.salary < qr.avgsal and e.department_id = qr.department_id/

none of these

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Fill in the blanks for the below query to rename the Employee table to Employees_TB

------  Employee to Employees_TB;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The ____ keyword is used to delete a record in a database in SQL.

Update

Delete

Remove

Clear

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?