Quiz about DBSM 121-180

Question 1

Choose the correct relational algebra operation

Accepted Answer

Difference

Answer

Union

Answer

Intersection

Answer

Product

Question 2

Choose the correct relational algebra operation

Accepted Answer

Intersection

Answer

Union

Answer

Difference

Answer

Product

Question 3

Choose the correct relational algebra operation

Accepted Answer

Product

Answer

Union

Answer

Difference

Answer

Intersection

Question 4

Choose the correct relational algebra

operation

Accepted Answer

Union

Answer

Difference

Answer

Intersection

Answer

Product

Question 5

The SQL WHERE clause

Accepted Answer

Condition that limits the row data are returned

Answer

Condition that limits the column data that are returned

Answer

Clause that returns all rows

Answer

Clause that returns nothing

Question 6

The command to eliminate a table from a database

Accepted Answer

Drop

Answer

Delete

Answer

Remove

Answer

Update

Question 7

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

Accepted Answer

SELECT, FROM, WHERE

Answer

WHERE, FROM, SELECT

Answer

FROM, WHERE, SELECT

Answer

SELECT, WHERE, FROM

Question 8

Are given table union compatible ?

Accepted Answer

Yes

Answer

No

Answer

I do not know

Answer

May be

Question 9

SQL data definition commands make up a(n)

Accepted Answer

DDL

Answer

DDC

Answer

DML

Answer

DDD

Question 10

In a relation, the columns are also called attributes

Accepted Answer

True

Answer

False

Answer

May be

Answer

I do not know

Question 11

Find the SQL statement that is equal to: SELECT NAME FROM CUSTOMER

WHERE STATE = 'VA';

Accepted Answer

SELECT NAME FROM CUSTOMER WHERE STATE IN 'VA';

Answer

SELECT NAME IN CUSTOMER WHERE STATE IN 'VA';

Answer

SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

Answer

SELECT NAME IN CUSTOMER WHERE STATE = 'V';

Question 12

In E\R diagrams, we will represent Relationships as

Accepted Answer

Boxes with rounded corners

Answer

Links between two entities

Answer

Ovals

Answer

Diamond box

Question 13

In E\R diagrams, we will represent Attributes as

Accepted Answer

Ovals

Answer

Boxes with rounded corners

Answer

Links between two entities

Answer

Diamond box

Question 14

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

to

Accepted Answer

Split many to many relationship into two one to many relationships

Answer

Split one to many relationship into two one to many relationships

Answer

Split many to many relationship into one to many relationships

Answer

Split many to many relationship into three one to many relationships

Question 15

The result of a SQL SELECT statement is a(n)

Accepted Answer

Table

Answer

Report

Answer

Form

Answer

File

Question 16

Which of the following are the five built-in functions provided by SQL?

Accepted Answer

COUNT, SUM, AVG, MAX, MIN

Answer

COUNT, SUM, AVG, MAX, MULT

Answer

SUM, AVG, MIN, MAX, NAM

Answer

SUM, AVG, MULT, DIV, MIN

Question 17

In a relation, the order of the rows matters

Accepted Answer

False

Answer

True

Answer

I do not know

Answer

May be

Question 18

SQL can be used to

Accepted Answer

All of the these can be done by SQL

Answer

create database structures only

Answer

query database data only

Answer

modify database data only

Question 19

The SQL statement that queries or reads data from a table is ________

Accepted Answer

SELECT

Answer

READ

Answer

QUERY

Answer

NONE

Question 20

A subquery in an SQL SELECT statement

Accepted Answer

has a distinct form that cannot be duplicated by a join

Answer

can only be used with two tables

Answer

can always be duplicated by a join

Answer

cannot have its results sorted using ORDER BY

Question 21

The SQL keyword BETWEEN is used

Accepted Answer

for ranges

Answer

as a wildcard

Answer

to limit the columns displayed

Answer

None of the above

Question 22

Sometimes you want to change the structure of an existing table, what are your

options?

Accepted Answer

Alter Table

Answer

Change table

Answer

Drop Table

Answer

Create Table

Question 23

how to Add a new column into existing table?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 24

how to

rename a column in existing table?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 25

how to change the row(s) in a table

Accepted Answer

update

Answer

insert

Answer

change

Answer

delete

Question 26

how to remove the row(s) from a table

Accepted Answer

delete

Answer

insert

Answer

update

Answer

change

Question 27

Please increase salary for 10% ?

Accepted Answer

UPDATE Employee SET Salary = Salary * 1.1

Answer

UPDATE Employee SET Salary = Salary*0.5

Answer

UPDATE Employee SET Salary = Salary * 0.1

Answer

UPDATE Employee Update Salary = Salary*0.1

Question 28

Please remove staff, who earns more than 22000 ?

Accepted Answer

DELETE FROM Employee WHERE Salary >=22000;

Answer

DELETE FROM Employe WHERE Salary => 22000;

Answer

REMOVE FROM Employee WHERE Salary >22000;

Answer

DELETE FROM Employee WHERE Salary = 22000;

Question 29

SQL query to find a list of the ID numbers and Marks for

students who have passed IAI

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 30

Find students who studying any Programming module

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 31

A SELECT statement can be nested inside another query to form a

Accepted Answer

Subquery

Answer

Subselect

Answer

Subresults

Answer

Query in query

Question 32

SQL uses privileges to control access to tables and other database objects, so

which is NOT?

Accepted Answer

Drop privilege

Answer

Select privilege

Answer

Update privilege

Answer

Insert privilege

Question 33

How to use privileges in SQL?

Accepted Answer

GRANT ON TO

Answer

ON TO GRANT

Answer

GRANT TO ON

Answer

GRANT ON TO

Question 34

To convert any relation into _______, split any nonatomic values

Accepted Answer

First normal form

Answer

Second normal form

Answer

Third normal form

Answer

Fourth normal form

Question 35

A functional dependency (FD) is a

Accepted Answer

link between two sets of attributes in a relation

Answer

link between three sets of attributes in a relation

Answer

link between all sets of attributes in a relation

Answer

link between four sets of attributes in a relation

Question 36

which if the following does not refer to redundancy problems?

Accepted Answer

CREATE anomalies

Answer

INSERT anomalies

Answer

UPDATE anomalies

Answer

DELETE anomalies

Question 37

To convert any relation into _______, remove transitive dependency

Accepted Answer

Third normal form

Answer

First normal form

Answer

Second normal form

Answer

Fourth normal form

Question 38

To convert any relation into _______, split any nonatomic values

Accepted Answer

First normal form

Answer

Second normal form

Answer

Third normal form

Answer

Fourth normal form

Question 39

A functional dependency (FD) is a

Accepted Answer

link between two sets of attributes in a relation

Answer

link between three sets of attributes in a relation

Answer

link between all sets of attributes in a relation

Answer

link between four sets of attributes in a relation

Question 40

which if the following does not refer to redundancy problems?

Accepted Answer

CREATE anomalies

Answer

INSERT anomalies

Answer

UPDATE anomalies

Answer

DELETE anomalies

Question 41

To convert any relation into _______, remove transitive dependency

Accepted Answer

Third normal form

Answer

First normal form

Answer

Second normal form

Answer

Fourth normal form

Question 42

SQL stands for

Accepted Answer

Structured Query Language

Answer

Sequence Question Language

Answer

Structured Querty Language

Answer

Selection Query Language

Question 43

What is it ?

Accepted Answer

Relation

Answer

Tuples

Answer

Attributes

Answer

Relationships

Question 44

What is it ?

Accepted Answer

Attributes

Answer

Relation

Answer

Tuples

Answer

Relationships

Question 45

What is it ?

Accepted Answer

Tuples

Answer

Relation

Answer

Attributes

Answer

Relationships

Question 46

which if the following does not refer to redundancy problems?

Accepted Answer

CREATE anomalies

Answer

INSERT anomalies

Answer

UPDATE anomalies

Answer

DELETE anomalies

Question 47

To convert any relation into _______, remove transitive dependency

Accepted Answer

Third normal form

Answer

First normal form

Answer

Second normal form

Answer

Fourth normal form

Question 48

To convert any relation into _______, split any nonatomic values

Accepted Answer

First normal form

Answer

Second normal form

Answer

Third normal form

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Science