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

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

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

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

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

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

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

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

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

What is data redundancy?

Data that is repeated multiple times.

Data that is safe from SQL attacks.

Data that is weak to SQL attacks.

Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.

SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT * FROM movies WHERE name LIKE ‘day’;

RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';

SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;

Return all dramas made after 2004.

SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;

SELECT * FROM movies WHERE genre = 'drama';

SELECT * FROM movies WHERE genre = "drama' AND year < 2004;

SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7

What is the expected output from following SQL Query: SELECT title FROM videogames WHERE title LIKE '%2'

It will only show videogames which ends with the character 2 in the title

It will only show video games which contains the character 2 somewhere in the title

It will only show videogames which begins with the character 2 in the title

Data and Database: SQL

Authored by Anam Qureshi

Computers

11th - 12th Grade

CCSS covered

Used 21+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

36 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is the best example of a primary key?

Driver's License Number

Home Runs Hit

Price

First and Last Name

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Data _____ helps ensure that an incorrect entry isn't made.

validation

checks

accuracy

integrity

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The front-end of a database is known as a _____.

form

report

query

website

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The following are functions of a DBMS except

Creating database

Processing data

Creating and processing forms

Administrating database

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database management system (DBMS) is a:

Software system used to create, maintain, and provide controlled access to a database

Hardware system used to create, maintain, and provide controlled access to a database

Hardware system used to create, maintain, and provide uncontrolled access to a database

Software system used to create, maintain, and provide uncontrolled access to a database

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A database application can perform which of the following activities?

Add records

Display / read records

Update records

All of the above

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A relational database consists of a collection of

Field

Record

Table

Keys

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

32 questions

NOCTI VOCAB 2

Quiz

•

11th - 12th Grade

35 questions

情報1_第三学期_総復習

Quiz

•

9th Grade - University

31 questions

Year 7 Computer Science Baseline

Quiz

•

KG - Professional Dev...

40 questions

Próbny INF.03 2022

Quiz

•

12th Grade

39 questions

AQA Computer Science GCSE - 3.5 Computer networks

Quiz

•

10th - 12th Grade

37 questions

Stock Market-Stock Market Game

Quiz

•

8th - 12th Grade

33 questions

Eduqas Computer Science 1.1 Hardware

Quiz

•

9th - 11th Grade

32 questions

COP NSDA L3= 0006

Quiz

•

12th Grade

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Discover more resources for Computers

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Data and Database: SQL

Which is the best example of a primary key?

Data _____ helps ensure that an incorrect entry isn't made.

The front-end of a database is known as a _____.

The following are functions of a DBMS except

A database management system (DBMS) is a:

A database application can perform which of the following activities?

A relational database consists of a collection of

The term attribute refers to a ________ of a table

The term _______ is used to refer a row

Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers