SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Database Fundamentals
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. When comparing tables an intersection is a new table containing all rows that are in both original tables
Division
Reserved Words
Intersection
SELECT
2. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Database Administrator (DBA)
Qualify
Entity Integrity
Repeating Groups
3. A query in SQL that appears within another
Sort
Query
Subquery
Command
4. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Column
Update Query
Cascade Update
Unnormalized Relation
5. The part of an SQL SELECT command that indicates a sort order
Server
Arguments
ORDER BY Clause
Data File
6. In relational algebra the operation in which two tables are connected on the basis of common data.
Criterion
Data Independence
Join
Database Design
7. A screen object you use to maintain or view and print data from a database
Database Design
Form
Join Line
Delete Query
8. The part of an SQL SELECT command that indicates grouping
Primary Key
Database Administration (DBA)
Integrity Constraint
GROUP BY Clause
9. A collection of relations
Cascade Update
Entity-Relationship (E-R) Diagram
Relational Database
Entity
10. The process of creating collections of records that share some common characteristics
Grouping
Primary Key
Integrity
Entity
11. The individual or group that is responsible for a database
Functions
Aggregate Functions
Database Administration (DBA)
Single-Column Index
12. The prevention of unauthorized access to a database
Entity-Relationship (E-R) Diagram
Security
Calculated Field
Relational Database
13. The field on which data are sorted
Field
Relation
Attribute
Sort Key
14. A characteristic or property of an entity
Primary Sort Key
Attribute
System Catalog
CHECK
15. The part of an SQL SELECT command that indicates the tables in the query
Division
FROM Clause
CHECK
Unnormalized Relation
16. The SQL command that drops (deletes) and index from a table
Primary Sort Key
Qualify
Functions
DROP INDEX
17. A rule that must be followed by data in a database
CREATE INDEX
Column
Integrity Constraint
Calculated Field
18. An association between entities
Relationship
UPDATE
Comparison Operator
Systables
19. A program or a collection of programs through which users interact with a database
Update Query
Validation Text
Database Management System (DBMS)
ALTER TABLE
20. The SQL statement that is used to grant different types of privileges to users of a dataabase
Sysindexes
Outer Join
Delete Query
GRANT
21. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Criteria
Unnormalized Relation
Major Sort Key
Union
22. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Intersection
SELECT
Design Grid
Secondary Sort Key
23. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns
Relation
Validation Text
SELECT Clause
Union
24. The column on which two tables are joined
Data Independence
Integrity
Join Column
Database Design
25. What type of an operator is >= ?
Join Line
Primary Key
Security
Comparison Operator
26. An index built on a single field
Referential Integrity
Primary Key
Relationship
Single-Field Index
27. A rule that must be followed by data in a database
Database Administration (DBA)
Integrity Constraint
CHECK
Union Compatible
28. More than one entry at a single location in a table
Entity
Repeating Groups
Reserved Words
SELECT
29. The part of an SQL SELECT command that restricts the groups to be displayed
Command
Primary Sort Key
HAVING Clause
Arguments
30. The field or fields on which an index is built
Repeating Groups
Index Key
One-to-Many Relationship
Multiple-Field Index
31. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Database Management System (DBMS)
Unnormalized Relation
HAVING Clause
Join
32. The process of arranging rows in a table or results of a query in a particular order
Secondary Sort Key
Data File
Sort
Intersection
33. More than one entry at a single location in a table
Criteria
Repeating Groups
Natural Join
Intersection
34. The SQL command that is used to change the structure of a table
ALTER TABLE
Query-By-Example (QBE)
Qualify
Relation
35. The prevention of unauthorized access to a database
Sort
REVOKE
Sysindexes
Security
36. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Validation Rule
Outer Join
Natural Join
Database
37. The portion of the system catalog that contains index information
Sysindexes
Comparison Operator
Index
Form
38. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate
Join
Arguments
Entity-Relationship (E-R) Diagram
Database Administrator (DBA)
39. The form of a join in which all records appear - even if they don't match
Entity Integrity
Database Design
Update Query
Outer Join
40. A database has integrity if the data in it satisfies all established integrity constraints
Unnormalized Relation
Integrity
Relational Algebra
Database
41. The SQL command used to describe the layout of a table. The word table is followed by the name of the table to be created and then by the names and data types of the column (fields) that comprise the table
ALTER TABLE
SQL (Structured Query Language)
Column
CREATE TABLE
42. When sorting on two fields - the less important field
Grouping
Minor Sort Key
Join
Compound Conditions
43. A data value meaning "unknown" or "not applicable"
Database Management System (DBMS)
Database Management System (DBMS)
Null
Column
44. The most common form of a join
Compound Conditions
Join
Concatenation
Natural Join
45. A field whose value is computed from other fields in the database
ORDER BY Clause
Natural Join
Subquery
Calculated Field
46. The SQL command that creates an index in a table
HAVING Clause
Redundancy
Union
CREATE INDEX
47. The SQL statement that is used to revoke privileges from users of a database
REVOKE
Null
Documenter
Sort
48. A file used to store data about a single entity. Such a file can be thought of as a table.
Delete Query
Data File
Single-Column Index
Compound Conditions
49. Duplication of data or the storing of the same data in more than one place.
Database Administrator (DBA)
Redundancy
Security
Query
50. A person or place or object or event or idea for which you want to store and process data
Entity
Relational Database
Data File
Grouping