CET_TARDE - MTA Database - INDEX

Beschreibung

Database Fundamentals Quizzes preparing to certification
Hawerth Castro
Quiz von Hawerth Castro, aktualisiert more than 1 year ago
Hawerth Castro
Erstellt von Hawerth Castro vor mehr als 7 Jahre
56
0

Zusammenfassung der Ressource

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.
Antworten
  • No change is needed.
  • Data manipulation language (DML) statements
  • Data definition language (DDL) statements
  • A unique constraint

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
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

CET_TARDE - MTA Database - DIAGNOSTIC4
Hawerth Castro
CET_TARDE - MTA Database - E_COMANDS
Hawerth Castro
CET_TARDE - MTA Database - E_backup_permissions
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 5
Hawerth Castro
CET_TARDE - MTA Mobility and Devices Fundamentals 1
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Database - DIAGNOSTIC5
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 6
Hawerth Castro