All About Validated 1D0-541 Test Questions

NEW QUESTION 1
A foreign key maps to a:

• A. prime key.
• B. indirect key.
• C. parent key.
• D. composite key.

Answer: C

NEW QUESTION 2
Consider the table shown in the exhibit. Which relational algebraic operation would return Row 3?

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

Answer: B

NEW QUESTION 3
What is a candidate key?

• A. The primary key for an entity
• B. The key that identifies every instance of an entity
• C. Multiple primary keys that are joined together to form a composite key
• D. A key that may be used to form the primary key

Answer: D

NEW QUESTION 4
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 5
Which subset of Structured Query Language (SQL) is used to perform operations such as data retrieval or deletion on the data contained in a database?

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

Answer: D

Explanation:

NEW QUESTION 6
Consider the Information Engineering diagram in the exhibit showing the relations BUILDING and RESIDENT. What is the relationship between BUILDING and RESIDENT?

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

Answer: B

NEW QUESTION 7
Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

• A. SELECT *FROM Employee;
• B. SELECT ID, Last_Name FROM Employee;WHERE ID = 0004;
• C. SELECT *FROM Employee WHERE Dept_ID = 022;
• D. SELECT *FROM Employee WHERE Dept_ID = 022;

Answer: C

NEW QUESTION 8
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 9
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 10
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 11
Which of the following describes two desirable characteristics of a primary key?

• A. A primary key should be a value that may be null and may change over time.
• B. A primary key should be a value that is not null and will never change.
• C. A primary key should consist of meaningful data and a value that can be changed if needed.
• D. A primary key should not consist of meaningful data and a value that can be changed if needed.

Answer: B

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

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 13
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 14
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 15
Which statement best describes a procedural data manipulation language command?

• A. It contains a query language for retrieving data.
• B. It can be used only to manipulate data through a SQL interface.
• C. The user is not required to know how the underlying data structures are implemented.
• D. It requires that the user know how the underlying data structures are implemented.

Answer: D

NEW QUESTION 16
Consider the following relation definitions:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 ) Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL Student_Number: integer NOT NULL
Building: variable length character string length 25 ) Primary Key Housing_ID
Foreign Key Student_Number References STUDENT(Student_Number) ON DELETE NO ACTION
ON UPDATE CASCADE
What are the referential constraints for the relations defined in these relation definitions?

• A. There is no relationship between changes in STUDENT(Student_Number) and HOUSING(Student_Number).
• B. When STUDENT(Student_Number) is changed or deleted, this modification or deletion will automatically be reflected inHOUSING(Student_Number).
• C. Modifications to HOUSING(Student_Number) are automatically reflected in changes to STUDENT(Student_Number), but deletions are notpermitted.
• D. Modifications to STUDENT(Student_Number) are automatically reflected in changes to HOUSING(Student_Number). For a deletion to occurfrom STUDENT(Student_Number), it must first occur in HOUSING(Student_Number).

Answer: D

NEW QUESTION 17
Which mechanism provides database users with controlled access to the database through the use of virtual tables?

• A. View
• B. Data dictionary
• C. Database control language
• D. Database management system

Answer: A

NEW QUESTION 18
Which database security technique prevents invalid data from being entered into the database?

• A. File locking
• B. User authorization
• C. Parity checks
• D. Integrity controls

Answer: D

NEW QUESTION 19
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 20
......