FINALS

Question 1

Inheritance in a generalization hierarchy means that the supertype entity inherits all the attributes of the subtype entity.
Select one:
a. True
b. False

Answer 1

False

Question 2

Which of the following is an example of a partial completeness constraint?
Select one:
a. A supertype “Pet” has subtypes “Dog,” “Cat,” and “Fish.” Each subtype can have any number of pets, including none.
b. A supertype “Building” has subtypes “House” and “Office.” Not all buildings must belong to one of these subtypes.
c. A supertype “Clothing” has subtypes “Shirt,” “Pants,” and “Dress.” Each piece of clothing must either be of the subtypes.

Answer 2

A supertype “Building” has subtypes “House” and “Office.” Not all buildings must belong to one of these subtypes.

Question 3

Which of the following is an example of a partial completeness constraint?
Select one:
a. A supertype “Fruit” has subtypes “Apple” and “Orange.” All fruits must must either be of the subtypes.
b. A supertype “Shape” has subtypes “Circle,” “Square,” and “Triangle.” Not all shapes must belong to one of these subtypes.
c. A supertype “Employee” has subtypes “Manager” and “Worker.” Each subtype can have any number of employees, including none.

Answer 3

A supertype “Shape” has subtypes “Circle,” “Square,” and “Triangle.” Not all shapes must belong to one of these subtypes.

Question 4

All weak entities must have a minimum cardinality of 1 on the entity on which it depends.
Select one:
a. False
b. True

Answer 4

True

Question 5

Specifies that an entity instance can simultaneously be a member of two (or more) subtypes.
Select one:
a. anchor object
b. disjoint rule
c. overlap rule

Answer 5

overlap rule

Question 6

A generic or template data model that can be reused as a starting point for a data modeling project.
Select one:
a. action assertion
b. total specialization rule
c. universal data model

Answer 6

universal data model

Question 7

A supertype should have at least two subtypes.
Select one:
a. True
b. False

Answer 7

True

Question 8

Which of the following is an example of a total completeness constraint?
Select one:
a. A supertype “Person” has subtypes “Employee” and “Manager.” Not all people must belong to one of these subtypes.
b. A supertype “Vehicle” has subtypes “Car,” “Truck,” and “Boat.” Each subtype can have any number of vehicles, including none.
c. A supertype “Animal” has subtypes “Cat,” “Dog,” and “Bird.” All animals must belong to one of these subtypes.

Answer 8

A supertype “Animal” has subtypes “Cat,” “Dog,” and “Bird.” All animals must belong to one of these subtypes.

Question 9

All instances of the subtypes must be an instance of the supertype.
Select one:
a. FALSE
b. TRUE

Answer 9

TRUE

Question 10

Specifies the number of instances of one entity that can (or must) be associated with each instance of another entity.
Select one:
a. weak entity
b. cardinality constraint
c. business rule

Answer 10

cardinality constraint

Question 11

Which of the following is an example of a partial completeness constraint?
Select one:
a. A supertype “Color” has subtypes “Red,” “Blue,” and “Green.” Not all colors must belong to one of these subtypes.
b. A supertype “Document” has subtypes “Invoice,” “Receipt,” and “Quote.” Each subtype can have any number of documents, including none.
c. A supertype “Sport” has subtypes “Basketball,” “Football,” and “Baseball.” Each sport must must either be of the subtypes.

Answer 11

A supertype “Color” has subtypes “Red,” “Blue,” and “Green.” Not all colors must belong to one of these subtypes.

Question 12

Specifies that if an entity instance (of the supertype) is a member of one subtype, it cannot simultaneously be a member of two (or more) subtypes.
Select one:
a. disjoint rule
b. anchor object
c. overlap rule

Answer 12

disjoint rule

Question 13

A generic entity type that has a relationship with one or more subtypes.
Select one:
a. subtype
b. supertype

Answer 13

supertype

Question 14

Which of the following is an example of a total completeness constraint?
Select one:
a. A supertype “Furniture” has subtypes “Couch,” “Chair,” and “Table.” Each subtype can have any number of pieces of furniture, including none.
b. A supertype “Person” has subtypes “Teacher,” “Student,” and “Administrator.” All people must belong to one of these subtypes.
c. A supertype “Vehicle” has subtypes “Car,” “Motorcycle,” and “Bicycle.” Not all vehicles must belong to one of these subtypes.

Answer 14

