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

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 2
Which term best defines a database system in which data records are stored with no structured relationships between the records?

• A. Flat-file database
• B. Relational database
• C. Distributed database
• D. Object-oriented database

Answer: A

NEW QUESTION 3
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 4
Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

• A. Data Definition Language
• B. Data Control Language
• C. Data Entity Language
• D. Data Manipulation Language

Answer: B

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

What is the output of this SQL statement?

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

Answer: D

NEW QUESTION 6
Consider the Orders relation shown in the exhibit. Which of the following SQL statements would replace the value in the Sales_Rep_No column with 110 everywhere that Sales_Rep_No 108 is listed?

• A. UPDATE Sales_Rep_No IN Orders SET(Sales_Rep_No = 110WHERE Sales_Rep_No = 108);
• B. UPDATE OrdersSET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;
• C. UPDATE OrdersSET Sales_Rep_No = 110;
• D. UPDATE OrdersWHERE Sales_Rep_No = 108 SET Sales_Rep_No = 110;

Answer: B

NEW QUESTION 7
Consider the following relational algebraic expression:

Which of the following SQL statements is equivalent to this relational algebraic expression?

• A. SELECT Sales_Rep_No(108) FROM Orders;
• B. INSERT INTO OrdersVALUES(Sales_Rep_No = 108) WHERE Sales_Rep_No = NULL;
• C. SELECT *FROM OrdersWHERE Sales_Rep_No = 108;
• D. SELECT *FROM OrdersWHERE Sales_Rep_No = 108;

Answer: C

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

• A. Integrity
• B. Privacy
• C. Availability
• D. Confidentiality

Answer: C

NEW QUESTION 9
Which security technique limits access by unauthorized users to parts of an enterprise database?

• A. Views
• B. Concurrency
• C. Locking
• D. Integrity controls

Answer: A

NEW QUESTION 10
The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?

• A. One-to-many, complex, and recursive
• B. Complex, recursive, and many-to-many
• C. Redundant, recursive, and many-to-many
• D. One-to-many and one-to-one

Answer: B

NEW QUESTION 11
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 12
Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

• A. CREATE TABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY,Bldg_Name VARCHAR (20),Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL,FOREIGN KEY Building_ID REFERENCES RESIDENT (Building_ID) ON DELETE NO CHECK);
• B. CREATE TABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY,Bldg_Name VARCHAR (20),Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL,FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECKON UPDATE CASCADE);
• C. CREATE TABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY,Bldg_Name VARCHAR (20),Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL,FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECKON UPDATE CASCADE);
• D. CREATE TABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY,Bldg_Name VARCHAR (20),Location VARCHAR (20), Room_Count INTEGER ); CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,Room_Num INTEGER, Res_Name VARCHAR (20), Building_ID INTEGER NOT NULL,FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECKON UPDATE CASCADE);

Answer: C

NEW QUESTION 13
What is a virtual table?

• A. A virtual table is a relation created as the result of data manipulation, and is not a permanent part of the database.
• B. A virtual table is a relation stored in the databases memory; it is used when multiple users access the same relation in a database.
• C. A virtual table is a relation created from a defined base table; it contains metadata about the base relation.
• D. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Answer: A

NEW QUESTION 14
Using the Customer and Sales_Rep relations shown in the exhibit, you must datermine a relational algebraic expression that will result in the following relation:

Which of the following relational algebraic expressions would result in this relation?

• A. Customer X Sales_Rep
• B. (Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No (Sales_Rep X Customer))
• C. (Customer X Sales_Rep) ? Sales_Rep.Sales_Rep_No = Customer.Sales_Rep_No
• D. Customer.Sales_Rep_No = Sales.sales_Rep_No (Customer X Sales_Rep)

Answer: A

NEW QUESTION 15
Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database design phase is completed, which of the following is a valid DBDL description of the base relations for the ER diagram?

• A. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberCLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
• B. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberCLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_NumForeign Key Class_Num References STUDENT
• C. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberSTU_CLASS(Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num
• D. STUDENT(Student_Number: integer NOT NULLName: variable length character string length 20 NOT NULL) Primary Key Student_NumberSTU_CLASS(Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS(Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

Answer: D

NEW QUESTION 16
Consider the Recreation relation in the exhibit. A data operation that changes one of the tuples for Student_ID 1003 must be performed. It is necessary to change one of the activities from swimming to tennis. The Student_ID and Activity attributes make up the primary key for the Recreation relation. All related information must be altered, as well. Which SQL statement or statements would best accomplish this?

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 17
Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

• A. Degree of a relation
• B. Cardinality of a relation
• C. Primary key of a relation
• D. Determinant of a relation

Answer: B

NEW QUESTION 18
For the Employee relation shown in the exhibit, which set of column values holds the complete tuple for the employee named James Smith?

A. 0002, James, Smith

• A. 0002, James, Smith, 10-25-76
• B. First_Name, James, Last_Name, Smith
• C. Emp_ID, 0002, First_Name, James, Last_Name, Smith

Answer: B

NEW QUESTION 19
Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?

• A. 1 = attribute, 2 = entity, 3 = relationship
• B. 1 = entity, 2 = relationship, 3 = attribute
• C. 1 = relationship, 2 = entity, 3 = attribute
• D. 1 = relationship, 2 = attribute, 3 = entity

Answer: C

NEW QUESTION 20
......