Rebirth 98-364 Paper 2021

NEW QUESTION 1
This question requires that you evaluate the underlined text to determine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optimize read performance.
The data in the new table has been denormalized.
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. Normalized
• C. Truncated
• D. Indexed

Answer: A

NEW QUESTION 2
This question requires that you evaluate the underlined text to determine if it is correct. Ports 20 and 21 are the default ports to secure a SQL Server.
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. 1433 and 1434
• C. 411 and 412
• D. 67 and 68

Answer: B

NEW QUESTION 3
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

• A. Recover
• B. Restore
• C. Commit
• D. Attach

Answer: B

NEW QUESTION 4
HOTSPOT
You have the following table:

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 5
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?

• A. The Customer table no longer exists.
• B. The Customer table is unaffected.
• C. The Customer table exists but has no data.
• D. The script fails.

Answer: A

NEW QUESTION 6
One reason to add an index is to:

• A. Decrease storage space.
• B. Increase database security.
• C. Improve performance of select statements.
• D. Improve performance of insert statements.

Answer: C

NEW QUESTION 7
This question requires that you evaluate the underlined text to determine if it is correct. In a database table, each column represents a unique record.
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. Table
• C. Index
• D. Row

Answer: D

NEW QUESTION 8
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

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

• A. CHAR
• B. BYTE
• C. DOUBLE
• D. SMALLINT

Answer: A

NEW QUESTION 10
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

NEW QUESTION 11
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.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 12
You have a table that contains information about all students in your school.
Which SQL keyword should you use to change a student's first name in the table?

• A. UPDATE
• B. CHANGE
• C. SELECT
• D. INSERT

Answer: A

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

• A. INSERT
• B. COMMIT
• C. DELETE
• D. OUTPUT
• E. UPDATE

Answer: ACE

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 ...

NEW QUESTION 14
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?

• A. SET ProduetName = 'glass'
• B. LET ProduetName = 'glass'
• C. EXEC ProduetName = 'glass'
• D. ASSIGN ProduetName = 'glass'

Answer: A

NEW QUESTION 15
HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 16
You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.
The table has the following columns and rows:

When volunteer information changes, you must update the table. You need to change Tia's name to Kimberly.
Which statement should you choose?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: D

NEW QUESTION 17
Which two elements are required to define a column? (Choose two.)

• A. A name
• B. A key
• C. An index
• D. A data type

Answer: AD

NEW QUESTION 18
Which statement deletes the rows where the employee's phone number is not entered?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: A

NEW QUESTION 19
You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: D

NEW QUESTION 20
This question requires that you evaluate the underlined text to determine if it is correct. You have two tables. Each table has three rows.
Nine rows will be included in the Cartesian product of these two tables.
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 corrector.

• A. No change is needed
• B. Zero
• C. Three
• D. Six

Answer: A

NEW QUESTION 21
Data in a database is stored in:

• A. Tables
• B. Queries
• C. Data types
• D. Stored procedures

Answer: A

NEW QUESTION 22
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?

• A. an error stating that NULL values are not allowed
• B. a new row in the table
• C. an error stating that duplicate IDs are not allowed
• D. a syntax error

Answer: B

NEW QUESTION 23
HOTSPOT
The following illustration shows the structure of a clustered index in a single partition:

Instructions: Use the drop-down menus to select the answer choice that completes each statement Each correct selection is worth one point.

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:

NEW QUESTION 24
You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data:

You need to normalize the data to third normal form.
How many tables should you create?

• A. 1
• B. 2
• C. 3
• D. 4

Answer: C

NEW QUESTION 25
......