A supertype “Person” has subtypes “Teacher,” “Student,” and “Administrator.” All people must belong to one of these subtypes

Question 15

Which of the following is an example of a total completeness constraint?
Select one:
a. A supertype “Food” has subtypes “Meat,” “Vegetables,” and “Fruits.” All types of food must belong to one of these subtypes.
b. A supertype “Device” has subtypes “Phone,” “Tablet,” and “Laptop.” Not all devices must belong to one of these subtypes.
c. A supertype “Animal” has subtypes “Mammals,” “Reptiles,” and “Fish.” Each subtype can have any number of animals, including none.

Answer 15

A supertype “Food” has subtypes “Meat,” “Vegetables,” and “Fruits.” All types of food must belong to one of these subtypes.

Question 16

All instances of the supertype are also instances of one of the subtypes.
Select one:
a. False
b. True

Answer 16

True

Question 17

A subtype can have a relationship not shared by the supertype.
Select one:
a. True
b. False

Answer 17

True

Question 18

To remove a relation from a SQL database, we use the ______ command.

Select one:
a. Delete Table
b. Drop Table
c. Remove Table

Answer 18

Drop Table

Question 19

What does SQL stand for?

Select one:
a. Structured Query Language
b. Structured Question Language
c. Strong Question Language

Answer 19

Structured Query Language

Question 20

The BETWEEN SQL keywords specifies

Select one:
a. a list of values
b. a column list
c. a range to test in the SQL query search condition

Answer 20

a range to test in the SQL query search condition

Question 21

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

Select one:
a. Data Manipulation Language
b. Data Control Language
c. Data Definition Language

Answer 21

Data Manipulation Language

Question 22

Which of the following SQL statements has correct syntax?

Select one:
a. SELECT * FROM Table1 WHERE Column1 >= 10
b. SELECT * FROM Table1 WHERE Column1 = = 10
c. SELECT * FROM Table1 WHERE Column1 = > 10

Answer 22

SELECT * FROM Table1 WHERE Column1 >= 10

Question 23

Which one of the following is used to define the structure of the relation, deleting relations and relating schemas ?

Select one:
a. Data Manipulation Language
b. Data Definition Language
c. Data Control Language

Answer 23

Data Definition Language

Question 24

Create table employee (name varchar ,id integer)
What type of statement is this ?

Select one:
a. Data Control Language
b. Data Definition Language
c. Data Manipulation Language

Answer 24

Data Definition Language

Question 25

Which of the following is the correct SQL statement to use to remove rows from a table? Select one: a. remove b. delete c. drop

Answer 25

delete

Question 26

Consider the schema STUDENT(student_id, firstname, lastname, course, year) Which of the following statements displays the id number and firstname of all 1st year students? Select one: a. SELECT* FROM Student WHERE year = 1 b. SELECT student_id, firstname FROM Student WHERE year = 1 c. SELECT * FROM Student WHERE year == 1

Answer 26

SELECT student_id, firstname FROM Student WHERE year = 1

Question 27

Which of the following SQL statements deletes all rows in table called SalesData? Select one: a. DELETE * FROM SalesData b. DELETE ALL SalesData c. DELETE FROM SalesData d. DELETE SalesData

Answer 27

DELETE FROM SalesData

Question 28

Which one of the following deletes all the entries but keeps the structure of the relation? Select one: a. Delete from instructor; b. Delete from r where P; c. Delete from instructor where dept name= ’Finance’;

Answer 28

Delete from instructor;

Question 29

Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995? Select one: a. DROP FROM sales WHERE YEAR = 1995 b. DROP * FROM sales WHERE YEAR = 1995 c. DELETE FROM sales WHERE YEAR = 1995 d. DELETE * FROM sales WHERE YEAR = 1995

Answer 29

DELETE FROM sales WHERE YEAR = 1995

Question 30

Which SQL statement is used to return only different values? Select one: a. DISTINCT b. DIFFERENT c. UNIQUE

Answer 30

DISTINCT

Question 31

Which of the following is the correct SQL statement to use to remove rows from a table? Select one: a. REMOVE ROW b. DROP c. DELETE

Answer 31

DELETE

Question 32

Consider the schema STUDENT(student_id, firstname, lastname, course, year) Which of the following statements displays all records of student? Select one: a. Select all from students b. Either of the two c. Select * from students

Answer 32

Select * from students

Question 33

Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement? Select one: a. / b. $ c. % d. *

Answer 33

%