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 individual who is responsible for a database or the head of database administration
Database Management System (DBMS)
Integrity Constraint
Division
Database Administrator (DBA)
2. A field whose value is computed from other fields in the database
Functions
Computed Field
PRIMARY KEY
Update Query
3. A rule that must be followed by data in a database
Secondary Sort Key
Difference
Command
Integrity Constraint
4. The property that lets you change the structure of a database without requiring you to change the programs that access the database
Primary Sort Key
Entity-Relationship (E-R) Diagram
Data Independence
OR Criterion
5. A screen object you use to maintain or view and print data from a database
Form
Multiple Column Index
Entity
DROP TABLE
6. A Characteristic or property of an entity
ALTER TABLE
Relational Algebra
Column
Qualify
7. The relational algebra command used to select columns from a table
PROJECT
Relationship
Form
Integrity
8. A rule that must be followed by data in a database
Delete Query
Integrity Constraint
Integrity
Aggregate Functions
9. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)
Security
Concatenation
PRIMARY KEY
SQL (Structured Query Language)
10. The part of an SQL SELECT command that indicates the columns to be included in the query results
Data Independence
SELECT Clause
Criterion
Single-Field Index
11. A rule that must be followed by data in a database
Integrity Constraint
Primary Key
Database Administrator (DBA)
Database Management System (DBMS)
12. In relational algebra the operation in which two tables are connected on the basis of common data.
Join
Database Administration (DBA)
Relationship
Security
13. 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
Entity-Relationship (E-R) Diagram
Redundancy
Row-and Column Subset View
Repeating Groups
14. A file used to store data about a single entity. Such a file can be thought of as a table.
Cartesian Product
Data File
Relational Database
Database
15. 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
Integrity
Form
Column
16. A screen object you use to maintain or view and print data from a database
Form
Integrity Constraint
Simple Condition
Index Key
17. An access tool that provides documentation about the objects in a database
Natural Join
Documenter
SELECT Clause
Delimiter
18. The form of a join in which all records appear - even if they don't match
Outer Join
Multiple-Field Index
Functions
AND Criterion
19. The column on which two tables are joined
PRIMARY KEY
Documenter
Join Column
Trigger
20. 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
One-to-Many Relationship
Database Administrator (DBA)
Column
Compound Conditions
21. 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
Database Administration (DBA)
Foreign Key
Entity-Relationship (E-R) Diagram
Database Administrator (DBA)
22. The SQL statement that is used to revoke privileges from users of a database
Comparison Operator
REVOKE
Relation
Database
23. 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
Unnormalized Relation
One-to-Many Relationship
Single-Field Index
Database Administration (DBA)
24. The part of an SQL SELECT command that restricts the groups to be displayed
Concatenation
SELECT
HAVING Clause
SELECT
25. 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
Multiple-Field Index
One-to-Many Relationship
Foreign Key
Unnormalized Relation
26. The SQL command used to delete a table
Criterion
DELETE
Aggregate Functions
Cascade Delete
27. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations
Functions
Relational Algebra
Data Macro
Join Column
28. 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
Sort
One-to-Many Relationship
Aggregate Functions
Delete Query
29. The SQL command that drops (deletes) and index from a table
Grouping
Entity
Union
DROP INDEX
30. A collection of relations
Relational Database
Join
INTERSECT
AND Criterion
31. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms
Query-By-Example (QBE)
Entity
Multiple Column Index
Grouping
32. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database
Qualify
SELECT Clause
Catalog
Database Design
33. The field on which data are sorted
Intersection
Sort Key
Systables
Database
34. A person or place or object or event or idea for which you want to store and process data
Relationship
Entity
Criteria
Primary Key
35. 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
Server
Database Design
Data File
Legal-Values Integrity
36. The most common form of a join
Computed Field
Natural Join
Database
Qualify
37. A characteristic or property of an entity
Attribute
Major Sort Key
Criteria
Sysviews
38. The table obtained by concatenating every row in the first table with every row in the second table
Update Query
Multiple Column Index
Product
Functions
39. A database has integrity if the data in it satisfies all established integrity constraints
Redundancy
Cartesian Product
Relation
Integrity
40. The field on which data are sorted
ORDER BY Clause
Sort Key
Union Compatible
Attribute
41. An application program's or an individual user's picture of a database
Sysindexes
Redundancy
System Catalog
View
42. Additional information required by an action in a data macro to complete the action
Field
Arguments
Entity-Relationship (E-R) Diagram
Database Management System (DBMS)
43. An instruction by a user that directs a database to perform a certain way
Command
Integrity Constraint
Join
Design Grid
44. A field whose value is computed from other fields in the database
Sort Key
Calculated Field
Join Line
Redundancy
45. The portion of the system catalog that contains index information
Sysindexes
PROJECT
Column
Major Sort Key
46. A punctuation mark - such as a semicolon - that separates pieces of data
Delimiter
Integrity
Single-Column Index
Relationship
47. A person or place or object or event or idea for which you want to store and process data
Outer Join
Database Administration (DBA)
Entity
Product
48. What type of an operator is >= ?
Comparison Operator
Entity-Relationship (E-R) Diagram
Join Line
Database Administrator (DBA)
49. More than one entry at a single location in a table
AND Criterion
Repeating Groups
FOREIGN KEY
One-to-Many Relationship
50. A file containing a collection of compiled and optimized SQL statements that are available for future use
Stored Procedure
Query
Primary Sort Key
Aggregate Functions