Sir Oli Trial Exam Flashcards

1
Q

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

A

Relevant

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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.

A

Relevant

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Accurate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Flexible

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Reliability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Timely

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Completeness

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Simple

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

TRUE OR FALSE
Data is transformed into information only when it involves computations that can change the values of the data.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

TRUE OR FALSE
Checking if the entered data is valid or has a value is considered transforming data to information

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

TRUE OR FALSE
Manipulating data is about retrieving data from the database and displaying it in the application

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

TRUE OR FALSE
Data Management cannot be performed when the contents of the database is empty

A

False. You can still define tables, relationships, and rules that do not need pre-existing data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

TRUE OR FALSE
Data Management and Data Manipulation is the same

A

False. Data Manipulation is part of Data Management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

TRUE OR FALSE
In ANSI-SPARC, Views and Representations are the same

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

TRUE OR FALSE
In ANSI-SPARC, Views and Database Views are the same

A

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.

17
Q

TRUE OR FALSE
In ANSI-SPARC, Internal View is the same as Physical View

A

True

18
Q

TRUE OR FALSE
In ANSI-SPARC, the mapping of the conceptual view to the physical view is defined by the Database Designer

A

False. Physical view is the internal structure, and only the DBMS knows that and can map it.

19
Q

TRUE OR FALSE
In ANSI-SPARC, the conceptual to physical views are defined by the Database Administrator

A

False

20
Q

TRUE OR FALSE
In ANSI-SPARC, the external view is always in Conceptual Representation

A

True

21
Q

TRUE OR FALSE
In ANSI-SPARC, the conceptual view is always in Conceptual Representation

A

False

22
Q

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?

A

File-Based Application

23
Q

What component of the Database System is this activity being performed
The actual data is being updated and deleted.

A

Database Management System

24
Q

What component of the Database System is this activity being performed
Updates and Deletes on actual are permanently done

A

Database

25
Q

What component of the Database System is this activity being performed
Performs file operations as needed

A

Database Management System

26
Q

What component of the Database System is this activity being performed
Collects data from end-users

A

Database Application