Find all the cities whose humidity is 89

SELECT city FROM weather WHERE humidity = 89;

SELECT city WHERE humidity = 89;

SELECT humidity = 89 FROM weather;

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

Feature has two 0's in it, at any position

Find the names of those 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');

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

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 all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

What does the following query find? (SELECT DISTINCT r.sid FROM boats b, reserves r WHERE b.bid = r.bid AND b.color = 'red') MINUS (SELECT DISTINCT r.sid FROM boats b, reserves r WHERE b.bid = r.bid AND b.color = 'green')

Find the sailor IDs of all sailors who have reserved red boats but not green boats

Find the sailor IDs of at least one sailor who have reserved red boats but not green boats

Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats

What SQL command can be used to delete columns from a table?

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DROP ColumnName

The SQL WHERE clause:

limits the row data are returned.

limits the column data that are returned.

The wildcard in a WHERE clause is useful when?

An exact match is not possible in a SELECT statement.

An exact match is not possible in a CREATE statement.

An exact match is necessary in a CREATE statement.

An exact match is necessary in a SELECT statement.

The HAVING clause does which of the following?

Acts like a WHERE clause but is used for groups rather than rows.

Acts EXACTLY like a WHERE clause.

Acts like a WHERE clause but is used for columns rather than groups.

Acts like a WHERE clause but is used for rows rather than columns.

Which of the following query is correct for using comparison operators in SQL?

SELECT name, course_name FROM student WHERE age>50 and age <80;

SELECT name, course_name FROM student WHERE age>50 and <80;

SELECT name, course_name FROM student WHERE age>50 and WHERE age<80;

How to select all data from student table starting the name from letter 'r'?

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '%r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE '_r%';

Which statement is wrong about PRIMARY KEY constraint in SQL?

Primary key must be made of any single columns

The PRIMARY KEY uniquely identifies each record in a SQL database table

Primary key can be made based on multiple columns

Primary keys must contain UNIQUE values.

Wrong statement about UPDATE keyword is

Only one record can be updated at a time using WHERE clause

If WHERE clause in missing in statement the all records will be updated.

Multiple records can be updated at a time using WHERE clause

Wrong statement about ORDER BY keyword is

To sort the records in descending order, use the DECENDING keyword.

Used to sort the result-set in ascending or descending order

The ORDER BY keyword sorts the records in ascending order by default.

To sort the records in ascending order, use the ASC keyword.

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

ALTER TABLE table_name DROP COLUMN column_name ;

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

SELECT NAME FROM CUSTOMER WHERE STATE = 'V%';

What are composite indexes?

A composite index is a combination of index on 2 or more columns

Are those which are composed by database for its internal use

Composite index can never be created

SQL-TEST

Quiz

•

Computers

•

University

•

Practice Problem

•

Medium

Devendra Kumar Mishra

Used 12+ times

FREE Resource

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

3 mins • 1 pt

Which data manipulation command is used to combines the records from one or more tables?

SELECT

PROJECT

JOIN

PRODUCT

2.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which operator is used to compare a value to a specified list of values?

BETWEEN

ANY

IN

ALL

3.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following operations requires the relations to be union compatible?

UNION

INTERSECTION

DIFFERENCE

ALL OF THESE

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

DCL provides commands to perform actions like

Change the structure of Tables

Insert, Update or Delete Records and Values

Authorizing Access and other control over Database

None of Above

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which function is used to divides one numeric expression by another and get the remainder ?

POWER

MOD

ROUND

REMAINDER

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A database language used for defining the whole data base structure and schema is called

DCL

DML

DDL

All Of Above

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which statement in SQL allows us to change the definition of a table is?

ALTER

UPDATE

CREATE

SELECT

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

50 questions

MS Excel Quiz

Quiz

•

University

53 questions

EEP

Quiz

•

University

52 questions

webdev ii

Quiz

•

University

50 questions

AKT test (151-200) Жаңа вариант

Quiz

•

University

52 questions

computer memory and storage

Quiz

•

University

50 questions

IUTCS Freshers

Quiz

•

University

50 questions

Computer System Servicing

Quiz

•

University

50 questions

Quiz

•

University

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

30 questions

Quiz 1 Review

Quiz

•

University

SQL-TEST

50 questions

Which data manipulation command is used to combines the records from one or more tables?

Which operator is used to compare a value to a specified list of values?

Which of the following operations requires the relations to be union compatible?

DCL provides commands to perform actions like

Which function is used to divides one numeric expression by another and get the remainder ?

A database language used for defining the whole data base structure and schema is called

Which statement in SQL allows us to change the definition of a table is?

Which operator performs pattern matching?

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

Which SQL keyword is used to
retrieve a maximum value?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

SQL-TEST

50 questions

Which data manipulation command is used to combines the records from one or more tables?

Which operator is used to compare a value to a specified list of values?

Which of the following operations requires the relations to be union compatible?

DCL provides commands to perform actions like

Which function is used to divides one numeric expression by another and get the remainder ?

A database language used for defining the whole data base structure and schema is called

Which statement in SQL allows us to change the definition of a table is?

Which operator performs pattern matching?

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

Which SQL keyword is used toretrieve a maximum value?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Which SQL keyword is used to
retrieve a maximum value?