Question 81
Your enterprise is developing a database system that will contain highly sensitive dat a. Security of the data will take priority over database processing speed. Which database protection technique should be employed?
A. Backups
B. User views
C. Encryption
D. Integrity controls
Answer: C
Question 82
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
Question 83
Consider the following SQL statement and the Orders relation shown in the exhibit:
How many records should be returned?
A. Two records
B. Three records
C. Four records
D. Five records
Answer: C
Question 84
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 Orders
WHERE Order_Date LIKE _02 ORDER BY Amount;
B. SELECT (Order_Date, Amount) FROM Orders
WHERE Order_Date LIKE %02 ORDER BY Amount;
C. SELECT * FROM Orders
WHERE Order_Date LIKE _02 ORDER BY Order_No;
D. SELECT * FROM Orders
WHERE Order_Date LIKE %02 ORDER BY Amount;
Answer: D
Question 85
Which type of relational integrity is violated if a primary key in a database has a null value?
A. Entity integrity
B. Domain integrity
C. Domain constraints
D. Referential integrity
Answer: A
Question 86
The database manager wants to give Rubio and Doe the ability to modify the Project Relation shown in the exhibit. A temporary employee named Temp needs to access the data in the database to generate reports. Which group of SQL statements will perform this task?
A. GRANT UPDATE ON Project TO Rubio, Doe; GRANT SELECT ON Project TO Temp;
B. GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
GRANT UPDATE ON Project TO Temp;
C. GRANT SELECT ON Project WHERE Manager = ‘Rubio’; GRANT SELECT ON Project WHERE Manager = ‘Doe’;
D. GRANT UPDATE ON Project WHERE Manager = ‘Rubio’; GRANT UPDATE ON Project WHERE Manager = ‘Doe’;
GRANT SELECT ON Project TO Temp;
Answer: A
Question 87
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. 11
D. 1n
Answer: B
Question 88
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
Question 89
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
Question 90
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 = 110
WHERE Sales_Rep_No = 108);
B. UPDATE Orders
SET Sales_Rep_No = 110 WHERE Sales_Rep_No = 108;
C. UPDATE Orders
SET Sales_Rep_No = 110;
D. UPDATE Orders
WHERE Sales_Rep_No = 108 SET Sales_Rep_No = 110;
Answer: B
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF