RAT questions BFOR 300
The key must indicate the row's position in the table
A candidate key must satisfy all of the following conditions EXCEPT:
Functional dependencies
A constraint where the value of one attribute determines the value of another attribute is called a(n):
Logically
A database is an organized collection of _______ related data
transitive
A dependency where one or more nonkey attributes are dependent on another nonkey attribute is called a ____________ dependency.
Causes two tables with a common domain to be combined into a single table or view.
A join operation
attributes
A person's name, birthday, and social security number are all examples of:
Enterprise key
A primary key whose value is unique across all relations is called a(n):
Constraint
A rule that CANNOT be violated by database users is called a(n):
DDL
A set of commands used to define a database
DML
A set of commands used to update and query a database
Subquery
A type of query that is placed within a WHERE or HAVING clause of another query is called a:
repository
A(n) ____ contains important metadata for managing the database
Maximize storage space
All of the following are the main goals of normalization except:
Homonym
An attribute that may have more than one meaning is called a(n):
Drop
Any create command may be reversed by using a(n) _______ command
Define one vehicle entity type to hold all entities
Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
entities
Customers, cars, and parts are examples of:
entireprise data modeling
Database development begins with _______, which establishes the range and general contents of organizational databases.
TRUE
EXISTS will take a value of ________ if the subquery returns an intermediate results table which contains one or more rows.
A listing of all drivers who made more than 2 deliveries as well as a count of the number of deli8veries made by the driver
Given table Delivery_T (DeliveryID (PK), driver_no, destination) what will be returned for the following SQL query? SELECT Driver_no, Count(*) AS Num_deliveries FROM Delivery_T GROUP BY Driver_no HAVING Count(*)>2;
3
How many relations in total are resulted from mapping a binary many-to-many relationship?
4
How many relations in total are resulted from mapping a ternary relationship?
WHERE
In an SQL SELECT statement, which of the following parts states the conditions for row selection?
Both output compatible data types for each column and return the same number of columns
In order for two queries to be UNION-compatible, they must:
SELECT
In the SQL language, which of the following statements is NOT used to make table definitions?
Recursive foreign
In the figure below, what type of key is manager_ID (manager_ID is at the end of the entity dotted underline, connected to employee_ID (primary key) by an arrow)
An associative entity
In the figure to the right, what is depicted? (three entities, the outer two connecting to the middle one which has a composite primary key).
Must be an outpatient or a resident patient but not both
In the figure, a patient: (basically describing disjoint rule but by looking at the diagram above).
AuPhone and AuName
In the following, which attribute needs to be removed in order for the table to be in 1NF (ISBN (one number), Title (single title), AuName(multiple authors), Auphone(multiple numbers), Price(single number))
Tables
In the relational data model, data is represented in the form of:
Patient_Name
In the supertype/subtype diagram being used the attributes in the supertype applies to both subtype entities
A person can marry at most one person
Single box "person" connected by is_married_to and optional 1 on each end
There are attributes that apply to some but not all instances of an entity type
Subtypes should be used when
Create view
The SQL command _____ defines a logical table from one or more tables or views.
Disjoint
The _____ rule specifies that an entity can be a member of only one subtype at a time
Entity integrity
The _______ states that no primary key attribute may be null
Total Specialization
The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.
Create Schema
The command for creating a database is:
Domain constraints
The figure below does NOT contain an example of: (Logical Schema with customer, order, order-line, product. other options for answers are graphical schema, primary key, foreign key, composite primarykey, it has all of them)
Non-correlated subquery
The following code is an example of a: SELECT Customer_name, Customer_address FROM Custoer WHERE customer.customer_id=(SELECT order.customer_id FROM order WHERE order_id=1008);
partial dependency
The following figure does NOT include an example of (assuming none of the attributes are multi-valued) (PK orderID connected to orderDate, customerID, CustomerID connected to CustomerName, Customer address, other choices = transitive dependency, primary key 2NF relation, 1NF relation)
Equi-join
The following query is an example of a(n): SELECT customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID=Order_T.CustomerID
ORDER BY
The last part of an SQL query to be processed is the ________ clause
Entity-Relationship model
The logical representation of an organization's data is called a(n):
One
The number of entity types that participate in a unary relationship is:
Attribute inheritance
The property by which subtype entities possess the values of all attributes of a supertype is called:
Systems Development Life Cycle
The traditional methodology used to develop, maintain and replace information systems is called the:
Only rows that match both Customer_T and Order_T tables
This query would include: SELECT customer_T.CustomerID, Order_T.CustomerID, CustomerName, OrderID FROM Customer_T, Order_T WHERE Customer_T.CustomerID=Order_T.CustomerID
Alters the Customer_T table, and adds a field called "Type"
What does the following SQL statement do? ALTER TABLE Customer_T ADD Type Varchar (2);
The first product description alphabetically in product_T will be shown
What will result from the following SQL query? SELECT MIN(product_Description) FROM Product_T;
Supertype
Which of the following has a relationship with one or more subtypes
Eliminated data redundancy
Which of the following is NOT an advantage of database systems
To specify syntax and semantics of SQL data definition and manipulation
Which of the following is a purpose of the SQL standard?
Strong
Which of the following is an entity that exists independently of other entity types?
An entity type name does NOT have to be unique
Which of the following is not true?
*
Which of the following is the wildcard character used in WHERE clause?
Modification
____________ anomalies can be caused by editing data in tables.
Database analysts
____________ concentrate on determining the requirements and design for the database component of the information system.
Dynamic view
a _________ Is materialized when referenced
DCL
a set of commands used to9 control a database, including security.
Composite
an attribute that can be broken down into smaller parts is called a(n) ______ attribute:
You must specify the fields to insert if you are only inserting some of the fields
given a table named store with 5 fields: store_id, address, city, state, zipcode, why would the following insert command not work? (INSERT INTO store VALUES ("234 Park Street");
DBA_TABLES
if the DBA wishes to describe all tables in the database
Provide rapid random and sequential access to base-table data
indexes are created in most RDBMSs to:
degree
the number of entity types that participate in a relationship is called the:
No two rows in a relation are identical
which of the following are properties of relations?
Square with double box around the outside, says 'dependent' in it
which of the following shows a weak entity: