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 Management 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. Ensures functions are done efficiently
Application Programers
Structured Query Language (SQL)
Performance
Users
2. Uniquely identify each record in the table and are chosen at the time of table creation. It is recommended that you use a variable such as a Social Security for this.
Persistent
Primary Keys
Flat File
INSERT INTO
3. Looks like opening tag - but with a forward slash
hidden fields
Closing tag
IN
Empty Elements
4. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Element Content
Shared
LIKE
5. Fields in a relational table that match the primary key from one column to the primary key of another table.
Subqueries
Foreign Keys
Query
Comparison Operators
6. Used in a SELECT clause in place of a column
WHERE
Aggregate Functions
Stateless
Web Service
7. Give the browser more specific information about that tag
ORDER BY
Attributes
Functions
Self Join
8. Closed in the start tag by adding a slash to the start tag
Property
Precedence of Logical Operators
Empty Elements
American Standard Code for Information Interchange (ASCII)
9. Uses two values as limits - selecting any values between the two of them
Service Broker
BETWEEN
INSERT INTO
Database Management Systems (DBMS)
10. Looks like opening tag - but with a forward slash
Closing tag
Data Definition
Web Service
Empty Elements
11. Data stored by DAd
Service Requestor
Data Elements
Web Browser
IN
12. Attribute in quotes
Fields
Empty Elements
Property
GROUP BY
13. Begins an element
Central control of data
Word
Structured Query Language (SQL)
Opening tag
14. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Flat File
Database
Central Control of data
Application Programmers
15. Considered the time that a user first accesses a page until a set of amount time - on the server - after their last activity or until the session is explicitly closed
Data Manipulation
End Users
Session
Closing tag
16. Everything in enviroment becomes an object - expands on Priniples of relational databases
Views
*
Object-Oriented Relational (OOR)
Data Manipulation
17. Defines a new column
Hypertext Markup Language (HTML)
Data Dictionary
Dynamic
Calculated Column
18. Used to remove duplicates from result table
ESC
DISTINCT
Property
MIN
19. Order in which WHERE clause is evaluated and combined
Report
Precedence of Logical Operators
Web server
Web Service
20. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Service-Oriented Architecture (SOA)
Functions
Web server
BETWEEN
21. Everything between the start and end tag
Query
Closing tag
Closing tag
Element Content
22. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Aliases
Persistent
*
Query
23. SQL Commands: Define tables - views - _____ - delete or insert info
SUM
Data Definition
Integrated
to update
24. Data in database interacts & corresponds with other data
Interactive SQL
SUM
Integrated
Application Programmers
25. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Session
Relational
Object-Oriented Relational (OOR)
26. System that is composed of a Certificate Authority - certificates - software - services and other cryptographic components to enable authenticity and validation of data and/or entities
Public Key Infrastructure (PKI)
BETWEEN
accident
Embedded SQL
27. Identifies columns to appear in the result
SELECT
Application Programers
Scripting
Application Programmers
28. Change order of rows in result table
FROM
Database Administrator (DBA)
ORDER BY
Data Elements
29. Copies multiple records at the same time using a SELECT statement
Application Programers
Indexes
INSERT INTO
Indexes
30. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Precedence of Logical Operators
Element Content
INSERT INTO
31. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Bind
Attributes
Data Elements
32. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Primary Keys
Web server
*
Opening tag
33. Ensures data is correct casings
MIN
Query
American Standard Code for Information Interchange (ASCII)
Performance
34. Has the highest precedence - followed by the AND - OR
GROUP BY
INSERT INTO
NOT
SUM
35. = - < - > - <= - >= - <> - !
Primary Keys
Comparison Operators
Hardware
Service Broker
36. Software system designed to support interoperable machine - to - machine interaction over a network
NOT
Web Service
Data Recovery & Concurrance
SUM
37. Deletes selected rows
Database
Negation Operator
Opening tag
DELETE
38. Everything in enviroment becomes an object - expands on Priniples of relational databases
Precedence of Logical Operators
Object-Oriented Relational (OOR)
Calculated Column
Subquery
39. Create program files that include SQ after each command
Opening tag
Embedded SQL
Fields
AVG
40. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Functions
Views
Hypertext Markup Language (HTML)
Forward Slash
41. Table displayed in ascending order
End Users
Central control of data
ASC
Query
42. Cookies are more secure than______ - allowing travel on a website without loss of info
Stateless
hidden fields
Comparison Operators
single value
43. Order in which WHERE clause is evaluated and combined
ORDER BY
Service Broker
Opening tag
Precedence of Logical Operators
44. Practice of writing code into a webpage that is not directly visible to the user
Shared
Scripting
Subqueries
Opening tag
45. Limits the rows that appear in the result mathcing a specified condition
single value
WHERE
ESC
DISTINCT
46. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Object-Oriented Relational (OOR)
HAVING
Web server
ALL
47. Columns containing numbers only
SUM
Bind
Report
Closing tag
48. Used to combine one query to another
DELETE
Subqueries
Tags
GROUP BY
49. Concatenated in SQL Server Database software using the addition symbol
Outer SELECT query
AVG
Fields
ASC
50. Supplies value for the search condition of the SELECT statement containing it
COUNT
Integrated
Inner SELECT query
Report