98-364 Exam
Leading 98-364 training Guide
Our pass rate is high to 98.9% and the similarity percentage between our 98-364 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Microsoft 98-364 exam in just one try? I am currently studying for the Microsoft 98-364 exam. Latest Microsoft 98-364 Test exam practice questions and answers, Try Microsoft 98-364 Brain Dumps First.
Q41. Which statement should you use to remove a foreign key?
A. ALTER TABLE
B. DELETE TABLE
C. DELETE FOREIGN KEY
D. ALTER FOREIGN KEY
Answer: A
Q42. You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q43. You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's unique ID.
What will make this type of search more efficient?
A. A cursor
B. A subquery
C. A trigger
D. An index
Answer: D
Q44. You have the database table named Cars as defined below:
You have the following Structured Query Language (SQL) statement:
How many rows are returned by the SQL statement?
A. 4
B. 5
C. 6
D. 7
Answer: A
Q45. You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?
A. all columns
B. only the last column
C. only the first column
D. only the first and last columns
Answer: A
Q46. You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
A. 0
B. 3
C. 6
D. 9
Answer: D
Q47. This question requires that you evaluate the underlined text to determine if it is correct.
ALTER TABLE removes all rows from a table without logging the individual row deletions.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.
A. No change is needed
B. DROP TABLE
C. TRUNCATE TABLE
D. CREATE TABLE
Answer: C
Q48. DRAG DROP
You have two database tables as defined below. The first table contains information about students. The second table contains information about courses. The two tables are related by CourseID.
Match the CourseName to the StudentName.
Instructions: To answer, drag the appropriate CourseName from the column on the left to its StudentName on the right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.
Answer:
Q49. You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.
Which database object should you add to the Sales table?
A. Nonclustered index
B. Primary key
C. Foreign key
D. Clustered index
Answer: B
Q50. While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?
A. Foreign key
B. Index key
C. Link key
D. Default key
Answer: B