Advanced SQL

Advanced SQL

KG - University

10 Qs

quiz-placeholder

Similar activities

BTEC Level 3 Nat Ext Dip in Computing - Unit 2.1 Hardware and Software

BTEC Level 3 Nat Ext Dip in Computing - Unit 2.1 Hardware and Software

11th - 12th Grade

10 Qs

EmTech Q2 Post Test 2

EmTech Q2 Post Test 2

11th Grade

15 Qs

Unit 28 - Quiz #1

Unit 28 - Quiz #1

University

15 Qs

Quiz CodeIgniter 4

Quiz CodeIgniter 4

University

10 Qs

KS3_Data Representations (from clay to silicon)

KS3_Data Representations (from clay to silicon)

1st - 3rd Grade

15 Qs

CLASS 7 COMPUTER CH-3 QUIZ

CLASS 7 COMPUTER CH-3 QUIZ

7th Grade

11 Qs

Gr3-Scratch - Revision

Gr3-Scratch - Revision

3rd - 5th Grade

11 Qs

Advanced SQL

Advanced SQL

Assessment

Quiz

Computers

KG - University

Practice Problem

Hard

Used 189+ 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.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the term is used to describe fields in a database?

Information
Rows
Properties
Entity

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Trigger is invoked before/after data row is:

deleted

updated

inserted

all answers are correct

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Below are the Data Definition Command, EXCEPT

CREATE
ALTER
MERGE
SELECT

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

The SQL command to create a new user with password is: —CREATE USER

‘YJChin’@’localhost’ IDENTIFIED BY ‘password123’

FALSE

TRUE

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is the correct command to create a view?

CREATE VIEW Inv_1 AS
SELECT VIEW Inv_1 FROM
CREATE TABLE VIEW Inv_1 AS
CREATE VIEW TABLE Inv_1 FROM

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What command to use if I want to execute the stored procedure through Xampp?

EXECUTE
EXEC
CALL
CALLING

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Below are the procedural SQL that can be used to enhance the power of SQL, EXCEPT:

Triggers
Stored procedures
Function
View

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?