NEW QUESTION 1
Consider the following database information:
domain s_id: integer
domain grd: fixed length character string length 1
STUDENT_GRADE(
Student_Number: s_id NOT NULL Grade: grd )
Primary Key Student_Number
During which phase of the database design process would this information be developed?

• A. Logical
• B. Physical
• C. Conceptual
• D. Implementation

Answer: A

Explanation:

NEW QUESTION 2
To create a view, what are the minimal privileges that a user must have for the relations used to make the view?

• A. GRANT
• B. REVOKE
• C. SELECT
• D. CREATE VIEW

Answer: C

NEW QUESTION 3
Which relational algebraic operation is used to select specific columns (attributes) from a relation?

• A. Union
• B. Difference
• C. Projection
• D. Intersection

Answer: C

NEW QUESTION 4
What is a relational database domain?

• A. A group of attributes
• B. A set of permissible tuple values
• C. A collection of related data items
• D. A set of permissible attribute values

Answer: D

NEW QUESTION 5
Which pair of relational algebraic operations requires union compatibility?

• A. Projection and Cartesian product
• B. Selection and projection
• C. Intersection and difference
• D. Cartesian product and intersection

Answer: C

NEW QUESTION 6
Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

• A. [MISSING]
• B. [MISSING]
• C. [MISSING]
• D. [MISSING]

Answer: C

NEW QUESTION 7
Which of the following is a characteristic of the three-tier database architecture?

• A. A Web browser is used as the application server.
• B. The application logic is centralized on a dedicated server.
• C. A thick client is used to perform business application logic functions locally.
• D. Database application logic and database functionality are integrated and reside on a common server.

Answer: B

NEW QUESTION 8
Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?

• A. m:m
• B. m:n
• C. 1:1
• D. 1:n

Answer: B

NEW QUESTION 9
Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

• A. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Amount;
• B. SELECT (Order_Date, Amount) FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;
• C. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Order_No;
• D. SELECT *FROM OrdersWHERE Order_Date LIKE %02 ORDER BY Amount;

Answer: D

NEW QUESTION 10
The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

• A. Activity_Fee is a determinant of Activity.
• B. Activity_Fee is partially dependent on the primary key.
• C. The table contains a transitive dependency.
• D. Activity_Fee is a determinant of Activity and Student_ID.

Answer: B

NEW QUESTION 11
Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

Which of the following relational algebraic expressions would result in the given table?

• A.
• B.
• C.
• D.

Answer: A

NEW QUESTION 12
What is the highest normal form of the relation(s) shown in the exhibit?

• A. Boyce-Codd normal form
• B. First normal form
• C. Second normal form
• D. Third normal form

Answer: C

NEW QUESTION 13
Which term describes the management of simultaneous transactions to prevent conflicts?

• A. Parallelism
• B. Serialization
• C. Database control
• D. Concurrency control

Answer: D

NEW QUESTION 14
The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

• A. Activity_Fee is a determinant of Activity.
• B. Activity_Fee is partially dependent on the primary key.
• C. The table contains a transitive dependency.
• D. Activity_Fee is a determinant of Activity and Student_ID.

Answer: B

NEW QUESTION 15
Your database administrator has disallowed a group of users from making alterations to the Employees table in your corporate database. The users, known as Group_2, previously had full privileges with the Employees table. Which of the following SQL statements properly removes any alteration privileges from Group_2?

• A. REVOKEINSERT, UPDATE, DELETEON Employees FROM Group_2;
• B. REVOKE UPDATEFOR Employees FROM Group_2;
• C. REVOKEINSERT, UPDATE, DELETEON Employees TO Group_2;
• D. REVOKE UPDATE, DELETEFOR Employees FROM Group_2;

Answer: A

NEW QUESTION 16
Which of the following occurs in a relation when records are added or removed?

• A. The number of domains changes.
• B. The attributes in the table change.
• C. The cardinality of the relation is fixed but the degree varies.
• D. The degree of the relation is fixed but the cardinality varies.

Answer: D

NEW QUESTION 17
What is a domain?

• A. A normalized set of data applicable to a particular relation
• B. A combination of attributes for a relation
• C. A definition of permissible values for one or more attributes
• D. A set of permissible values for one or more relations

Answer: C

NEW QUESTION 18
Which area of database security involves maintaining access to enterprise data?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 19
A relation for a construction company is shown in the exhibit. Which of the following best defines the relationship between Cust_ID and Cust_Name?

• A. Cust_Name is the determinant.
• B. Cust_Name is transitively dependent on Cust_ID.
• C. Cust_ID is transitively dependent on Cust_Name.
• D. Cust_Name is functionally dependent on Cust_ID.

Answer: D

NEW QUESTION 20
......