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. Definition of commands it can do
Indexes
Data Definition
ASC
Views
2. Browser requests page - code is delivered - executed and done with
Dynamic
Aggregate Functions
Web Service
Persistent
3. Specifies the tables or views from which rows and columns are retrieved
Database
Service Broker
FROM
Integrated
4. Used in a SELECT clause in place of a column
Tags
Negation Operator
Aggregate Functions
Hardware
5. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Subqueries
Bind
MAX
Hypertext Markup Language (HTML)
6. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Cookie
ALL
ASC
Functions
7. Two Subquery Cases:Subqueries that return a _______ - Subqueries that retun multiple values
single value
Users
AVG
Stateless
8. One of the tools that SQL uses to find and retrieve data.
Service Requestor
Indexes
Database Management Systems (DBMS)
Interactive SQL
9. Large structured set of persistent data
Database
BETWEEN
Calculated Column
Interactive SQL
10. Three Basic Operations of SP - SR - SB: Publish - Find - ____
ALL
NOT
Bind
Negation Operator
11. Most valuable asset of a database system.
Element Content
Tables
Service-Oriented Architecture (SOA)
Central control of data
12. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Aliases
Application Programmers
ASC
Database
13. Changes the values in one or more selected rows of a table
Database Management Systems (DBMS)
SELECT
UPDATE
Data Administrator (DAd)
14. Give the browser more specific information about that tag
Tables
Attributes
Users
Application Programers
15. 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.
Service Provider
Candidate Keys
Inner SELECT query
Database
16. Grant acces and control to only specific information
UPDATE
Views
LIKE
Forward Slash
17. Three Classes of Users: End Users - ____________ - Database Administrator (DBA)
Integrated
Application Programmers
Information
Views
18. Meaningful info related to database
Database Administrator (DBA)
Data
BETWEEN
Opening tag
19. Data stored by DAd
Data Elements
Information
ALL
Bind
20. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
hidden fields
Hardware
Stateless
Persistent
21. Combines rows from a SELECT statements result table into a group
GROUP BY
ALL
NOT
Aggregate Functions
22. Responsible for technical implementation & maintenance of database on a design & physical level
ASC
Dynamic
Database Administrator (DBA)
Subqueries
23. SQL Commands: Define tables - views - _____ - delete or insert info
Object-Oriented Relational (OOR)
to update
Fields
Opening tag
24. Finds the lowest constant value in a column
Inner SELECT query
Aliases
*
MAX
25. Benefits of Databases:Compactness - Speed - Less Drudgery - Currency -__________
Data Administrator (DAd)
Inner SELECT query
Bind
Central Control of data
26. Flat File Examples: Excel Spreadsheets - _____
Bind
Word
Performance
Embedded SQL
27. Used to remove duplicates from result table
LIKE
Object-Oriented Relational (OOR)
DISTINCT
Property
28. Basic Component of SQL
American Standard Code for Information Interchange (ASCII)
Data Administrator (DAd)
Performance
Tables
29. Practice of writing code into a webpage that is not directly visible to the user
HAVING
SUM
single value
Scripting
30. Compares value of the column in the specified condition with the value specified
Equals Operator
Comparison Operators
SUM
Indexes
31. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Negation Operator
SUM
COUNT
Bind
32. The Web is ___________
Web server
Stateless
Database Management Systems (DBMS)
Report
33. Closed in the start tag by adding a slash to the start tag
Primary Keys
Empty Elements
DISTINCT
Persistent
34. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Hierarchial
Central control of data
Web server
Hierarchial
35. Describe information in a tree styled format
Calculated Column
Query
Hierarchial
Opening tag
36. One huge database to hold all data; Access to data - and use of system to add - update & print records
Embedded SQL
Database Management Systems (DBMS)
Public Key Infrastructure (PKI)
ESC
37. Individuals that use - manipulate or maintain aspects of database
Users
Fields
Web Service
Data Dictionary
38. Selects from specific values in list
Element Content
IN
to update
Scripting
39. Columns containing numbers only
SUM
Subquery
Indexes
Integrated
40. Ongoing record of data reflecting the info defining the database
Structured Query Language (SQL)
Session
Application Programers
Data Dictionary
41. 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
Inner SELECT query
Session
Property
Embedded SQL
42. = - < - > - <= - >= - <> - !
Comparison Operators
Attributes
BETWEEN
Structured Query Language (SQL)
43. Copies multiple records at the same time using a SELECT statement
Application Programers
Aliases
INSERT INTO
Database Administrator (DBA)
44. Some form of output - usually - printed - containing information
Web Service
Views
Object-Oriented Relational (OOR)
Report
45. Has the highest precedence - followed by the AND - OR
Service Requestor
NOT
HAVING
Scripting
46. Practice of writing code into a webpage that is not directly visible to the user
Scripting
Views
Hierarchial
Word
47. Begins an element
Users
Property
Opening tag
Stateless
48. Decides what data is stored in the databse and the manner it is stored
Data Administrator (DAd)
DISTINCT
Data Dictionary
Query
49. Software system designed to support interface for a software asset that manages a specific set of tasks
Primary Keys
Equals Operator
Service Provider
Shared
50. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Outer SELECT query
*
Central control of data
Structured Query Language (SQL)