1D0-541 試験問題を無料オンラインアクセス

In which situation would the DBMS use a serial schedule to execute the transactions?

• A.Concurrent transactions read or write the same data structure.
• B.Concurrent transactions read data from the same data structure.
• C.Concurrent transactions read or write from different data structures.
• D.Concurrent transactions write data to different data structures.

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.

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
  CLASS(
  Class_Num: integer NOT NULL
  Class_Name: integer NOT NULL)
  Primary Key Class_Num
  Foreign Key Class_Num References STUDENT
• C.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
• 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

Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?

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

Which of the following ACID properties requires that a transaction be executed in its entirety or not all?

• A.Isolation
• B.Consistency
• C.Durability
• D.Atomicity