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. The relational algebra command to select rows from a table
Data File
Security
Relational Algebra
SELECT
2. 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
AND Criterion
Relation
Trigger
SELECT Clause
3. A person or place or object or event or idea for which you want to store and process data
FROM Clause
Data Independence
Database Design
Entity
4. When sorting on two fields this is the more important field
FOREIGN KEY
Form
DROP TABLE
Primary Sort Key
5. The SQL command used to delete a table
DELETE
Data Independence
Entity Integrity
Index Key
6. When sorting on two fields this is the more important field
Major Sort Key
Intersection
Join
Minor Sort Key
7. A field whose value is computed from other fields in the database
Calculated Field
Delimiter
Computed Field
Field
8. A message in Access that is displayed when a validation rule is violated
Sort Key
Database Design
Validation Text
Security
9. A Characteristic or property of an entity
Calculated Field
Reserved Words
Column
Systables
10. A characteristic or property of an entity
Delete Query
Query
Delete Query
Field
11. The field on which data are sorted
GRANT
Entity-Relationship (E-R) Diagram
Sort Key
Query
12. A combination of two tables consisting of all records that are in either table
Database Design
Cascade Delete
Integrity
Union
13. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE
DELETE
Delete Query
Comparison Operator
Trigger
14. A file used to store data about a single entity. Such a file can be thought of as a table.
View
Division
Sort Key
Data File
15. A database has integrity if the data in it satisfies all established integrity constraints
Primary Key
Major Sort Key
Integrity
Unnormalized Relation
16. The area of memory in MySQL that stores the most recently entered command
Statement History
View
SQL (Structured Query Language)
Stored Procedure
17. A collection of actions in Access that are performed in response to an associated database operation - such as inserting or updating or deleting records.
SUBTRACT
Redundancy
Qualify
Data Macro
18. A file used to store data about a single entity. Such a file can be thought of as a table.
Data File
Design Grid
Integrity Constraint
Relational Database
19. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Database
Relational Algebra
ALTER TABLE
OR Criterion
20. When sorting on two fields - the less important field
REVOKE
Database Design
Update Query
Minor Sort Key
21. A query in SQL that appears within another
Subquery
Integrity Constraint
Data File
Functions
22. The part of an SQL SELECT command that indicates a sort order
PRIMARY KEY
ORDER BY Clause
Computed Field
Relational Database
23. A query that deletes all records that satisfy some criterion
Delete Query
Stored Procedure
Security
Functions
24. A program or a collection of programs through which users interact with a database
Database Management System (DBMS)
Sysindexes
AND Criterion
Column
25. The prevention of unauthorized access to a database
Query-By-Example (QBE)
Sysviews
Security
Product
26. The relational algebra command for performing the difference of two tables
Unnormalized Relation
Relation
Single-Column Index
SUBTRACT
27. The relational algebra command for performing the intersection of two tables
INTERSECT
Reserved Words
Cascade Update
Outer Join
28. A rule that must be followed by data in a database
Form
Join
Query
Integrity Constraint
29. A rule that must be followed by data in a database
Stored Procedure
Query-By-Example (QBE)
Single-Column Index
Integrity Constraint
30. 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
Sort Key
One-to-Many Relationship
Join Line
Unnormalized Relation
31. A field whose value is computed from other fields in the database
Single-Column Index
Calculated Field
Update Query
Natural Join
32. A combination of criteria in which at least on the criteria must be true
OR Criterion
Statement History
Natural Join
Concatenation
33. A condition that involves only a single field and a single value
GRANT
Intersection
Outer Join
Simple Condition
34. A file containing a collection of compiled and optimized SQL statements that are available for future use
Security
Data Macro
Stored Procedure
Defining Query
35. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Secondary Sort Key
Natural Join
Query-By-Example (QBE)
Computed Field
36. 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
ALTER TABLE
Relation
SUBTRACT
Cartesian Product
37. The SQL statement that is used to grant different types of privileges to users of a dataabase
GRANT
Calculated Field
Relational Database
Aggregate Functions
38. 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
Primary Sort Key
CREATE TABLE
Multiple Column Index
Validation Rule
39. 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
Join Line
Intersection
Computed Field
40. A collection of relations
Form
Relational Database
Database Design
Field
41. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Sort
Relationship
Criteria
Design Grid
42. In an Access query the line drawn between tables to indicate how they are related
PROJECT
Join Line
ORDER BY Clause
OR Criterion
43. A characteristic or property of an entity
Integrity Constraint
Make-Table Query
Multiple Column Index
Attribute
44. The portion of the system catalog that contains index information
Sysindexes
GRANT
Index
Database
45. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.
Data Independence
Null
View
Qualify
46. The portion of the system catalog the contains column information
Syscolumns
Concatenation
Primary Sort Key
Calculated Field
47. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on
Design Grid
Functions
Integrity
Validation Text
48. Two simple criteria in a query the are combined with the AND or OR operators
Compound Conditions
REVOKE
Reserved Words
Primary Key
49. The table obtained by concatenating every row in the first table with every row in the second table
View
OR Criterion
Product
Command
50. A word that is part of the SQL language
Database Design
Data Independence
Reserved Words
Outer Join
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