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. An application program's or an individual user's picture of a database
CHECK
Relational Algebra
DROP TABLE
View
2. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
Join Line
Multiple Column Index
Delete Query
PRIMARY KEY
3. 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 Administration (DBA)
Database Design
4. 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
Integrity
Data Independence
Entity-Relationship (E-R) Diagram
Validation Text
5. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Sysviews
Repeating Groups
Data File
Relational Algebra
6. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Relational Algebra
Unnormalized Relation
Unnormalized Relation
Index Key
7. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.
Primary Key
Functions
Data File
Single-Column Index
8. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Relational Database
GRANT
Security
9. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
HAVING Clause
Union
Compound Criteria
Unnormalized Relation
10. A question the answer to which is found in the database
Validation Rule
Data Macro
Query
Entity
11. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Concatenation
Trigger
Qualify
Security
12. When sorting on two fields - the less important field
Database Administration (DBA)
Join
Minor Sort Key
Relational Database
13. When sorting on two fields this is the more important field
Major Sort Key
Primary Sort Key
Security
INSERT
14. Duplication of data or the storing of the same data in more than one place.
Redundancy
Command
Systables
Column
15. Two simple criteria in a query the are combined with the AND or OR operators
Compound Conditions
Attribute
DROP INDEX
Grouping
16. 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
Database Management System (DBMS)
Data File
REVOKE
CREATE TABLE
17. A characteristic or property of an entity
Field
Redundancy
Join
Redundancy
18. The relational algebra command for performing the difference of two tables
Computed Field
INTERSECT
Data Independence
SUBTRACT
19. The table obtained by concatenating every row in the first table with every row in the second table
Cartesian Product
Single-Column Index
Design Grid
Null
20. The SQL command that is used to change the structure of a table
ALTER TABLE
Computed Field
Multiple Column Index
Sort Key
21. In Access the query that updates the contents of a table
Sysindexes
Update Query
SELECT
Union
22. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.
Design Grid
Index
Trigger
Primary Key
23. The individual who is responsible for a database or the head of database administration
Join Column
Database Administrator (DBA)
Relational Database
Compound Criteria
24. Combination of criteria in which both criteria must be true
Relation
Entity
AND Criterion
Entity
25. In Access the query that updates the contents of a table
Compound Conditions
Calculated Field
One-to-Many Relationship
Update Query
26. An association between entities
Join
Cascade Update
Relationship
Union
27. 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
Functions
Concatenation
Simple Condition
AND Criterion
28. The individual who is responsible for a database or the head of database administration
Database Administrator (DBA)
Attribute
HAVING Clause
Data File
29. 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
Aggregate Functions
Redundancy
Integrity
One-to-Many Relationship
30. An index built on a single field
Primary Key
Single-Field Index
Database Administration (DBA)
Database
31. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Query-By-Example (QBE)
Repeating Groups
Foreign Key
Design Grid
32. When comparing tables an intersection is a new table containing all rows that are in both original tables
Intersection
Primary Sort Key
GROUP BY Clause
Relation
33. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups
Database Management System (DBMS)
Relation
Unnormalized Relation
Concatenation
34. Two simple criteria in a query the are combined with the AND or OR operators
INTERSECT
Compound Criteria
Null
SUBTRACT
35. A person or place or object or event or idea for which you want to store and process data
Form
Concatenation
Entity
OR Criterion
36. A characteristic or property of an entity
Qualify
Repeating Groups
Field
REVOKE
37. Two simple criteria in a query the are combined with the AND or OR operators
Compound Criteria
Grouping
Attribute
Unnormalized Relation
38. A word that is part of the SQL language
Criterion
Data Independence
Reserved Words
Multiple Column Index
39. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results
Database Administration (DBA)
Natural Join
WHERE Clause
Validation Text
40. A program or a collection of programs through which users interact with a database
Query
Cascade Delete
Database Management System (DBMS)
Foreign Key
41. The process of creating collections of records that share some common characteristics
Multiple Column Index
Grouping
Query-By-Example (QBE)
UPDATE
42. A Characteristic or property of an entity
Column
Entity
Field
Minor Sort Key
43. A rule in Access that data entered in a field must satisfy
FROM Clause
Repeating Groups
Computed Field
Validation Rule
44. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Data File
Data Independence
Sort
Minor Sort Key
45. An access query that creates a table using the results of a query
Reserved Words
Entity-Relationship (E-R) Diagram
Make-Table Query
Foreign Key
46. 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
Query-By-Example (QBE)
Data File
Database Administration (DBA)
One-to-Many Relationship
47. A database has integrity if the data in it satisfies all established integrity constraints
FOREIGN KEY
Functions
Integrity
Entity-Relationship (E-R) Diagram
48. A very popular relational data definition and manipulation language that is used in many relational DBMS's
Data Macro
Data Independence
Security
SQL (Structured Query Language)
49. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
FOREIGN KEY
Compound Criteria
CHECK
Query-By-Example (QBE)
50. The SQL statement that is used to revoke privileges from users of a database
Query
Query-By-Example (QBE)
Integrity Constraint
REVOKE
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