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. A database has integrity if the data in it satisfies all established integrity constraints
UPDATE
Sysviews
Sysindexes
Integrity
2. Two simple criteria in a query the are combined with the AND or OR operators
PROJECT
Computed Field
Simple Condition
Compound Conditions
3. In Access the query that updates the contents of a table
Qualify
Update Query
Aggregate Functions
CREATE TABLE
4. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Query-By-Example (QBE)
Cascade Delete
Criteria
5. A rule that must be followed by data in a database
Sort
Division
Primary Sort Key
Integrity Constraint
6. The most common form of a join
Unnormalized Relation
Form
Natural Join
Criterion
7. The process of creating collections of records that share some common characteristics
Natural Join
Arguments
Field
Grouping
8. A condition that involves only a single field and a single value
Simple Condition
Catalog
Integrity
Validation Rule
9. The individual or group that is responsible for a database
Legal-Values Integrity
Database Administration (DBA)
Foreign Key
Major Sort Key
10. Combination of criteria in which both criteria must be true
Primary Key
Aggregate Functions
REVOKE
AND Criterion
11. The query that is used to define the structure of a viewk
Defining Query
Design Grid
Syscolumns
Query
12. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
Product
PRIMARY KEY
Database Administration (DBA)
Data Macro
13. The form of a join in which all records appear - even if they don't match
Outer Join
Natural Join
Concatenation
Intersection
14. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Relational Database
Qualify
Database
Sort Key
15. The rule that no column (attribute) that is part of the primary key may accept null values
Entity Integrity
Make-Table Query
Database Management System (DBMS)
Index
16. The plural of Criterion
Catalog
Criteria
Join
Minor Sort Key
17. An access query that creates a table using the results of a query
Validation Text
Make-Table Query
Union
Arguments
18. An association between entities
Relationship
Query-By-Example (QBE)
Qualify
Database Administration (DBA)
19. When sorting on two fields - the less important field
One-to-Many Relationship
HAVING Clause
Minor Sort Key
Database Management System (DBMS)
20. More than one entry at a single location in a table
Criteria
Relation
Validation Rule
Repeating Groups
21. A characteristic or property of an entity
Attribute
Entity
Union
System Catalog
22. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null
Foreign Key
Stored Procedure
Entity-Relationship (E-R) Diagram
Relationship
23. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
Relational Database
Database
Entity
PROJECT
24. The process of arranging rows in a table or results of a query in a particular order
Field
Security
Sort
Intersection
25. A rule that must be followed by data in a database
Query-By-Example (QBE)
Integrity Constraint
Criteria
SELECT
26. A combination of criteria in which at least on the criteria must be true
Single-Field Index
CHECK
OR Criterion
Outer Join
27. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Form
Criteria
Unnormalized Relation
Entity
28. An update option in which related records are automatically updated
Cascade Update
Validation Text
Aggregate Functions
Aggregate Functions
29. The table obtained by concatenating every row in the first table with every row in the second table
Security
Sort
Sysindexes
Product
30. The SQL clause that is used to enforce legal-values integrity
PROJECT
Entity
CHECK
Outer Join
31. A file used to store data about a single entity. Such a file can be thought of as a table.
Entity
Relationship
Aggregate Functions
Data File
32. A screen object you use to maintain or view and print data from a database
Database
Form
UPDATE
Criterion
33. The prevention of unauthorized access to a database
Primary Key
Entity-Relationship (E-R) Diagram
Security
Grouping
34. An access query that creates a table using the results of a query
Make-Table Query
DROP INDEX
Relationship
Data Independence
35. A characteristic or property of an entity
Functions
CREATE INDEX
Data Independence
Attribute
36. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column
Security
Column
Sort Key
Aggregate Functions
37. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Qualify
Database Administrator (DBA)
Major Sort Key
DROP TABLE
38. A query that deletes all records that satisfy some criterion
ORDER BY Clause
OR Criterion
Delete Query
Column
39. The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users
Cartesian Product
Concatenation
View
Database Design
40. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Validation Text
PROJECT
Sort Key
Design Grid
41. 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
Database
Database Administration (DBA)
Relation
Trigger
42. In an Access query the line drawn between tables to indicate how they are related
Null
AND Criterion
Make-Table Query
Join Line
43. A computer that provides services to the clients in a client/server system
Server
One-to-Many Relationship
CREATE TABLE
Union
44. The SQL command that is used to change the structure of a table
Primary Sort Key
ALTER TABLE
Attribute
Null
45. The relational algebra command to select rows from a table
SELECT
Security
Functions
Criterion
46. A message in Access that is displayed when a validation rule is violated
Database
OR Criterion
Validation Text
Syscolumns
47. A collection of relations
Database Management System (DBMS)
Relational Database
Aggregate Functions
UPDATE
48. A characteristic or property of an entity
Arguments
Form
Relationship
Field
49. A program or a collection of programs through which users interact with a database
Relation
Relational Database
Database Management System (DBMS)
Database
50. A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to or at most one occurrence of the first entity
Defining Query
Data File
Natural Join
One-to-Many Relationship
Sorry!:) No result found.
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests