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 punctuation mark - such as a semicolon - that separates pieces of data
Natural Join
Sort
FROM Clause
Delimiter
2. When sorting on two fields this is the more important field
PROJECT
Minor Sort Key
Make-Table Query
Primary Sort Key
3. A condition that involves only a single field and a single value
ORDER BY Clause
Simple Condition
Make-Table Query
Design Grid
4. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Aggregate Functions
OR Criterion
Unnormalized Relation
Sort
5. The individual who is responsible for a database or the head of database administration
Data File
Security
Relationship
Database Administrator (DBA)
6. More than one entry at a single location in a table
Repeating Groups
Data File
Security
Security
7. 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
Unnormalized Relation
WHERE Clause
Database Design
Compound Conditions
8. The relational algebra command for performing the intersection of two tables
Unnormalized Relation
INTERSECT
Server
Referential Integrity
9. The field on which data are sorted
Sort Key
Database Administrator (DBA)
Database Management System (DBMS)
Database Administrator (DBA)
10. A statement the can be either true or false. Also called a condition
Referential Integrity
Validation Rule
Criterion
Column
11. 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
DROP TABLE
Qualify
Aggregate Functions
Outer Join
12. An index built on a single field
Natural Join
Single-Field Index
Entity-Relationship (E-R) Diagram
Database Management System (DBMS)
13. The query that is used to define the structure of a viewk
Computed Field
Defining Query
Compound Conditions
Row-and Column Subset View
14. A word that is part of the SQL language
Aggregate Functions
Calculated Field
Reserved Words
Form
15. More than one entry at a single location in a table
Repeating Groups
INSERT
Database Management System (DBMS)
Union
16. The SQL clause that is used to enforce legal-values integrity
Entity-Relationship (E-R) Diagram
Catalog
DROP TABLE
CHECK
17. When comparing tables an intersection is a new table containing all rows that are in both original tables
Grouping
Intersection
Sysviews
Data File
18. A field whose value is computed from other fields in the database
Secondary Sort Key
Computed Field
Cartesian Product
Criteria
19. A file used to store data about a single entity. Such a file can be thought of as a table.
Entity
Relational Database
Data File
Update Query
20. Two simple criteria in a query the are combined with the AND or OR operators
FROM Clause
Natural Join
Compound Conditions
Validation Rule
21. Two simple criteria in a query the are combined with the AND or OR operators
Data Independence
Relation
Server
Compound Criteria
22. In relational algebra the operation in which two tables are connected on the basis of common data.
Sysindexes
Join
Calculated Field
Functions
23. An index built on more than one field
Multiple Column Index
Sysindexes
DELETE
Secondary Sort Key
24. A query that deletes all records that satisfy some criterion
Defining Query
Delete Query
Computed Field
INSERT
25. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Unnormalized Relation
Primary Sort Key
AND Criterion
Entity
26. A characteristic or property of an entity
Primary Sort Key
Attribute
Database Administrator (DBA)
Comparison Operator
27. Duplication of data or the storing of the same data in more than one place.
Column
Redundancy
Update Query
Query-By-Example (QBE)
28. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Intersection
Database Management System (DBMS)
ORDER BY Clause
Qualify
29. A screen object you use to maintain or view and print data from a database
Outer Join
One-to-Many Relationship
System Catalog
Form
30. A rule that must be followed by data in a database
Repeating Groups
Integrity Constraint
Index
Database Administration (DBA)
31. The process of arranging rows in a table or results of a query in a particular order
Sort
Delete Query
Relationship
Relationship
32. The part of an SQL SELECT command that restricts the groups to be displayed
HAVING Clause
Aggregate Functions
Primary Key
Validation Rule
33. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Make-Table Query
Query-By-Example (QBE)
Database Administration (DBA)
Integrity Constraint
34. 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
ALTER TABLE
One-to-Many Relationship
Functions
Compound Criteria
35. 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
HAVING Clause
Join Line
Integrity Constraint
One-to-Many Relationship
36. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Data Independence
Index Key
Difference
Attribute
37. The table obtained by concatenating every row in the first table with every row in the second table
Product
Natural Join
Secondary Sort Key
DROP INDEX
38. The combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table
Stored Procedure
Concatenation
Single-Column Index
INTERSECT
39. An instruction by a user that directs a database to perform a certain way
Union
Validation Rule
Aggregate Functions
Command
40. A question the answer to which is found in the database
Criterion
Integrity
Sort
Query
41. The most common form of a join
Primary Sort Key
Entity-Relationship (E-R) Diagram
Functions
Natural Join
42. Combination of criteria in which both criteria must be true
Integrity Constraint
AND Criterion
Systables
GRANT
43. A rule that must be followed by data in a database
Referential Integrity
Integrity Constraint
Relational Algebra
Data File
44. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities
PROJECT
Aggregate Functions
Major Sort Key
Database
45. The combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table
Aggregate Functions
Concatenation
Data Independence
Join Line
46. A Characteristic or property of an entity
Database Design
Subquery
Relationship
Column
47. The SQL statement that is used to grant different types of privileges to users of a dataabase
Qualify
Relation
GRANT
Qualify
48. The property that no record can exist in the database with a value in a field other than a legal value
Entity-Relationship (E-R) Diagram
Data File
Legal-Values Integrity
Intersection
49. A file containing a collection of compiled and optimized SQL statements that are available for future use
Sysindexes
Integrity
Stored Procedure
Security
50. Two simple criteria in a query the are combined with the AND or OR operators
Join
Aggregate Functions
Compound Criteria
Security
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