Find the SQL statement that is equal to: 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 IN CUSTOMER WHERE STATE = 'V';

Many to many relationships are difficult to represent in database, so we need to

Split many to many relationship into two one to many relationships

Split one to many relationship into two one to many relationships

Split many to many relationship into one to many relationships

Split many to many relationship into three one to many relationships

All of the these can be done by SQL

create database structures only

A subquery in an SQL SELECT statement

has a distinct form that cannot be duplicated by a join

can only be used with two tables

can always be duplicated by a join

cannot have its results sorted using ORDER BY

how to Add a new column into existing table?

ALTER TABLE Student ADD COLUMN sDegree VARCHAR(64) NOT NULL

ALTER TABLE Student MODIFY COLUMN sDegree CHAR(64) NOT NULL

ALTER TABLE S ADD COLUMN s VACHAR(64) NOT NULL

ALTER TABLE Student DROP COLUMN sDegree VARCHAR(64) NOT NULL

how to rename a column in existing table?

ALTER TABLE Student RENAME COLUMN s to SS VACHAR(64) NOT NULL

ALTER TABLE Student MODIFY COLUMN sDegree CHAR(64) NOT NULL

ALTER TABLE Student ADD COLUMN sDegree VARCHAR(64) NOT NULL

ALTER TABLE Student DROP COLUMN sDegree VARCHAR(64) NOT NULL

Which of the following is not correct ?

INSERT INTO Employe VALUES(26, ‘Mary’,26);

INSERT INTO Employee(ID, Name, Salary) VALUES(2,‘Mary’,26);

INSERT INTO Employee (Name,ID) VALUES (‘Mary’,2);

INSERT INTO Employee VALUES (2, ‘Mary’,26000);

Please increase salary for 10% ?

UPDATE Employee SET Salary = Salary * 1.1

UPDATE Employee SET Salary = Salary*0.5

UPDATE Employee SET Salary = Salary * 0.1

UPDATE Employee Update Salary = Salary*0.1

Please remove staff, who earns more than 22000 ?

DELETE FROM Employee WHERE Salary >=22000;

DELETE FROM Employe WHERE Salary => 22000;

REMOVE FROM Employee WHERE Salary >22000;

DELETE FROM Employee WHERE Salary = 22000;

πsName,sAddress(Student) is equal to?

SELECT Sname, SAddress FROM Student

SELECT Sname, SAddress FORM Students

SELECT Sname and SAddress FROM Students

SQL query to find a list of the ID numbers and Marks for students who have passed IAI

Select ID, Mark from Grade Where code = 'IAI' and Mark >=50;

Select ID, Mark from Grade Where code = 'IAI' and Mark > 50;

Select ID, Mark from Grade Where code = 'AIA' and Mark > 50;

Select ID, Mark, Code from Grade Where code = 'IAI';

Find students who studying any Programming module

Select First,Last from Student Natural Join Grade Where Code like'PR%'

Select First,Last from Student,Grade Where Code='PR1'OR'PR2'

Select First Last from Student Natural Join Grade Where Code like'PR%'

Select First from Student Natural Join Grade Where Code = 'PR%'

How to use privileges in SQL?

GRANT<privileges> ON<objects> TO<users>

ON<objects> TO<users> GRANT<privileges>

GRANT<privileges> TO<users> ON<objects>

GRANT<tables> ON<objects> TO<users>

If Admin’ grants ALL privileges to ‘Manager’, and SELECT to ‘Finance’ with grant option, So..

‘Manager’ grants ALL to ‘Personnel’

‘Manager’ grants SELECT to ‘Personnel’

‘Finance’ grants SELECT to ‘Manager’

‘Finance’ grants ALL to ‘Manager’

If Admin’ grants ALL privileges to ‘Manager’, and SELECT to ‘Finance’ with grant option, So..

‘Finance’ grants SELECT to ‘Personnel’

‘Manager’ grants SELECT to ‘Personnel’

‘Finance’ grants SELECT to ‘Manager’

‘Finance’ grants ALL to ‘Manager’

If ‘Manager’ revokes ALL from ‘Personnel’

‘Personnel’ still has SELECT privileges from ‘Finance’

‘Personnel’ still has ALL privileges from ‘Finance

‘Finance’ still has SELECT privileges from ‘Personnel’

‘Admin’ still has ALL privileges from ‘Finance’

If ‘Finance revokes SELECT from ‘Personnel’

‘Personnel’ still has ALL privileges from ‘Manager’

