Which of the following queries is valid

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;

Which of the following is used to delete columns

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

ALTER TABLE TableName DELETE ColumnName

Consider the following Table. STUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks); Which of the following query would display names of all the students whose email ids are not provided?

SELECT first_name, last_name FROM students WHERE email is null;

SELECT first_name, last_name FROM students WHERE email=0;

SELECT first_name, last_name FROM students WHERE email='null';

SELECT first_name, last_name FROM students WHERE email ='NULL'

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

All columns of the table are to be returned

all records are to be returned.

All records meeting the full criteria are to be returned.

How can you change "Thomas" into "Michel" in the "LastName" column in the Users table?

UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'

MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

Which of the following statement is correct regarding the difference between TRUNCATE and DELETE,DROP commands?

DELETE and TRUNCATE remove the records but keeps the structure.

DELETE will free the space while TRUNCATE and DROP will not free the space

TRUNCATE and DROP operations can be rolled back but DELETE operations cannot be rolled back.

DELETE is DDL while TRUNCATE and DROP are DML

Which of the following statement is correct to display all the cities with the condition, temperature, and humidity whose humidity is in the range of 60 to 75 from the 'whether' table?

SELECT * FROM weather WHERE humidity BETWEEN 60 AND 75

SELECT * FROM weather WHERE humidity IN (60 to 75)

SELECT * FROM weather WHERE humidity NOT IN (60 AND 75)

SELECT * FROM weather WHERE humidity NOT BETWEEN 60 AND 75

SQL BASICS

Authored by Moses Prakash

Computers

University

Used 91+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

25 questions

Show all answers

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which one will delete the table data as well as table structure?

DROP

TRUNCATE

ALTER

DELETE

DRAG AND DROP QUESTION

20 sec • 1 pt

Drag the options into the correct boxes to complete the query
To display the detail of employee having "e" in their name in descending order of salary
SELECT * (a) emp (b) ename (c) %e%" (d) SAL (e) ;

FROM

WHERE

LIKE "

ORDER BY

DESC

FILL IN THE BLANKS QUESTION

20 sec • 1 pt

(a) is used to eliminate duplicate values

MATCH QUESTION

20 sec • 1 pt

Match the following

REVOKE

DDL

ALTER

DCL

UPDATE

DML

ROLLBACK

TCL

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which operator is used to specify the RANGE of values

RANGE from

FROM .. TO

Between .. and

Between range

REORDER QUESTION

20 sec • 1 pt

Reorder the following to get a correct query
display the username and password of all users

password

from

select

users

username

FILL IN THE BLANKS QUESTION

20 sec • 1 pt

A (a) constraint enforces referential Integrity

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

20 questions

WML & WAP

Quiz

•

University

20 questions

Web Systems Quiz - ICT 121

Quiz

•

University

20 questions

Basic of Computer and Network

Quiz

•

8th Grade - University

20 questions

SPCC ISE 2 Quiz TE B

Quiz

•

University

20 questions

Software Engineering Quiz 1

Quiz

•

University

20 questions

INTERNET

Quiz

•

University

20 questions

Round 1 ( RHA Learner Contest )

Quiz

•

University

20 questions

Application Software - Revision Quiz

Quiz

•

University

Popular Resources on Wayground

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

20 questions

Brand Labels

Quiz

•

5th - 12th Grade

Discover more resources for Computers

20 questions

Disney Trivia

Quiz

•

University

10 questions

Spanish Greetings and Goodbyes!

Presentation

•

6th Grade - University

20 questions

Preterito vs. Imperfecto

Quiz

•

KG - University

15 questions

TOEFL Structure - TEST 2

Quiz

•

University

25 questions

Cell Transport

Quiz

•

KG - University

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

4 questions

Exit ticket for the end of class: Spotlight

Quiz

•

KG - Professional Dev...

12 questions

Hurricane or Tornado

Quiz

•

3rd Grade - University

SQL BASICS

Which one will delete the table data as well as table structure?

Drag the options into the correct boxes to complete the query
To display the detail of employee having "e" in their name in descending order of salary
SELECT * (a) emp (b) ename (c) %e%" (d) SAL (e) ;

(a) is used to eliminate duplicate values

Match the following

Which operator is used to specify the RANGE of values

Reorder the following to get a correct query
display the username and password of all users

A (a) constraint enforces referential Integrity

A subquery in an SQL SELECT statement is enclosed in:

Reorder the following to get the correct order of clauses in select statement.

Which type of join will automatically find the common column for joining tables?

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 BASICS

Which one will delete the table data as well as table structure?

Drag the options into the correct boxes to complete the queryTo display the detail of employee having "e" in their name in descending order of salarySELECT * ​ (a) emp ​ (b) ename ​ (c) %e%" ​ (d) SAL ​ (e) ;

(a) is used to eliminate duplicate values

Match the following

Which operator is used to specify the RANGE of values

Reorder the following to get a correct querydisplay the username and password of all users

A (a) constraint enforces referential Integrity

A subquery in an SQL SELECT statement is enclosed in:

Reorder the following to get the correct order of clauses in select statement.

Which type of join will automatically find the common column for joining tables?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers

Drag the options into the correct boxes to complete the query
To display the detail of employee having "e" in their name in descending order of salary
SELECT * (a) emp (b) ename (c) %e%" (d) SAL (e) ;

Reorder the following to get a correct query
display the username and password of all users