SQL Queries Introduction

SQL Queries Introduction

University

38 Qs

quiz-placeholder

Similar activities

Exam

Exam

University

42 Qs

Prelim Exam

Prelim Exam

University

40 Qs

SIMULASI DIGITAL - X

SIMULASI DIGITAL - X

KG - Professional Development

40 Qs

Java Script

Java Script

9th Grade - Professional Development

39 Qs

Dessain WEB Dinamis MM A

Dessain WEB Dinamis MM A

University

33 Qs

GIỮA KỲ 2 -  TIN 8

GIỮA KỲ 2 - TIN 8

8th Grade - University

36 Qs

PowerPoint  2016

PowerPoint 2016

7th Grade - University

40 Qs

03 - Computer Fundamentals

03 - Computer Fundamentals

University

38 Qs

SQL Queries Introduction

SQL Queries Introduction

Assessment

Quiz

Computers

University

Hard

Created by

Thivya Sindhu

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

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

38 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a ‘tuple’?

A row or record in a database table

Another name for the key linking different tables in a database.

An attribute attached to a record.

Another name for a table in an RDBMS.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The command to remove rows from a table ‘CUSTOMER’ is:

REMOVE FROM CUSTOMER …

DROP FROM CUSTOMER …

DELETE FROM CUSTOMER WHERE …

UPDATE FROM CUSTOMER …

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The command to eliminate a table from a database is:

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

With SQL, how do you select all the columns from a table named "Persons"?

SELECT [all] FROM Persons

SELECT Persons

SELECT * FROM Persons

SELECT *.Persons

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

With SQL, how can you insert a new record into the "Persons" table?

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The NOT NULL constraint enforces a column to not accept empty values.


Next ❯

TRUE

FALSE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,Joey,2000);

Table

Values

Relation

Field

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 Computers