What does the SQL FROM clause do?

Specifies the tables to retrieve rows from

Specifies the columns we are retrieving

What is a result of "CAST (phone_number AS INTEGER)"?

phone_number attribute will be converted into integer data type

phone_number attribute will be converted to lower case

phone_number attribute will be converted from integer into varchar data type

phone_number attribute will be converted to upper case

What does follow the SQL WHERE clause?

Name of the table we are selecting from

Set difference R1 - R2 is ...

is the relation containing all tuples of R1 that do not appear in R2

is the relation containing all tuples that appear only in both R1 and R2

is the relation containing all tuples that appear in R1, R2, or both

Which of the following SQL statements will select all records with all their columns from a table called Sales.

SELECT * FROM Sales WHERE OrderID < 1

To define what columns should be displayed in an SQL SELECT statement:

use FROM to name the source table(s) and list the columns to be shown after SELECT.

use SELECT to name the source table(s) and list the columns to be shown after USING.

use USING to name the source table(s) and list the columns to be shown after SELECT.

use USING to name the source table(s) and list the columns to be shown after WHERE.

EXCEPT in SQL is analogous to

Difference operator of relational algebra

Join operator of relational algebra

Cartesian product operator of relational algebra

Intersection operator of relational algebra

Intersection R1 n R2 is ...

is the relation containing all tuples that appear in R1, R2, or both

is the relation containing all tuples that appear only in both R1 and R2

is the relation containing all tuples of R1 that do not appear in R2

With SQL, how can you return the number of records in the "Persons" table?

SELECT COLUMNS(*) FROM Persons;

Which SQL statement will selects all rows from a table called "Customers" and orders the result by "customer name"?

SELECT * FROM Customers ORDER BY customer_name;

SELECT * FROM Customers ORDER customer_name;

SELECT * FROM Customers ORDERED customer_name;

SELECT * FROM Customers ORDER ON customer_name;

What is meant by the term union compatibility?

When two or more tables share the same number of columns and when they share the same domains

When two or more tables share the same number of columns

When two or more tables share the same (or compatible) domains

What is the meaning of LIKE '%0%0%*

Answer has two O's in it, at any position

Which of the SQL statements is correct?

SELECT Username, Password FROM Users

SELECT Username AND Password FROM Users

SELECT Username, Password WHERE Username = 'userl'

Which of the SQL statements is correct?

SELECT Username, Password FROM Users

SELECT Username AND Password FROM Users

SELECT Username, Password WHERE Username = 'userl'

In an SQL SELECT statement querying a single table, the asterisk (*) means that:

all columns of the table are to be returned.

all records with even partial criteria met are to be returned.

all records meeting the full criteria are to be returned.

If Table A is on the left and Table B is on the right, a right outer join will include in its answer

All the rows from Table B, with the corresponding detail of Table A for those rows for which the value of the two tables' common attribute match exactly

All rows from both Table A and Table B

Only the rows for which the values of the two tables' common attribute match exactly

All the rows from Table A, with the corresponding detail of Table B for those rows for which the values of the two tables' common attribute match exactly

The AVG SQL function returns the...

average number of rows in all tables

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 * FROM Persons WHERE LastName='Jackson';

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

What is meant by the following relational algebra statement: STUDENT X COURSE

Compute the cartesian product between the STUDENT and COURSE relations

Compute the right outer join between the STUDENT and COURSE relations

Compute the left outer join between the STUDENT and COURSE relations

Compute the full outer join between the STUDENT and COURSE relations

Choose the right order of the database design phases

Subject area analysis, Conceptual Design, Logical Design, Physical Design

Conceptual Design, Logical Design, Physical Design, Queries Implementation

Conceptual Design, Logical Design, Physical Design, DBMS Selection

Subject area analysis, Logical Design, Conceptual Design, Physical Design

SQL Quiz

Authored by Nurly Nurly

Other

12th Grade

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

65 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct option to convert phone_number attribute from varchar to integer data type

phone_number:varchar(*)

phone_number.int

phone_number:varchar (3)

phone_number to int

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

List all operations of relation algebra in the query: SELECT accountld FROM Account;

Projection

Projection, union

Projection, selection

Selection

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table that satisfies 2NF

None of the given

May violate 1NF

Always satisfies 1NF

Always satisfies 3NF

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

SELECT Persons;

SELECT * Persons;

SELECT [all] FROM Persons;

SELECT * FROM Persons;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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='a';

SELECT * FROM Persons WHERE FirstName LIKE '%a';

SELECT FROM Persons WHERE FirstName LIKE 'a%;

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The___ operator combines all tuples from two relations excluding duplicates.

Difference

Divide

Union

Intersect

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL keyword is used to retrieve a maximum value?

MOST

UPPER

TOP

MAX

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

60 questions

Spanish 1st 9-Weeks Exam 1

Quiz

•

KG - University

64 questions

Foods 1- 2.00

Quiz

•

9th - 12th Grade

60 questions

MIL 1st Quarter Exam

Quiz

•

11th - 12th Grade

60 questions

JP Music Instruments & Voices

Quiz

•

KG - 12th Grade

64 questions

Personal Budget Study Guide

Quiz

•

9th - 12th Grade

60 questions

Post Test in TLE 7

Quiz

•

7th Grade - University

66 questions

tin12

Quiz

•

12th Grade

70 questions

Microsoft Word Advanced

Quiz

•

6th - 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

SQL Quiz

Choose the correct option to convert phone_number attribute from varchar to integer data type

List all operations of relation algebra in the query: SELECT accountld FROM Account;

A table that satisfies 2NF

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

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"?

The___ operator combines all tuples from two relations excluding duplicates.

Which SQL keyword is used to retrieve a maximum value?

What does the SQL FROM clause do?

Which of the following is used to denote the selection operation in relational algebra?

Which of the following SQL statements can be used to create a relational table?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground