Sometimes, aliasing is necessary because

Primary keys in different tables might have the same name

Long table names are cumbersome to repeatedly re-enter

What is the difference between WHERE and HAVING?

HAVING only applies to aggregate functions like GROUP BY

WHERE specifies a GEOGRAPHIC location for a database server

It is faster, safer and better practice to not allow general access to the production database

You should not, they are inefficient

"View" is simply a synonym for the return of the SELECT function

What is a foreign key?

A primary key of a different table present in another table

A key from a different SQL system (e.g. Postgres to SQL Server)

A key to the international version of SQL server

A primary key from any other database

Which of the following is not a type of SQL statement?

Data Communication Language (DCL)

Data Manipulation Language (DML)

Correct syntax query syntax to drop a column from a table is

ALTER TABLE table_name DROP COLUMN column_name ;

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.

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

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

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

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

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

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

sql basics

Authored by s soundaryaa

Computers

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

76 questions

Show all answers

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What does the "S" in SQL stand for?

Several

Structured

Syntax

Semi-precise

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

The "R" of CRUD is best represented by the SQL command:

SELECT

DROP

ALTER

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What is the MAXIMUM number of false inputs an AND will accept and still give a positive output?

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

How could we choose only unique values in a query?

SELECT UNIQUE

SELECT DISTINCT

SELECT SPECIAL

SELECT WITH NO DUPLICATE

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What is the syntax to enter a new record into the "Sales" table?

INSERT INTO Sales VALUES

ALTER SALES NEW VALUES

SALES = SALES + NEW VALUES

SALES.ALTER.EDIT.CHANGE

MULTIPLE SELECT QUESTION

2 mins • 1 pt

Which two constraints apply to PRIMARY KEY?

Unique

Non-null

Alphanumeric

ASCII

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

What is the syntax to create a new table?

CREATE TABLE

MAKE TABLE

GENERATE TABLE

NEW TABLE

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

80 questions

CompTIA A+ Core 2 Practice Test A

Quiz

•

University

72 questions

Python Basics

Quiz

•

9th - 12th Grade

72 questions

Level2. 190-255

Quiz

•

80 questions

Coding Unit 1

Quiz

•

6th - 8th Grade

75 questions

Digital Literacy Final Exam Study Guide

Quiz

•

9th Grade

80 questions

Major Data Structures and Algorithm

Quiz

•

KG - University

72 questions

WP 16-23

Quiz

•

Professional Development

80 questions

Day 5 Practice 1 CompTIA IT Fundamentals+ Certification Quiz

Quiz

•

8th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

4 questions

Conflict Resolution

Lesson

•

20 questions

Place Value

Quiz

•

KG - 3rd Grade

20 questions

CVC Words

Quiz

•

KG - 1st Grade

24 questions

CKLA Unit 5 assessment K

Quiz

•

10 questions

STAAR Review - Editing & Revising Clusters

Quiz

•

10 questions

Reflexive Pronouns

Quiz

•

KG - 5th Grade

10 questions

Long i- igh, ie, and y Quiz

Quiz

•

KG - 3rd Grade

12 questions

Quarter Past, Half Past, and Quarter To

Quiz

•

KG - 12th Grade

sql basics

What does the "S" in SQL stand for?

The "R" of CRUD is best represented by the SQL command:

What is the MAXIMUM number of false inputs an AND will accept and still give a positive output?

How could we choose only unique values in a query?

What is the syntax to enter a new record into the "Sales" table?

Which two constraints apply to PRIMARY KEY?

What is the syntax to create a new table?

Which of the below is NOT an SQL distribution?

The most common join is:

Databases are more fully-featured than files because they are

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers