Databases Flashcards
Which data type is used to represent product order code that composes alphanumeric characters?
String
- What database is sorted by using an assigned name and number?
Character string
Why is it important to ensure that data support business goals
To aid in making strategic decisions
In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?
Knowledge
Which field must contain a unique value in order for a relational database table to function?
Primary Key
What are the three main categories of databases?
Flat file, relational, hierarchal
What is the database administrator’s role in security?
To institute protocols to protect the databases from external threats
What is the role of drivers in facilitating communication between applications and databases?
They allow the application to interact with the database.
Which SQL clause is used to inform the database management system (DBMS) which tables should be interrogated by the query?
HERE
What indicates a specific Internet location?
The IP address
Which part of a Uniform Resource Locator (URL) identifies the location of the document on the server?
Resource path ID
Which part of a Uniform Resource Locator (URL) identifies the location of the document on the server?
Resource path ID
Which transmission medium should be used when sending data transmissions from Singapore to Mexico City?
Radio signals
What statement is true concerning compiled and interpreted computer language?
A compiler translates an entire program into executable program, which can be run at a later time, while the interpreter does this incrementally.
Which language is often used for rapid prototyping and the creation of GUIs?
Python
Which language is often used for rapid prototyping and the creation of GUIs?
Python
Which is true of databases and the applications that interact with them?
Which is true of databases and the applications that interact with them?
Which is a characteristic of high-level languages?
The source code has to be compiled.
How does an interpreter work?
It takes the most recently entered instructions, converts it into machine language, and executes it.
Which risk assessment question is part of the Initiation Phase?
Could the end users reject the outcome of the project?
Which risk assessment question is part of the Initiation Phase?
Could the end users reject the outcome of the project?
What effect does scope creep have on a project?
It increases unplanned costs for the project.
What effect does scope creep have on a project?
It increases unplanned costs for the project.
ng user needs in the design of an information system?
Which system requirement is an example of considering user needs in the design of an information system?
Allowing secure access to customer account information
Which type of systems testing includes having the customer test the system in an operational setting to see if it is useful?
User Acceptance
Which type of systems conversion involves starting the conversion with a portion of end users?
Pilot
Which type of systems conversion involves starting the conversion with a portion of end users?
Pilot
What are two necessary elements of business continuity planning?
Assessing key organizational activities
Identifying risks that may occur
What is a role of the systems administrator?
To install and maintain network resources
What is a role of the systems administrator?
To install and maintain network resources
What are two necessary elements of business continuity planning?
Assessing key organizational activities
Identifying risks that may occur
Which is a characteristic of high-level languages?
The source code has to be compiled.
Which regulation governs the actions of a company in the case of data records being compromised, lost, or stolen?
Security Breach Notification laws
Which transmission medium should be used when sending data transmissions from Singapore to Mexico City?
Radio signals
Which is true of databases and the applications that interact with them?
Which is true of databases and the applications that interact with them?
What effect does scope creep have on a project?
It increases unplanned costs for the project.
