Search Header Logo

ISYS6892003

Authored by nur anisa

Information Technology (IT)

University

Used 1+ times

ISYS6892003
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is a subquery?

A type of join

A query within another query

A view definition

A sequence generator

A synonym

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which query finds names that end with 'son'?

SELECT * FROM employees WHERE name LIKE '%son%';

SELECT * FROM employees WHERE name LIKE 'son%';

SELECT * FROM employees WHERE name REGEXP_LIKE(name, 'son$');

SELECT * FROM employees WHERE name LIKE '%son';

SELECT * FROM employees WHERE name IN 'son';

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following best defines a view?

A virtual table based on a query

A physical copy of a table

A stored procedure

A trigger function

A synonym for a column

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which query performs an inner join between orders and customers on customer_id?

SELECT * FROM orders JOIN customers ON orders.id = customers.id;

SELECT * FROM orders FULL JOIN customers;

SELECT * FROM orders NATURAL JOIN customers;

SELECT * FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;

SELECT * FROM orders, customers WHERE orders.id = customers.id;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the UPPER function do in SQL?

Converts all characters to lowercase

Capitalizes the first letter of each word

Removes spaces from a string

Converts all characters to uppercase

Replaces NULL values

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which query creates a sequence starting at 100 and incrementing by 10?

CREATE SYNONYM seq_id FOR 100 INCREMENT 10;

CREATE SEQUENCE seq_id START WITH 100 INCREMENT BY 10;

SEQUENCE seq_id BEGIN 100 STEP 10;

CREATE SEQUENCE seq_id VALUES 100 TO 1000;

START SEQUENCE seq_id AT 100 BY 10;

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which group function returns the highest value in a column?

MIN

AVG

SUM

MAX

COUNT

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?