DS0-001 試験問題を無料オンラインアクセス

Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?

• A.Split the load size in half and run simultaneously.
• B.Split the load size into many transactions.
• C.Batch into small loads and run in parallel.
• D.Batch large loads into one transaction.

Which of the following statements contains an error?

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

Which of the following is a typical instruction that is found on a Linux command-line script and represents a system shell?

• A.#/bin/shell
• B.>/bin/sh
• C./bin/bash
• D.#!/bin/bash

Which of the following is a potential issue raised by enterprise database users?

• A.The need for concurrent access and multiuser updates
• B.The need to manually transfer records to paper
• C.The need to manage long transactions
• D.The need for multiple views or windows into the same database

(A database administrator realizes that certain data was not captured correctly when it was imported. Which of the following commands should the administrator use to fix the issue?)

• A.UPDATE
• B.ALTER TABLE
• C.DELETE
• D.DROP TABLE