Pregunta 1
Pregunta
This question requires that you evaluate the underlined text to determine if it is correct. Use indexing to create, remove, or change database objects.
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.
Pregunta 2
Pregunta
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.
Respuesta
-
No change is needed
-
Table
-
Index
-
Row
Pregunta 3
Pregunta
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?
Respuesta
-
Nonclustered index
-
Primary key
-
Foreign key
-
Clustered índex
Pregunta 4
Pregunta
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?
Respuesta
-
Foreign key
-
Index key
-
Link key
-
Default key
Pregunta 5
Pregunta
This question requires that you evaluate the underlined text to determine if it is correct. The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those 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 correct
Respuesta
-
No change is needed
-
DROP TABLE
-
TRUNCATE TABLE
-
ALTER TABLE
Pregunta 6
Pregunta
Which type of index changes the order in which the data is stored in a table?
Respuesta
-
non-sequential
-
sequential
-
non-clustered
-
clustered
Pregunta 7
Pregunta
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?
Respuesta
-
A primary key
-
An index
-
A foreign key
-
A unique constraint
Pregunta 8
Pregunta
Which two elements are required to define a column? (Choose two.)
Respuesta
-
A name
-
A key
-
An index
-
A data type
Pregunta 9
Pregunta
Which statement will result in the creation of an index?
Respuesta
-
Option A
-
Option B
-
Option C
-
Option D
Pregunta 10
Pregunta
The terms “bitmap,” “b-tree,” and “hash” refer to which type of database structure?
Respuesta
-
View
-
Function
-
Index
-
Stored procedure
-
Trigger
Pregunta 11
Pregunta
One reason to add an index is to:
Respuesta
-
Decrease storage space.
-
Increase database security.
-
Improve performance of select statements.
-
Improve performance of insert statements.
Pregunta 12
Pregunta
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.
Respuesta
-
return large results sets
-
return a large of values by using the...
-
do not use ORDER BY or GROUP BY clauses
-
are accessed randomly
-
are accessed sequentially
-
are not unique or contain many commom...
Pregunta 13
Pregunta
Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.
Respuesta
-
YES
-
NO
-
YES
-
NO
-
YES
-
NO
-
YES
-
NO