Download Database Fundamentals.98-364.BrainDumps.2018-11-13.78q.tqb
| Vendor: | Microsoft |
| Exam Code: | 98-364 |
| Exam Name: | Database Fundamentals |
| Date: | Nov 13, 2018 |
| File Size: | 1 MB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
You have the following table definition:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?
- an error stating that NULL values are not allowed
- a new row in the table
- an error stating that duplicate IDs are not allowed
- a syntax error
Correct answer: B
Question 2
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.
Which data type should you use?
- VARCHAR (3, 30)
- CHAR (3, 30)
- VARCHAR (30)
- CHAR (30)
Correct answer: C
Question 3
One reason to create a stored procedure is to:
- Improve performance.
- Minimize storage space.
- Bypass case sensitivity requirements.
- Give the user control of the query logic.
Correct answer: A
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!