Free CompTIA DS0-001 Exam Dumps Questions & Answers

A database administrator needs to ensure continuous availability of a database in case the server fails. Which of the following should the administrator implement to ensure high availability of the database?

• A.  Replication
• B.  ETL
• C.  Backup and restore
• D.  Database dumping

(Which of the following best describes the function of a wildcard in the WHERE clause?)

• A.  An exact match is not possible in a SELECT statement.
• B.  An exact match is not possible in a CREATE statement.
• C.  An exact match is necessary in a CREATE statement.
• D.  An exact match is necessary in a SELECT statement.

(Which of the following statements is TRUNCATE an example of?)

• A.  DDL statement
• B.  DCL statement
• C.  MCL statement
• D.  DML statement

Which of the following best describes a collection of data that shares the same properties or attributes?

• A.  Tuples
• B.  Relation set
• C.  ER model
• D.  Entity set

Which of the following indexes stores records in a tabular format?

• A.  Unique
• B.  Secondary
• C.  Non-clustered
• D.  Columnstore