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. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
HAVING
Indexes
single value
Public Key Infrastructure (PKI)
2. Closed in the start tag by adding a slash to the start tag
Structured Query Language (SQL)
Empty Elements
Subquery
Bind
3. SQL finds and retrieves date
Indexes
End Users
BETWEEN
GROUP BY
4. Attribute in quotes
Property
GROUP BY
ALL
Precedence of Logical Operators
5. Change order of rows in result table
ORDER BY
MIN
Structured Query Language (SQL)
Aliases
6. Text markups that form an element" sort of a "box" to hold things like text and other elements
Equals Operator
Tags
Shared
Web server
7. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Web Service
Relational
Calculated Column
8. Data in database interacts & corresponds with other data
Word
Self Join
Integrated
HAVING
9. Data remains unchanged in database
Persistent
Precedence of Logical Operators
UPDATE
Users
10. Join a table to a copy of itself
Cookie
Self Join
Opening tag
LIKE
11. Practice of writing code into a webpage that is not directly visible to the user
Cookie
American Standard Code for Information Interchange (ASCII)
Persistent
Scripting
12. Characterizes operation of a relational database
UPDATE
Joins
SUM
Persistent
13. Ensures data is correct casings
Property
Structured Query Language (SQL)
American Standard Code for Information Interchange (ASCII)
Data Recovery & Concurrance
14. Straight implementation of raw data formatted into rows and columns
hidden fields
Subquery
Flat File
ORDER BY
15. Finds the lowest ACII value in column
MIN
Flat File
sp_help
Data
16. Cookies are more secure than______ - allowing travel on a website without loss of info
hidden fields
FROM
WHERE
HAVING
17. Large structured set of persistent data
FROM
Integrated
Database
Shared
18. Order in which WHERE clause is evaluated and combined
Information
Interactive SQL
Persistent
Precedence of Logical Operators
19. Selects from specific values in list
Users
Candidate Keys
IN
BETWEEN
20. Data in database interacts & corresponds with other data
Integrated
ESC
MAX
Comparison Operators
21. Responsible for technical implementation & maintenance of database on a design & physical level
IN
Database Administrator (DBA)
SUM
Shared
22. Basic Component of SQL
SUM
BETWEEN
Shared
Tables
23. Uses two values as limits - selecting any values between the two of them
GROUP BY
MIN
Data
BETWEEN
24. All Columns indicated and selected
Element Content
*
Service Requestor
Session
25. Tally of how many rows meet criteria specified
Embedded SQL
COUNT
Forward Slash
Scripting
26. Ongoing record of data reflecting the info defining the database
MAX
Data Dictionary
Data
Views
27. Network node that discovers and invokes other software services to provide a buisness solution
Relational
Service Requestor
IN
WHERE
28. Limits the output of the established groups into the derived result table
Hypertext Markup Language (HTML)
HAVING
Negation Operator
MAX
29. Uses two values as limits - selecting any values between the two of them
BETWEEN
LIKE
AVG
Information
30. 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
Primary Keys
IN
Public Key Infrastructure (PKI)
Interactive SQL
31. Data stored by DAd
COUNT
Data Elements
Web server
American Standard Code for Information Interchange (ASCII)
32. Everything between the start and end tag
Empty Elements
Element Content
DELETE
Views
33. Columns containing numbers only
Calculated Column
Application Programers
SUM
hidden fields
34. Executes commands one at a time - results being displayed immediately
Interactive SQL
Hierarchial
Tags
Web server
35. Large structured set of persistent data
Application Programers
Structured Query Language (SQL)
Database
Dynamic
36. Used in a SELECT clause in place of a column
Data Dictionary
MIN
Aggregate Functions
Data Dictionary
37. Order in which WHERE clause is evaluated and combined
COUNT
Outer SELECT query
Precedence of Logical Operators
Web Applications
38. 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
Embedded SQL
Indexes
Session
Database
39. SQL Commands: Define tables - views - _____ - delete or insert info
Indexes
Forward Slash
Shared
to update
40. Describe information in a tree styled format
SUM
DISTINCT
Hierarchial
Cookie
41. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
UPDATE
Functions
Query
INSERT INTO
42. Data that has been processed into a format that is understandable by its audience
AVG
Information
LIKE
Database
43. Allow useres to retrieve data and interact with content located on web pages within website
Service Broker
single value
Web Browser
Primary Keys
44. Software system designed to support interface for a software asset that manages a specific set of tasks
Inner SELECT query
Data Dictionary
Service Provider
Word
45. Selects from specific values in list
Functions
Data Administrator (DAd)
Application Programers
IN
46. Create program files that include SQ after each command
Embedded SQL
Data Elements
Functions
IN
47. Closed in the start tag by adding a slash to the start tag
Empty Elements
to update
Cookie
Indexes
48. SQL Commands: Define tables - views - _____ - delete or insert info
Hardware
UPDATE
Central Control of data
to update
49. Writes programs that use or allow acces to databse with specific purpose
Joins
Application Programers
hidden fields
Property
50. Has the highest precedence - followed by the AND - OR
HAVING
Data
NOT
Scripting