30 Questions
What field data type would you use to store a person's name in an MS Access database?
Short Text
Which data type in MS Access would you select to store a link to a document or file?
Hyperlink
What is the purpose of the AutoNumber field data type in Microsoft Access?
Generate unique values for each new record
Which data type should be chosen if precision up to 4 decimal places is required for storing monetary data?
Currency
If you need to store dates and times in an MS Access database, which data type should you use?
Date/Time
Which field data type would you select in MS Access to store large amounts of alphanumeric data such as sentences and paragraphs?
Long Text
What is the purpose of 'minOccurs' in XML schema?
To specify whether an element is mandatory or optional
How is the end tag for simple groupings typically represented in XML schema?
</xsd:simpleType>
What does 'maxOccurs' define in an XML schema?
The maximum allowable number of occurrences for an element in a grouping
Which attribute is used to define whether an element is mandatory or optional?
minOccurs
How is an attribute defined within an XML schema?
<xsd:attribute>
What indicates the end of a complex type definition in XML schema?
</xsd:complexType>
What is the range of values that can be stored in a Single data type?
-3.402823E38 to -1.401298E-45
Which data type would be appropriate for storing numbers with the highest magnitude range?
Double
Which Number format would display the value as a percentage?
Percent
What is the smallest value that can be stored in a Double data type?
-4.94065645841247E-324
Which Number format would display the value with at least one digit and follow regional settings for negative amounts and decimal places?
Fixed
What is the maximum value that can be stored in a Decimal data type?
-10^38 -1
What is the wildcard symbol that searches for a pattern including any number of characters?
In a truth table, what is the result when both A and B are true in an AND operation?
True
Which operator in a conditional statement checks if a value is greater than or equal to another value?
>=
What does the keyword 'IN' represent in a conditional statement?
Membership in a list
What does the WHERE clause 'Age > 26' signify?
Age is greater than 26
Which operator checks if a value is not equal to another value in a conditional statement?
<>
What is the main purpose of Group Decision Support Systems (GDSS) in a Business Intelligence System?
Integrating data from multiple sources and formatting results into reports
Which category of BI system would be most useful for a company looking to predict future outcomes based on patterns and relationships in data?
Data-mining systems
What is a key function of Knowledge-Management (KM) systems within a Business Intelligence System?
Creating value from intellectual capital and sharing human knowledge
Which BI system component encapsulates the knowledge of human experts in the form of If/Then rules?
Expert systems
In a Business Intelligence System, which system is responsible for improving decision making by providing the right information to the right user at the right time?
Group Decision Support Systems (GDSS)
Which type of system computes correlations of items on past orders to determine ones frequently purchased together in a Business Intelligence System?
Data-mining systems
Learn the process of converting an ERD into a relational database in MS Access. Understand how to transform entities into tables, define field metadata, enforce relationships, and work with different data types such as Short Text, Long Text, and Number.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free