ITC FINALS REVIEWER

¡Supera tus tareas y exámenes ahora con Quizwiz!

False

A Composite key is a candidate key that consists of two or more attributes True False

True

A functional dependency describes the relationship between attributes in a table. True False

True

A subquery that is a part of a tablelist specifies an single calculated column. True False

False

A subquery that is part of a columnlist specifies a criteria. True False

False

A subquery that is part of a condition specifies a data source. True False

Collection of values

Aggregate functions are functions that take a ___________ as input and return a single value.

True

An Attribute is a property of an entity or a relationship type. True False

identifier

An attribute that names or identifies entity instances is a(n):

Full join

Both tables are secondary, such that if rows are being matched in table A and table B, then all rows from table A are displayed.

False

Boyce-Codd Normal Form handles a problem with an entity that might have two primary keys. True False

An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity.

Composite attribute: -An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity -An atribute composed of multiple components each with individual existance -An attribute that holds multiple values for a single component -An attribute that holds a single value for a single entity

many-to-many model

Consider a directed line(->) from the relationship set

The number of participating entities in a relationships

Degree of a relationships

Bottom-up approach

E-R modeling technique is a___

Facilitate database design

ER aims to:

Relationships

Entities can be associated with one another in which of the following?

True

Entity-relationship model yields a graphical representation of entities and their relationship in database structure. True False

False

Fifth Normal Form state that a relation is in this normal form if and only if a Multi-Valued Dependency exists in a table then all attributes of the table are also functionally dependent on A. True False

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature >= 60

Find the cities name with the condition and temperature from table 'whether' where condition = sunny or cloudy but temperature >= 60. -SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature >= 60 -SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' AND condition = 'sunny' OR temperature >= 60 -SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature >= 60 -SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' OR condition = 'sunny' OR temperature >= 60

True

Full functional dependency indicates that if A and B are attributes of a table, B is fully functionally dependent on A if B is functionally dependent on A, but not on any proper subset of A. True False

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

How can you change "Thomas" into "Michel" in the "LastName" column in the Users table? -MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel' -UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas' -UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel' -MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

Only 1

How many Primary keys can have in a table?

Entity

If you were collecting and storing information about your music collection, an album would be considered a(n)_______

False

In database normalization allows multivalued attributes. True False

When a table is deleted.

In which of the following cases a DML statement is not executed?

False

Insert authorization, allows that user to insert column/s in a specific table. True False

Outer join

It does not require each record in the two joined tables to have a matching record.

The Martin Style notation that represents zero or one relationship (optional) is: - **0...1**

It is the Martin Style notation that represents zero or one relationship - optional.

(1,1)

It is the Martin style notation that represents one and only one - mandatory.

(1,n)

It is the Martin style notation that represents one or more relationship - mandatory

drop view

It is used to delete a view that was previously created.

False

It is where A, B, and C are attributes of a table such that, if A is functionally dependent on B and B is functionally dependent on C then C is partially dependent on A via B. True False

Left join

It return all rows from the first table, even if there are no matches in the second table.

Inner join

It returns rows when there is at least one match in both tables.

True

Normalization eliminates insert, delete, and update of anomalies. True False

True

Normalization is the process of organizing data to minimize redundancy in the design of a relational database management system. True False

False

Priviledge_name is the name of a database object in the grant command. True False

Distinct

SELECT COUNT (____ ID) FROM teaches WHERE semester = 'Spring' AND YEAR = 2023;

Avg(salary)

SELECT __________FROM instructor WHERE dept name= 'Comp. Engg.'; Which of the following should be used to find the mean of the salary?

Describe the structure of a database and the associated retrieval transactions

The Conceptual data model is the set of concepts that:

Entity set

The Rectangles divided into two parts represents

Cardinality

The number of entities to which another entity can be related through a relationship set is called?

False

Third normal form is accomplished by eliminating partial dependencies. True False

grant

This is a command used to provide access or privileges on the database objects to the users.

True

To put a table in 2NF, the primary key should be identified. True False

True

To put a table in 2NF, the relationship between the parts of the key and the foreign key mus be determined. True False

Cartesian Products

What is another name for Cross Join?

Simple Join

What is another name for Inner Join?

We can have only one primary key in a table while we can have multiple unique keys

What is the difference between a PRIMARY KEY and a UNIQUE KEY?

You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

What is true about joining tables through an Equijoin? -You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions. -To join two tables through an Equijoin, the columns in the join condition must be primary key and foreign key columns. -You can join a maximum of two tables through an Equijoin. -You can join a maximum of two columns through an Equijoin.

mandatory participation

What type of participation is descried for Table B? One record must exist in Table B before any records any records can be added to Table A.

ALTER

Which command is used to change the definition of a table in SQL?

A data dictionary

Which of the following contains the logical structure for the information in a database?

Entity-relationship diagram

Which of the following gives a logical structure of the database graphically? - Data flow diagram - Database diagram - Entity diagram - Entity-relationship diagram

Minimum cardinality

Which of the following indicates the minimum number of entities that must be involved in a relationship?

Primary keys

Which of the following is NOT a basic element of all versions of the E-R model? -Entities -Attributes -Primary keys -Relationships

delete view

Which of the following is NOT a keyword related to VIEWS? -drop view -create view -delete view -alter view

authorization to cancel data

Which of the following is NOT an SQL privileges type? authorization to read data. authorization to insert new data. authorization to update data. authorization to cancel data.

COMPUTE

Which of the following is not a valid aggregate function?

The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.

Which of the following is true about the SQL AS clause?

all choices are correct

Which of the following is/are the type(s) of Outer Join? - Left Outer Join - Full Outer Join - all choices are correct - Right Outer Join

An entity class

Which of the following refers to a concept, in a relational database, about which you wish to store information and that you can identify with a unique key?

All of the mentioned

Which one is the multi-valued attribute -All of the mentioned -Name -Phone_number -Date_of_birth

A, D

Which two statements are true regarding subqueries? A. A subquery can retrieve zero or more rows. B. Only two subqueries can be placed at one level. C. A subquery can be used only in SQL query statements. D. A subquery can appear on either side of a comparison operator. E. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.

Outer JOIN

Which type of JOIN is used to returns rows that do not have matching values?

CHECK

_______ is a constraint that can be defined only at the column level?


Conjuntos de estudio relacionados

The Biggest Animal on the Planet

View Set

Computer Input - Assignment (ALA)Assignment

View Set

SVSU Psych Quiz Qs 2, 8, 3, 4, 5

View Set

Chapter 2 IP Addressing and Related Topics

View Set