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. Data that has been processed into a format that is understandable by its audience
FROM
Aggregate Functions
Structured Query Language (SQL)
Information
2. SQL Commands: Define tables - views - _____ - delete or insert info
Users
Data Dictionary
to update
Aliases
3. Interact and manipulates the data in the database
Subquery
Data Manipulation
Data
Bind
4. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Scripting
SELECT
Aliases
Database Administrator (DBA)
5. Has the highest precedence - followed by the AND - OR
Empty Elements
accident
Inner SELECT query
NOT
6. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
BETWEEN
Tags
Web server
single value
7. Table displayed in ascending order
Relational
ASC
Users
Property
8. Finds the lowest ACII value in column
Embedded SQL
MIN
IN
Interactive SQL
9. Uses two values as limits - selecting any values between the two of them
Negation Operator
BETWEEN
Tags
Foreign Keys
10. Practice of writing code into a webpage that is not directly visible to the user
Hierarchial
Attributes
Views
Scripting
11. Meaningful info related to database
Users
Hypertext Markup Language (HTML)
Data
Property
12. 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
SUM
Hardware
Negation Operator
Public Key Infrastructure (PKI)
13. Limits the rows that appear in the result mathcing a specified condition
WHERE
End Users
Hierarchial
Hardware
14. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Empty Elements
SUM
Hypertext Markup Language (HTML)
Element Content
15. Text markups that form an element" sort of a "box" to hold things like text and other elements
Tags
Performance
Candidate Keys
INSERT INTO
16. Compares value of the column in the specified condition with the value specified
Equals Operator
American Standard Code for Information Interchange (ASCII)
Functions
Web Browser
17. Attribute in quotes
Property
Subqueries
Report
Public Key Infrastructure (PKI)
18. Fields in a relational table that match the primary key from one column to the primary key of another table.
Foreign Keys
accident
Embedded SQL
Web Applications
19. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Service-Oriented Architecture (SOA)
INSERT INTO
Structured Query Language (SQL)
Web server
20. Network node that discovers and invokes other software services to provide a buisness solution
Cookie
Service Requestor
ASC
Tags
21. One huge database to hold all data; Access to data - and use of system to add - update & print records
Fields
Database Management Systems (DBMS)
Data Manipulation
FROM
22. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Functions
Closing tag
Web server
Flat File
23. Closed in the start tag by adding a slash to the start tag
Central Control of data
Element Content
MAX
Empty Elements
24. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Data Manipulation
Service Broker
ASC
25. Basic Component of SQL
Web Service
Self Join
Tables
Fields
26. Data in database has ability to be accessed and manipulated by several users
Relational
Shared
Session
Self Join
27. Give the browser more specific information about that tag
Tables
Attributes
NOT
Bind
28. 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.
Aliases
Web server
INSERT INTO
Primary Keys
29. Used in a SELECT clause in place of a column
INSERT INTO
Aggregate Functions
ORDER BY
Tags
30. Ongoing record of data reflecting the info defining the database
Web Applications
Calculated Column
Data Dictionary
Report
31. SQL Commands: Define tables - views - _____ - delete or insert info
Web server
Interactive SQL
to update
Service Broker
32. All Columns indicated and selected
*
Shared
Precedence of Logical Operators
Property
33. Command based way to ask the database a question
Hypertext Markup Language (HTML)
accident
Functions
Query
34. Order in which WHERE clause is evaluated and combined
Aliases
Web Applications
Precedence of Logical Operators
Data Dictionary
35. Specifies the tables or views from which rows and columns are retrieved
FROM
Closing tag
Relational
single value
36. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Structured Query Language (SQL)
Candidate Keys
Application Programmers
ASC
37. Basic Component of SQL
Tables
Forward Slash
LIKE
accident
38. Identifies columns to appear in the result
Fields
Users
SELECT
Empty Elements
39. Decides what data is stored in the databse and the manner it is stored
Fields
Outer SELECT query
Data Administrator (DAd)
Structured Query Language (SQL)
40. Characterizes operation of a relational database
FROM
WHERE
Fields
Joins
41. Finds the lowest constant value in a column
MAX
SUM
Data Recovery & Concurrance
single value
42. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Web Service
Candidate Keys
Functions
Database Administrator (DBA)
43. Straight implementation of raw data formatted into rows and columns
Outer SELECT query
Application Programers
Equals Operator
Flat File
44. Attribute in quotes
Integrated
IN
Property
Scripting
45. Finds the lowest constant value in a column
*
MAX
Integrated
Hypertext Markup Language (HTML)
46. Change order of rows in result table
Precedence of Logical Operators
ORDER BY
Web Applications
single value
47. Command based way to ask the database a question
Database Administrator (DBA)
Query
End Users
Report
48. Straight implementation of raw data formatted into rows and columns
Hierarchial
Flat File
Aggregate Functions
Indexes
49. Table displayed in ascending order
Indexes
Dynamic
Query
ASC
50. Data stored by DAd
Comparison Operators
Data Elements
Subquery
Database Management Systems (DBMS)