How Many Questions Of 1D0-541 Free Demo

NEW QUESTION 1
Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return the Registration2 relation from the Registration relation?

• A. SELECT Course_Code FROM Registration;
• B. SELECT *FROM RegistrationWHERE Registration_ID = 1003 AND Registration_ID = 1005;
• C. SELECT *FROM RegistrationWHERE Course_Code = 'A4343';
• D. SELECT Registration_ID, Student_ID, First_Name, Last_Name FROM RegistrationWHERE Course_Code = 'A4343';

Answer: C

NEW QUESTION 2
Which statement is used to define a named group of related tables, views, domains and other database objects?

• A. CREATE ENTITY
• B. CREATE INDEX
• C. CREATE DOMAIN
• D. CREATE SCHEMA

Answer: D

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

• A. Mastered
• B. Not Mastered

Answer: A

NEW QUESTION 4
Which subset of Structured Query Language (SQL) is used to create and name database entities?

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

Answer: C

NEW QUESTION 5
The exhibit shows a relation for a companys projects. Which candidate key(s) would best serve as the primary key for this relation?

• A. S_Date and E_Date
• B. Proj_ID
• C. Item_Num and E_Date
• D. Proj_ID and Item_Num

Answer: D

NEW QUESTION 6
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 7
A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?

• A. Fat client
• B. Thin client
• C. Terminal client
• D. Enterprise client

Answer: A

NEW QUESTION 8
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 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
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 11
Your enterprise must decide whether to use a database management system. Which of the following best describes the overall functionality of a DBMS?

• A. A DBMS provides the ability to control data access using Data Manipulation Language.
• B. A DBMS provides the ability to maintain databases while providing increased security for the database.
• C. A DBMS allows users to access the database while allowing only the database administrator to define user views.
• D. A DBMS provides the ability to define, create and maintain databases while providing controlled access to databases.

Answer: D

NEW QUESTION 12
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 13
Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

• A. Entity
• B. Domain
• C. Primary key
• D. Attribute group

Answer: C

NEW QUESTION 14
The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

• A. Only an update anomaly would occur.
• B. An insertion anomaly would occur.
• C. A deletion anomaly would occur.
• D. An update anomaly and a deletion anomaly would occur.

Answer: C

NEW QUESTION 15
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

• A. SELECT *FROM Dept1_Parts EXCEPT(SELECT Part_IDFROM Dept2_Parts);
• B. SELECT *FROM Dept1_Parts MINUS(SELECT Part_IDFROM Dept2_Parts);
• C. SELECT *FROM Dept1_Parts DIFFERENCE (SELECT Part_IDFROM Dept2_Parts);
• D. SELECT *FROM Dept1_Parts DIFFERENCE (SELECT Part_IDFROM Dept2_Parts);

Answer: D

NEW QUESTION 16
......