Search Header Logo

SQL - Session 4

Authored by Peter Stikker

Education

University

Used 90+ times

SQL - Session 4
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When will an implication result in a False value? (i.e. when is p => q False)

0 => 0

0 => 1

1 => 0

1 => 1

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a SQL query, you can select specific rows (records) using...

SELECT

FROM

WHERE

USE

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will the result be of the following query?

(you can assume the student table has a lot of names in it, including Pascal, and Anne)

SELECT *

FROM student

WHERE [name] = '_a%'

an error

an empty table

all info in student, from students who's name have the letter a in them

all info in student, from students who's name has an a as the second letter

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The UPDATE command is part of SQL's...

DML

DCL

DDL

DHL

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

The referential integrity states that a foreign key refers to a primary key or is.....

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?

Discover more resources for Education