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. Finds the lowest ACII value in column
INSERT INTO
Application Programmers
Aliases
MIN
2. Compares value of the column in the specified condition with the value specified
Application Programers
Query
Central Control of data
Equals Operator
3. Ensures functions are done efficiently
Scripting
Performance
American Standard Code for Information Interchange (ASCII)
Interactive SQL
4. SQL Commands: Define tables - views - _____ - delete or insert info
ASC
Indexes
Empty Elements
to update
5. Uses two values as limits - selecting any values between the two of them
Web server
Web Applications
Central Control of data
BETWEEN
6. Used to remove duplicates from result table
single value
Embedded SQL
DISTINCT
AVG
7. SQL Commands - Two Things Specify data interested in - Indicate the ________
Subqueries
American Standard Code for Information Interchange (ASCII)
Tags
accident
8. Defines a new column
Equals Operator
Calculated Column
COUNT
Flat File
9. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Property
Data Definition
SUM
Outer SELECT query
10. Data stored by DAd
Data Manipulation
UPDATE
Users
Data Elements
11. Data in database interacts & corresponds with other data
Integrated
Aggregate Functions
Flat File
Data Manipulation
12. Computer programs allowing website visitors to submit and retrieve data to/from a database over the Internet using their preferred web browser
Relational
Tables
sp_help
Web Applications
13. Aggregates Five Functions: COUNT - MAX - MIN - ___ - AVG
Web Applications
SUM
FROM
GROUP BY
14. Copies multiple records at the same time using a SELECT statement
Service Provider
INSERT INTO
Data Dictionary
End Users
15. SQL finds and retrieves date
Flat File
Data Definition
Indexes
Relational
16. Ensures functions are done efficiently
Performance
Closing tag
Bind
WHERE
17. Used to remove duplicates from result table
Equals Operator
SELECT
LIKE
DISTINCT
18. Change order of rows in result table
Empty Elements
FROM
ORDER BY
Joins
19. Decides what data is stored in the databse and the manner it is stored
to update
Data Administrator (DAd)
Web server
Negation Operator
20. Data in database has ability to be accessed and manipulated by several users
Shared
Performance
Integrated
Flat File
21. Data that has been processed into a format that is understandable by its audience
Flat File
Relational
Subqueries
Information
22. Used in a SELECT clause in place of a column
Data Elements
ORDER BY
Data Definition
Aggregate Functions
23. Specifies the search condition is TRUE if the comparison is TRUE for every value that the subquery returns
ALL
Service Requestor
COUNT
Cookie
24. Text markups that form an element" sort of a "box" to hold things like text and other elements
BETWEEN
Tags
SELECT
DISTINCT
25. Executes commands one at a time - results being displayed immediately
Hierarchial
Interactive SQL
Tags
NOT
26. Writes programs that use or allow acces to databse with specific purpose
Public Key Infrastructure (PKI)
Persistent
MAX
Application Programers
27. One huge database to hold all data; Access to data - and use of system to add - update & print records
Central Control of data
Tags
Service Requestor
Database Management Systems (DBMS)
28. Basic Component of SQL
Tables
Opening tag
MIN
Inner SELECT query
29. Has the highest precedence - followed by the AND - OR
NOT
Service Broker
Opening tag
Data Recovery & Concurrance
30. Used with another comparison operator - values become inverted
Web Service
Negation Operator
IN
ASC
31. Specifies the tables or views from which rows and columns are retrieved
Service Provider
DELETE
Closing tag
FROM
32. Begins an element
Forward Slash
Object-Oriented Relational (OOR)
Opening tag
Word
33. Table displayed in ascending order
Central Control of data
ASC
Views
Cookie
34. Grant acces and control to only specific information
Property
Views
HAVING
single value
35. Looks like opening tag - but with a forward slash
Closing tag
HAVING
Service Broker
single value
36. Practice of writing code into a webpage that is not directly visible to the user
Data Administrator (DAd)
Data Elements
Data Definition
Scripting
37. Averages the numeric values
Report
Closing tag
MAX
AVG
38. Tally of how many rows meet criteria specified
Bind
Subqueries
Subquery
COUNT
39. SQL finds and retrieves date
Candidate Keys
Users
Indexes
Web Applications
40. All Columns indicated and selected
Data Dictionary
ESC
*
IN
41. Data that has been processed into a format that is understandable by its audience
Information
Hierarchial
AVG
Database Management Systems (DBMS)
42. Copies multiple records at the same time using a SELECT statement
INSERT INTO
Application Programmers
Shared
ALL
43. Turns plain text documents into full multimedia and often interactive information resources. _________ forms the building blocks of every webpage
Hypertext Markup Language (HTML)
IN
ASC
Application Programmers
44. Uses relationships between independent entities
Aggregate Functions
Relational
single value
Session
45. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Flat File
Central control of data
Functions
Joins
46. Columns containing numbers only
SUM
Comparison Operators
Service-Oriented Architecture (SOA)
Query
47. Everything in enviroment becomes an object - expands on Priniples of relational databases
Web Service
Indexes
ALL
Object-Oriented Relational (OOR)
48. The Web is ___________
Shared
Negation Operator
Stateless
Primary Keys
49. Describe information in a tree styled format
Hierarchial
BETWEEN
IN
single value
50. Command used to show the attributes that define a table.
Web Service
American Standard Code for Information Interchange (ASCII)
Primary Keys
sp_help
Can you answer 50 questions in 15 minutes?
Let me suggest you:
Browse all subjects
Browse all tests
Most popular tests
Major Subjects
Tests & Exams
AP
CLEP
DSST
GRE
SAT
GMAT
Certifications
CISSP go to https://www.isc2.org/
PMP
ITIL
RHCE
MCTS
More...
IT Skills
Android Programming
Data Modeling
Objective C Programming
Basic Python Programming
Adobe Illustrator
More...
Business Skills
Advertising Techniques
Business Accounting Basics
Business Strategy
Human Resource Management
Marketing Basics
More...
Soft Skills
Body Language
People Skills
Public Speaking
Persuasion
Job Hunting And Resumes
More...
Vocabulary
GRE Vocab
SAT Vocab
TOEFL Essential Vocab
Basic English Words For All
Global Words You Should Know
Business English
More...
Languages
AP German Vocab
AP Latin Vocab
SAT Subject Test: French
Italian Survival
Norwegian Survival
More...
Engineering
Audio Engineering
Computer Science Engineering
Aerospace Engineering
Chemical Engineering
Structural Engineering
More...
Health Sciences
Basic Nursing Skills
Health Science Language Fundamentals
Veterinary Technology Medical Language
Cardiology
Clinical Surgery
More...
English
Grammar Fundamentals
Literary And Rhetorical Vocab
Elements Of Style Vocab
Introduction To English Major
Complete Advanced Sentences
Literature
Homonyms
More...
Math
Algebra Formulas
Basic Arithmetic: Measurements
Metric Conversions
Geometric Properties
Important Math Facts
Number Sense Vocab
Business Math
More...
Other Major Subjects
Science
Economics
History
Law
Performing-arts
Cooking
Logic & Reasoning
Trivia
Browse all subjects
Browse all tests
Most popular tests