시험덤프
매달, 우리는 1000명 이상의 사람들이 시험 준비를 잘하고 시험을 잘 통과할 수 있도록 도와줍니다.
  / 98-364 덤프  / 98-364 문제 연습

Microsoft 98-364 시험

Microsoft Database Fundamentals 온라인 연습

최종 업데이트 시간: 2022년05월08일,308문제.

당신은 온라인 연습 문제를 통해 Microsoft 98-364 시험지식에 대해 자신이 어떻게 알고 있는지 파악한 후 시험 참가 신청 여부를 결정할 수 있다.

시험을 100% 합격하고 시험 준비 시간을 35% 절약하기를 바라며 98-364 덤프 (최신 실제 시험 문제)를 사용 선택하여 현재 최신 130개의 시험 문제와 답을 포함하십시오.

 / 21

Question No : 1


You have the following table definition:
CREATE TABLE Product
(ProductID INTEGER,
Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID is 12345.
Which statement should you use?



정답:

Question No : 2


You have a table of products with fields for ProductID, Name, and Price. You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.
Which clause should you use in your update statement?

정답:

Question No : 3


On which database structure does an insert statement operate?

정답:

Question No : 4


Your database contains a table named Customer. You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?



정답:

Question No : 5


You have a table that contains product IDs and product names. You need to write an UPDATE statement to change the name of a specific product to glass.
What should you include in the update statement?

정답:

Question No : 6


You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.
What is the result in the database?

정답:

Question No : 7


First normal form requires that a database excludes:

정답:

Question No : 8


Which statement should you use to remove a foreign key?

정답:

Question No : 9


Which type of index changes the order in which the data is stored in a table?

정답:

Question No : 10


You assign User1 a set of permissions that include the WITH GRANT OPTION.
The WITH GRANT OPTION enables User1 to:

정답:

Question No : 11


What are three valid data manipulation language (DML) commands? (Choose three.)

정답:
Explanation:
. http://en.wikipedia.org/wiki/Data_manipulation_language
Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb . In the case of SQL, these verbs are:
SELECT ... FROM ... WHERE ...
INSERT INTO ... VALUES ...
UPDATE ... SET ... WHERE ...
DELETE FROM ... WHERE ...

Question No : 12


You need to store the first name, last name, and student ID for 100 students.
This information will be stored in a table as:

정답:

Question No : 13


You have a Department table and an Employee table in your database. You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?

정답:

Question No : 14


What is one difference between an update statement and a delete statement?

정답:

Question No : 15


You are creating a table to store customer data. The Account Number column uses values that always consist of one letter and four digits. Which data type should you use for the Account Number column?

정답:

 / 21