Online Access Free DS0-001 Practice Test

A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?

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

Which of the following commands is part of DDL?

• A.CREATE
• B.INSERT
• C.UPDATE
• D.GRANT

A database administrator has been asked to assign a user the ability to view a data set. Which of the following practices best describes this request?

• A.Security audit
  C Database audit
• B.Password policy implementation
• C.Access control

A database administrator is new to a company and wants to create a document that illustrates the interaction between tables. Which of the following should the administrator create?

• A.Database reference manual
• B.Troubleshooting guide
• C.Entity relationship diagram
• D.Data dictionary

(A healthcare company relies on contact forms and surveys on its website to properly communicate with patients. To which of the following attacks is the company's data most vulnerable?)

• A.SQL injection
• B.DoS
• C.Brute-force
• D.Ransomware