Database design final
Which of the following best describes the traits of the real world concepts that will be stored in the database?
Attributes
In relational algebra, the ___________ operation defines a relation that is the concatenation of every tuple of relation "R" with every tuple of relation "S".
Cartesian Product
____ are rules that define data integrity for a column or group of columns
Constraints
Which of the following best describes "Primary Key"? repreesents a value for an attribute that is currently unknown or is not applicable to this tuple A named relation corresponding to an entity in the conceptual schema. a set of relation schemas, each with a distinct name the candidate key that is selected to identify tupe uniquely within the relation
D
Which of the following types of statements is used to create database tables and views?
DDL
Which of the following types of statements is used to manipulate information stored in database tables?
DML
Which of the following best describes the "real world" concepts that will be stored in a database
Entity
A FOREIGN KEY constraint that is defined out of line (i.e., after all the column definitions) is not allowed to have a name.
False
A special type of implicit cursor exclusive to PL/SQL is called a cursor FORALL loop.
False
DDL stands for "Distributed Database Language".
False
Relational Algebra and SQL are similar types of languages, i.e., 4GLs, since both are declarative languages instead of procedural languages.
False
The CREATE TABLE statement can only be used to implement constraints for a single column. Constraints that involve more than one column require a different statement.
False
The Oracle 11g Enterprise DBMS does not support writing application programs for the data stored in a database.
False
Typically in a "File- Based" approach, there is much less data redundancy when compared to the "Database Approach"
False
A(n) ____ integrity constraint is the column or set of columns that define a unique identifying value for every row in the table.
Primary key
The __________ module of the DBMS ensures that the database remains in a consistent state in the presence of failures. It is responsible for transaction commit and abort.
Recovery manager
In relational algebra, the ____________ operation works on a single relation "R" and defines a relation that contains only those tuples that satisfy the specified condition.
Selection
Which of the following best describes a database view?
The dynamic result of one or more relational opertaions operating on the base relations to produce another relation
Which multi-user architecture provides a means for centralized processing (i.e., business logic and data processing not on the client computers)?
Three-Tier client server architecture
A control statement in the PL/SQL programming language is a special type of keyword (or set of keywords) used to control the flow through a program.
True
After a table is defined, you can use SQL statements to add data to the table.
True
An alias can be used to refer to a column, typically in a join or a subquery.
True
DML stands for "Database Manipulation Language"
True
In general, applications written using a "File-Based Approach are faster than applications written using a "Database Approach"
True
In the "Cloud Computing" infrastructure as a service (IAAS) model, the operating system is managed by the organization, not the Cloud Service Provider
True
The ____________ of two relations "R" and "S" defines a relation that contains all the tuples of "R", or "S", or both "R" and "S", duplicate tuples being eliminated. "R" and S" must compatible
Union
A(n) ____________________ key establishes a relationship between two tables, in which one is the parent and the other is the child.
foreign
A(n) ____ join combines rows from both tables using matching column names and column values.
natural
A(n) ____________________ is a query that is embedded in another SQL command.
nested query/subquery
A(n) ____ view is a view that can be used to insert a new row into the underlying table, as long as the row would be returned by a query, or the row exists for the view
updatable
Which of the following are advantages of the "Database Approach" when compared to the "File Based Approach" ? (Choose all that apply) Data consistency Improved Security Cost Greater Impact of Failure
1 and 2
Which of the following are functions of a DBMS? (Choose all that apply) Concurrency Control Services Transaction Support Web Server Administrative Services Recovery services
1, 2, and 4
Which of the following do not represent an alternate terminology for the term "tuple"? (Choose all that apply) Column Record Attribute Row
1, 3
Which of the following are some of the benefits of data warehousing? (Choose all that apply) real-time support for high volume online transaction processing (OLTP) systems support for online analytical processing (OLAP) systems support for using archived data to make decisions support for data mining
2, 3 ,4