9636745
Beschreibung
Quiz von Hawerth Castro, aktualisiert more than 1 year ago
|
Erstellt von Hawerth Castro
vor fast 7 Jahre
|
|
Frage 1
Frage
What do you call the elimination of redundant data?
Antworten
-
normalization
-
de-duplication
-
loopbacking
-
reduxing
Frage 2
Frage
Which of the following indicates the elimination of repeating groups?
Antworten
-
1NF
-
2NF
-
3NF
-
4NF
Frage 3
Frage
Which of the following indicates the elimination of redundant data?
Antworten
-
1NF
-
2NF
-
3NF
-
4NF
Frage 4
Frage
Which of the following is not a condition for 1NF?
Antworten
-
Table must have no duplicate records.
-
The table must have no multi-valued attributes.
-
There are no primary keys.
-
Entries in the column are of the same data type.
Frage 5
Frage
What would enable you to enforce the uniqueness property of columns, other than a primary key within a table?
Antworten
-
secondary key
-
constant check
-
validator
-
unique constraint key
Frage 6
Frage
What is an attribute or set of attributes that can be used to uniquely identify the row?
Antworten
-
primary key
-
second key
-
unique constraint key
-
foreign key
Frage 7
Frage
What key is replicated from the primary key of one table to a secondary table, and then all the key attributes get duplicated from the primary table?
Antworten
-
primary key
-
second key
-
unique constraint key
-
foreign key
Frage 8
Frage
What type of index sorts the data stored inside the table?
Antworten
-
clustered index
-
non-clustered index
-
quick index
-
primary index
Frage 9
Frage
What type of index has an index key value that points to a data row, which contains the key value?
Antworten
-
clustered index
-
nonclustered index
-
quick index
-
primary index
Frage 10
Frage
What type of field would you make an employee ID?
Antworten
-
standard key
-
foreign key
-
unique constraint key
-
secondary key
Frage 11
Frage
If you define a primary key, which of the following levels have you reached?
Antworten
-
1NF
-
2NF
-
3NF
-
4NF
Frage 12
Frage
Which level eliminates columns not dependent on keys?
Antworten
-
1NF
-
2NF
-
3NF
-
4NF
Frage 13
Frage
Which level of is reached by using primary keys on a table within a SQL Server database?
Antworten
-
1NF
-
2NF
-
3NF
-
4NF
Frage 14
Frage
What structures are used when storing keys for a clustered index?
Antworten
-
root tree
-
reverse root tree
-
B-tree
-
alphabetical
Frage 15
Frage
Which type of index uses pointers that point to row location?
Antworten
-
clustered index
-
nonclustered index
-
quick index
-
primary index
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.