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. SQL finds and retrieves date
Indexes
NOT
Web Service
Application Programmers
2. Used in a SELECT clause in place of a column
Precedence of Logical Operators
COUNT
Aggregate Functions
LIKE
3. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Hardware
DISTINCT
Tables
Indexes
4. Changes the values in one or more selected rows of a table
UPDATE
Flat File
Query
hidden fields
5. Text markups that form an element" sort of a "box" to hold things like text and other elements
Stateless
Bind
ORDER BY
Tags
6. Limits the rows that appear in the result mathcing a specified condition
Web Applications
Inner SELECT query
GROUP BY
WHERE
7. Characterizes operation of a relational database
Embedded SQL
Data Recovery & Concurrance
Joins
Central Control of data
8. The Web is ___________
hidden fields
Service Requestor
Stateless
Cookie
9. Used to combine one query with another.
Subquery
Service Requestor
Views
Comparison Operators
10. Allows data recovery in case of corruption or loss
Data Recovery & Concurrance
Self Join
Data Administrator (DAd)
Tables
11. 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
Interactive SQL
Primary Keys
Service Provider
12. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Attributes
SUM
Word
Data Administrator (DAd)
13. Columns containing numbers only
Data Recovery & Concurrance
SUM
Tags
Report
14. Join a table to a copy of itself
Database Administrator (DBA)
Data Dictionary
BETWEEN
Self Join
15. Attribute in quotes
accident
Property
Inner SELECT query
Element Content
16. Uses two values as limits - selecting any values between the two of them
Application Programmers
BETWEEN
Database Management Systems (DBMS)
Data Manipulation
17. Some form of output - usually - printed - containing information
accident
Outer SELECT query
Report
Fields
18. Table displayed in descending order
ESC
INSERT INTO
Opening tag
accident
19. Create program files that include SQ after each command
Application Programers
Scripting
INSERT INTO
Embedded SQL
20. Copies multiple records at the same time using a SELECT statement
Relational
Fields
Tags
INSERT INTO
21. Meaningful info related to database
hidden fields
Shared
Data
Inner SELECT query
22. Definition of commands it can do
IN
Data Definition
Stateless
Cookie
23. Selects from specific values in list
IN
MAX
Query
LIKE
24. Network node that discovers and invokes other software services to provide a buisness solution
Service Broker
LIKE
Service Requestor
Embedded SQL
25. Deletes selected rows
DELETE
Persistent
Central Control of data
Negation Operator
26. Writes programs that use or allow acces to databse with specific purpose
COUNT
Application Programers
End Users
End Users
27. SQL Commands - Two Things Specify data interested in - Indicate the ________
Inner SELECT query
Database Management Systems (DBMS)
Persistent
accident
28. 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
Session
GROUP BY
Indexes
Service Broker
29. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Property
Data Elements
Data Recovery & Concurrance
Web server
30. Closed in the start tag by adding a slash to the start tag
Relational
Empty Elements
Performance
Tables
31. Looks like opening tag - but with a forward slash
Subqueries
Closing tag
to update
AVG
32. Data in database has ability to be accessed and manipulated by several users
Shared
Structured Query Language (SQL)
Public Key Infrastructure (PKI)
UPDATE
33. Allow useres to retrieve data and interact with content located on web pages within website
Data Administrator (DAd)
FROM
Web Browser
Central Control of data
34. Finds the lowest ACII value in column
Fields
Equals Operator
accident
MIN
35. Combines rows from a SELECT statements result table into a group
GROUP BY
sp_help
Data Dictionary
Aggregate Functions
36. Columns may be specified for the result table by following the column name with a speace and the alias in the SELECT clause
Subqueries
Negation Operator
Aliases
Opening tag
37. Specifies the tables or views from which rows and columns are retrieved
DISTINCT
Primary Keys
FROM
Object-Oriented Relational (OOR)
38. Basic Component of SQL
Bind
Property
Tables
SUM
39. Interact and manipulates the data in the database
AVG
Data Manipulation
Query
Element Content
40. Combination of attributes that can be uniquely used to identify a database record and is generally the pool from which the primary key is chosen.
Stateless
Candidate Keys
Web server
Central Control of data
41. Data in database interacts & corresponds with other data
Integrated
accident
Cookie
Self Join
42. Deletes selected rows
DELETE
*
Service-Oriented Architecture (SOA)
Query
43. Grant acces and control to only specific information
BETWEEN
Negation Operator
DELETE
Views
44. Data in database interacts & corresponds with other data
COUNT
Closing tag
Integrated
Information
45. Has the highest precedence - followed by the AND - OR
Views
Word
Tags
NOT
46. Network node that discovers and invokes other software services to provide a buisness solution
Hierarchial
Service Requestor
Fields
Interactive SQL
47. Order in which WHERE clause is evaluated and combined
FROM
Precedence of Logical Operators
Dynamic
Scripting
48. Create program files that include SQ after each command
Embedded SQL
Integrated
Foreign Keys
Joins
49. Used to remove duplicates from result table
Tags
DISTINCT
Database
Web Applications
50. Begins an element
Opening tag
Application Programers
Service Provider
Session