ITC FINALS REVIEWER
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?