Frage 1
Frage
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.
Frage 2
Frage
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.
Antworten
-
No change is needed
-
Table
-
Index
-
Row
Frage 3
Frage
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?
Antworten
-
Nonclustered index
-
Primary key
-
Foreign key
-
Clustered índex
Frage 4
Frage
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?
Antworten
-
Foreign key
-
Index key
-
Link key
-
Default key
Frage 5
Frage
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
Antworten
-
No change is needed
-
DROP TABLE
-
TRUNCATE TABLE
-
ALTER TABLE
Frage 6
Frage
Which type of index changes the order in which the data is stored in a table?
Antworten
-
non-sequential
-
sequential
-
non-clustered
-
clustered
Frage 7
Frage
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?
Antworten
-
A primary key
-
An index
-
A foreign key
-
A unique constraint
Frage 8
Frage
Which two elements are required to define a column? (Choose two.)
Antworten
-
A name
-
A key
-
An index
-
A data type
Frage 9
Frage
Which statement will result in the creation of an index?
Antworten
-
Option A
-
Option B
-
Option C
-
Option D
Frage 10
Frage
The terms “bitmap,” “b-tree,” and “hash” refer to which type of database structure?
Antworten
-
View
-
Function
-
Index
-
Stored procedure
-
Trigger
Frage 11
Frage
One reason to add an index is to:
Antworten
-
Decrease storage space.
-
Increase database security.
-
Improve performance of select statements.
-
Improve performance of insert statements.
Frage 12
Frage
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.
Antworten
-
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...
Frage 13
Frage
Instructions: For each of the following statements, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.
Antworten
-
YES
-
NO
-
YES
-
NO
-
YES
-
NO
-
YES
-
NO