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. Give the browser more specific information about that tag
Attributes
Comparison Operators
LIKE
Subquery
2. Specifies the tables or views from which rows and columns are retrieved
Negation Operator
COUNT
FROM
SELECT
3. SQL Commands: Define tables - views - _____ - delete or insert info
Users
IN
to update
Fields
4. Columns containing numbers only
Web Service
Service-Oriented Architecture (SOA)
SUM
DELETE
5. Software system designed to support interface for a software asset that manages a specific set of tasks
Data Dictionary
accident
Service Provider
Report
6. Text markups that form an element" sort of a "box" to hold things like text and other elements
Functions
ORDER BY
Tags
*
7. Order in which WHERE clause is evaluated and combined
Data
Service Requestor
Precedence of Logical Operators
Object-Oriented Relational (OOR)
8. Software system designed to support interface for a software asset that manages a specific set of tasks
Service Provider
Outer SELECT query
Tags
ASC
9. Data Definition - Data Manipulation - Data Recovery and Conccurance - Data Dictionary - Performance
Functions
*
MAX
Query
10. Three Basic Operations of SP - SR - SB: Publish - Find - ____
Database Management Systems (DBMS)
Scripting
to update
Bind
11. A common language that could be used when accessing data from any database conforming to its standard - has Less than 30 commands
Calculated Column
Structured Query Language (SQL)
Bind
Persistent
12. Identifies columns to appear in the result
Tables
FROM
SELECT
COUNT
13. Grant acces and control to only specific information
Web Service
Views
Web Browser
Data Elements
14. Computer equipment -Fixed Storage Media - Removeable Storage Media - System Memory - and the Processor
Session
AVG
Hardware
Shared
15. Used in a SELECT clause in place of a column
Web Service
Aggregate Functions
Indexes
Data Recovery & Concurrance
16. SQL finds and retrieves date
Indexes
Database
Negation Operator
Views
17. The Web is ___________
to update
Indexes
Stateless
Precedence of Logical Operators
18. Allows use of single or multiple character wildcards with the underscore or percent symbol
Query
hidden fields
LIKE
Data Administrator (DAd)
19. Data remains unchanged in database
Tables
Relational
Database Management Systems (DBMS)
Persistent
20. Finds the lowest ACII value in column
MIN
Joins
sp_help
Web server
21. Change order of rows in result table
ORDER BY
American Standard Code for Information Interchange (ASCII)
Views
Users
22. Uses relationships between independent entities
Data Elements
Web server
American Standard Code for Information Interchange (ASCII)
Relational
23. Cookie - Two Stages: Stored on user's computer - Automatically transferred from machine to _____
Flat File
Web server
Data Administrator (DAd)
Application Programmers
24. Basic Component of SQL
Indexes
NOT
Tables
ESC
25. All Columns indicated and selected
*
Report
Application Programmers
American Standard Code for Information Interchange (ASCII)
26. Supplies value for the search condition of the SELECT statement containing it
Equals Operator
Calculated Column
Inner SELECT query
DELETE
27. Defines a new column
ESC
Calculated Column
Data Recovery & Concurrance
Interactive SQL
28. Most valuable asset of a database system.
Database
Functions
Central control of data
Users
29. Used with another comparison operator - values become inverted
Web server
to update
Word
Negation Operator
30. Decides what data is stored in the databse and the manner it is stored
Report
single value
Data Administrator (DAd)
Functions
31. Decides what data is stored in the databse and the manner it is stored
Data
ORDER BY
End Users
Data Administrator (DAd)
32. Everything between the start and end tag
Shared
Web Service
Element Content
ALL
33. Command used to show the attributes that define a table.
Hierarchial
Session
Outer SELECT query
sp_help
34. Data in database has ability to be accessed and manipulated by several users
Indexes
COUNT
Shared
Self Join
35. Fields in a relational table that match the primary key from one column to the primary key of another table.
hidden fields
American Standard Code for Information Interchange (ASCII)
Foreign Keys
Inner SELECT query
36. Some form of output - usually - printed - containing information
ORDER BY
Data Elements
Report
Negation Operator
37. Supplies value for the search condition of the SELECT statement containing it
Inner SELECT query
Joins
Equals Operator
*
38. Practice of writing code into a webpage that is not directly visible to the user
Negation Operator
Hardware
Scripting
Central Control of data
39. Finds the lowest ACII value in column
Relational
single value
MIN
Negation Operator
40. Finds the lowest constant value in a column
Application Programmers
HAVING
MAX
Embedded SQL
41. Changes the values in one or more selected rows of a table
HAVING
Element Content
Data Administrator (DAd)
UPDATE
42. Browser requests page - code is delivered - executed and done with
UPDATE
Tables
Application Programers
Dynamic
43. Definition of commands it can do
Inner SELECT query
Data Definition
to update
Interactive SQL
44. Responsible for technical implementation & maintenance of database on a design & physical level
Word
Shared
Database Administrator (DBA)
COUNT
45. Ensures data is correct casings
Structured Query Language (SQL)
American Standard Code for Information Interchange (ASCII)
Candidate Keys
Aggregate Functions
46. 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.
Candidate Keys
Web Browser
Central control of data
Dynamic
47. 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
End Users
Public Key Infrastructure (PKI)
Persistent
Data Dictionary
48. Table displayed in ascending order
ASC
Precedence of Logical Operators
Property
Element Content
49. Compares value of the column in the specified condition with the value specified
Performance
Joins
SUM
Equals Operator
50. Allows use of single or multiple character wildcards with the underscore or percent symbol
ASC
HAVING
ORDER BY
LIKE
Sorry!:) No result found.
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