‘Personnel’ still has ALL privileges from ‘Finance’

‘Finance’ still has SELECT privileges from ‘Personnel’

‘Admin’ still has ALL privileges from ‘Finance’

If ‘Admin’ revokes Select from ‘Finance’

‘Personnel’ still has ALL privileges from ‘Manager’

‘Personnel’ still has ALL privileges from ‘Finance’

‘Finance’ still has SELECT privileges from ‘Personnel’

‘Admin’ still has ALL privileges from ‘Finance’

If ‘Admin’ revokes ALL from ‘Manager’

‘Finance still has SELECT privileges from ‘Admin’

‘Personnel’ still has ALL privileges from ‘Finance’

‘Finance’ still has SELECT privileges from ‘Personnel’

‘Admin’ still has ALL privileges from ‘Finance’

If Admin’ grants ALL privileges to ‘Manager’, and SELECT to ‘Finance’ with grant option, So..

‘Manager’ grants ALL to ‘Personnel’

‘Manager’ grants SELECT to ‘Personnel’

‘Finance’ grants SELECT to ‘Manager’

‘Finance’ grants ALL to ‘Manager’

A functional dependency (FD) is a

link between two sets of attributes in a relation

link between three sets of attributes in a relation

link between all sets of attributes in a relation

link between four sets of attributes in a relation

A functional dependency (FD) is a

link between two sets of attributes in a relation

link between three sets of attributes in a relation

link between all sets of attributes in a relation

link between four sets of attributes in a relation

DBSM 121-180

Quiz

•

Science

•

University

•

Practice Problem

•

Easy

Qaxraman Sadullaev

Used 19+ times

FREE Resource

60 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra operation

Union

Difference

Intersection

Product

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra operation

Union

Difference

Intersection

Product

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra operation

Union

Difference

Intersection

Product

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra
operation

Union

Difference

Intersection

Product

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The SQL WHERE clause

Condition that limits the column data that are returned

Condition that limits the row data are returned

Clause that returns all rows

Clause that returns nothing

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The command to eliminate a table from a database

Drop

Delete

Remove

Update

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is correct order of keywords for SQL Select statement?

SELECT, FROM, WHERE

WHERE, FROM, SELECT

FROM, WHERE, SELECT

SELECT, WHERE, FROM

Create a free account and access millions of resources

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

60 questions

7th Grade Final Exam Review

Quiz

•

7th Grade - University

58 questions

Thermal energy transfer and conductivity

Quiz

•

6th Grade - University

55 questions

Knee Review

Quiz

•

11th Grade - University

64 questions

Ecology Chapter 2

Quiz

•

University

58 questions

Biofísica 2023

Quiz

•

University

62 questions

Intro to Meteorology Chapters 1,2,3

Quiz

•

University

55 questions

LABORATORY MANAGEMENT PRELIM EXAM

Quiz

•

University - Professi...

60 questions

Interpretação de Exames Laboratoriais

Quiz

•

University

Popular Resources on Wayground

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade

Discover more resources for Science

20 questions

Definite and Indefinite Articles in Spanish (Avancemos)

Quiz

•

8th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

9 questions

Principles of the United States Constitution

Interactive video

•

University

18 questions

Realidades 2 2A reflexivos

Quiz

•

7th Grade - University

10 questions

Dichotomous Key

Quiz

•

KG - University

25 questions

Integer Operations

Quiz

•

KG - University

7 questions

What Is Narrative Writing?

Interactive video

•

4th Grade - University

20 questions

SER vs ESTAR

Quiz

•

7th Grade - University

DBSM 121-180

60 questions

Choose the correct relational algebra operation

Choose the correct relational algebra operation

Choose the correct relational algebra operation

Choose the correct relational algebra
operation

The SQL WHERE clause

The command to eliminate a table from a database

Which of the following is correct order of keywords for SQL Select statement?

Are given table union compatible ?

SQL data definition commands make up a(n)

In a relation, the columns are also called attributes

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Science

DBSM 121-180

60 questions

Choose the correct relational algebra operation

Choose the correct relational algebra operation

Choose the correct relational algebra operation

Choose the correct relational algebraoperation

The SQL WHERE clause

The command to eliminate a table from a database

Which of the following is correct order of keywords for SQL Select statement?

Are given table union compatible ?

SQL data definition commands make up a(n)

In a relation, the columns are also called attributes

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Science

Choose the correct relational algebra
operation