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
长谷** -
Pass4Testの1D0-541は素晴らしいです。勉強時間が少なくて、1D0-541の問題集は助けになりました。大変ありがとうございました。