1D0-541無料問題集「CIW v5 Database Design Specialist」

質問 1

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the
Recreation relation that will return the following data:
Which SQL statement applied to the Recreation relation will return this data?

（A）SELECT Activity FROM Recreation WHERE DISTINCT Activity;

（B）SELECT Activity FROM Recreation;

（C）SELECT Activity FROM Recreation WHERE NOT LIKE Activity;

（D）SELECT DISTINCT Activity FROM Recreation;

正解：D 解答を投票する

質問 2

Which term describes an attribute or combination of attributes that uniquely identifies a row in a relation?

（A）Attribute group

（B）Entity

（C）Domain

（D）Primary key

正解：D 解答を投票する

質問 3

What is a data dictionary?

（A）Metadata that is stored in tables and is only accessible by the DBMS

（B）An area of the database that is directly accessible by the user

（C）Data that is stored in tables and is only accessible by the DBMS

（D）A system catalog containing user data

正解：A 解答を投票する

質問 4

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 NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num

（B）STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
STU_CLASS(
Student_Number: integer NOT NULL
Class_Num: integer NOT NULL)
Primary Key Student_Number, Class_Num
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num

（C）STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
CLASS(
Class_Num: integer NOT NULL
Class_Name: integer NOT NULL)
Primary Key Class_Num
Foreign Key Class_Num References STUDENT

（D）STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
STU_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

正解：B 解答を投票する

質問 5

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）D

（B）B

（C）C

（D）A

正解：D 解答を投票する

質問 6

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

（A）SELECT * FROM Registration WHERE Course_Code LIKE _

（B）SELECT * FROM Registration WHERE Course_Code = #

（C）SELECT* FROM Registration WHERE Course_Code LIKE %

（D）SELECT * FROM Registration WHERE Course Code = %

正解：C 解答を投票する

質問 7

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

（A）Serialization

（B）Parallelism

（C）Concurrency control

（D）Database control

正解：C 解答を投票する

質問 8

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）Implementation

（B）Conceptual

（C）Logical

（D）Physical

正解：C 解答を投票する

質問 9

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

（A）Data Manipulation Language

（B）Data Definition Language

（C）Database Entity Language

（D）Data Query Language

正解：B 解答を投票する

質問 10

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

（A）A recursive relationship

（B）A one-to-many relationship

（C）A many-to-many relationship

（D）A one-to-one relationship

正解：C 解答を投票する

1D0-541 無料問題集「CIW v5 Database Design Specialist」

弊社を連絡する

関連リンク

トップ試験