Sir Oli Trial Exam Flashcards
For the situation below, identify the dimension of quality information that was primarily considered.
When the developer coded the application with the proper arrangement of report columns and sorted appropriately
Relevant
For the situation below, identify the dimension of quality information that was primarily considered.
When a developer coded a module that displays data as a reference for the user as a result of studying what data the user will need to effectively make decisions.
Relevant
For the situation below, identify the dimension of quality information that was primarily considered.
When a developer tests the formula multiple times so that the results of the computations will be the same as the expected results
Accurate
For the situation below, identify the dimension of quality information that was primarily considered.
When the database designer designed the database that can serve the data requirements of several applications that will be developed
Flexible
For the situation below, identify the dimension of quality information that was primarily considered.
Deciding to use a QR Code scanner instead of keyboard entry
Reliability
For the situation below, identify the dimension of quality information that was primarily considered.
Customers can immediately see the summary of the orders they made and the amount they need to pay
Timely
For the situation below, identify the dimension of quality information that was primarily considered.
When a developer coded a module that can allow the user to see the total unpaid dues and check for the history of unpaid dues of the user
Completeness
For the situation below, identify the dimension of quality information that was NOT primarily considered.
When the developer developed a module loaded with information that caused the users to be confused and overwhelmed
Simple
TRUE OR FALSE
Determining the most frequently bought product based on the quantity ordered by customers for a specified month and year, is considered transforming data into information
True
TRUE OR FALSE
Data is transformed into information only when it involves computations that can change the values of the data.
False
TRUE OR FALSE
Checking if the entered data is valid or has a value is considered transforming data to information
False
TRUE OR FALSE
Manipulating data is about retrieving data from the database and displaying it in the application
False
TRUE OR FALSE
Data Management cannot be performed when the contents of the database is empty
False. You can still define tables, relationships, and rules that do not need pre-existing data.
TRUE OR FALSE
Data Management and Data Manipulation is the same
False. Data Manipulation is part of Data Management
TRUE OR FALSE
In ANSI-SPARC, Views and Representations are the same
False
TRUE OR FALSE
In ANSI-SPARC, Views and Database Views are the same
False. Database views are more specific tools (like virtual tables) created using SQL. Views are more general and refer to how users interact with the data.
TRUE OR FALSE
In ANSI-SPARC, Internal View is the same as Physical View
True
TRUE OR FALSE
In ANSI-SPARC, the mapping of the conceptual view to the physical view is defined by the Database Designer
False. Physical view is the internal structure, and only the DBMS knows that and can map it.
TRUE OR FALSE
In ANSI-SPARC, the conceptual to physical views are defined by the Database Administrator
False
TRUE OR FALSE
In ANSI-SPARC, the external view is always in Conceptual Representation
True
TRUE OR FALSE
In ANSI-SPARC, the conceptual view is always in Conceptual Representation
False
If you are asked to develop an application that will maintain data about rentals, and it will only be used by one user at a time. What type of application is best developed?
File-Based Application
What component of the Database System is this activity being performed
The actual data is being updated and deleted.
Database Management System
What component of the Database System is this activity being performed
Updates and Deletes on actual are permanently done
Database
What component of the Database System is this activity being performed
Performs file operations as needed
Database Management System
What component of the Database System is this activity being performed
Collects data from end-users
Database Application
