Consider the table for an employee database shown in the exhibit. What is the degree of the table?
A. 4
B. 25
C. 5
D. 20
正解:C
質問 2:
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 SELECT ON Project
WHERE Manager = 'Rubio';
GRANT SELECT ON Project
WHERE Manager = 'Doe';
B. GRANT UPDATE ON Project
WHERE Manager = 'Rubio';
GRANT UPDATE ON Project
WHERE Manager = 'Doe';
GRANT SELECT ON Project TO Temp;
C. GRANT UPDATE ON Project TO Rubio, Doe;
GRANT SELECT ON Project TO Temp;
D. GRANT ALL PRIVILEGES ON Project TO Rubio, Doe;
GRANT UPDATE ON Project TO Temp;
正解:C
質問 3:
Which concurrency control method should be used only when conflicts between transactions rarely occur?
A. Serialization
B. Locking
C. Optimistic
D. Time stamps
正解:C
質問 4:
What is the most important service provided by a database management system?
A. Provides support for data formatting language commands
B. Allows users to store data in a distributed data repository
C. Provides support for a data manipulation language
D. Translates procedural commands into non-procedural commands
正解:C
質問 5:
Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?
A. A one-to-many relationship
B. A one-to-one relationship
C. A many-to-many relationship
D. A recursive relationship
正解:C
Kirishima -
Pass4Testのは分かりやすさ優先で
1D0-541の知識がない未経験者、学生の方でも
ついてこれるぐらいに初歩からじっくり学べるのは良い点