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

Authored by Qaxraman Sadullaev

Science

University

Used 19+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

60 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra operation

Union

Difference

Intersection

Product

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra operation

Union

Difference

Intersection

Product

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra operation

Union

Difference

Intersection

Product

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct relational algebra
operation

Union

Difference

Intersection

Product

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The command to eliminate a table from a database

Drop

Delete

Remove

Update

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

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

65 questions

Assessment of the Ears

Quiz

•

University

58 questions

Continental Drift

Quiz

•

8th Grade - University

55 questions

Chapter 13: Delirium and Dementia

Quiz

•

University

55 questions

Ch 31: Immunologic System Introduction

Quiz

•

University

57 questions

Ch 3 Debt

Quiz

•

University

60 questions

8th sem exam

Quiz

•

8th Grade - University

55 questions

Refrigeration and Thermodynamics sample

Quiz

•

University

55 questions

BCA_QUIZ_CLUB_20_Sep

Quiz

•

University

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

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

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Science

12 questions

Recitation Week 3

Quiz

•

University

DBSM 121-180

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Science

DBSM 121-180

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Science

Choose the correct relational algebra
operation