Free DS0-001 Sample Questions — CompTIA DataSys+

A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table. Which of the following describes where the undo is stored?

• A. In the system global area
• B. In the undo tablespace
• C. In the SYSAUX tablespace
• D. In the temporary tablespace

Which of the following firewall types allows an administrator to control traffic and make decisions based on factors such as connection information and data flow communications?

• A. Circuit-level
• B. Stateful
• C. Proxy
• D. Packet

A company needs to prepare a document that establishes the responsibilities, metrics, penalties, and other generalities that a provider would have to fulfill for customers to use its platforms. Which of the following documents meets these requirements?

• A. DOU
• B. SLA
• C. MOU
• D. SOW

Which of the following statements contains an error?

• A. Select EmpId from employee where EmpId=90030
• B. Select EmpId where EmpId=90030 and DeptId=34
• C. Select* from employee where EmpId=90030
• D. Select EmpId from employee

A database administrator set up a connection for a SQL Server instance for a new user, but the administrator is unable to connect using the user's workstation. Which of the following is the most likely cause of the issue?

• A. The SQL Server codes are performing badly
• B. The SQL Server has not been tested properly
• C. The SQL Server ports to the main machine are closed
• D. The SQL Server has many concurrent users