DCIT 24 (1st Quiz)

Question 1

These are individual facts, statistics, or items of information, often numeric, that are collected through observation.

Answer 1

Data

Question 2

These are set of values of qualitative or quantitative variables about one or more persons or objects.

Answer 2

Data

Question 3

It is processed, organized and structured data.

Answer 3

Information

Question 4

It provides context for data and enables decision making.

Answer 4

Information

Question 5

It is an information that is set up for easy access, management and updating.

Answer 5

Database

Question 6

They typically store aggregations of data records or files that contain information, such as sales transactions, customer data, financials and product information.

Answer 6

Computer databases

Question 7

These are used for storing, maintaining and accessing any sort of data.

Answer 7

Databases

Question 8

They collect information on people, places or things.

Answer 8

Databases

Question 9

Databases can be thought of as an?

Answer 9

Organized collection of information

Question 10

It is a design of the database.

Answer 10

Database Schema

Question 11

It is a skeleton of the database that is used to represent the structure.

Answer 11

Database Schema

Question 12

In a database, sometimes we put some restrictions on the table that what type of data can be stored in one or more columns of the table, it can be done by using constraints.

Answer 12

Data Constraints

Question 13

It is known as the data about the data.

Answer 13

Metadata

Question 14

We can say that the database schema along with different types of constraints on the data is stored by DBMS in the dictionary is known as _____.

Answer 14

Metadata

Question 15

It is used to define the complete database environment and its components.

Answer 15

Database instance

Question 16

It is a set of memory structures and background processes that are used to access the database files.

Answer 16

Database instance

Question 17

It is used to access data from the database.

Answer 17

Query

Question 18

In a database, we can easily manipulate data using the three main operations.

Answer 18

Data Manipulation

Question 19

What are the three main operations?

Answer 19

Insertion
Deletion
Updation

Question 20

It is an underlying component that is used to create and manage various database queries.

Answer 20

Data Engine

Question 21

It is the process of collecting, sorting, organizing, maintaining and analyzing data.

Answer 21

Database Management

Question 22

It is software that permits the organization to centralize data, manage them efficiently, and provide access to the stored data by application programs.

Answer 22

Database Management System (DBMS)

Question 23

It is a general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing databases among various users and applications.

Answer 23

Database Management System (DBMS)

Question 24

The main purpose of this is to provide an interface that enables organizations to standardize data management consistently across teams and departments.

Answer 24

Database Management System (DBMS)

Question 25

It is aggregated, stored, and analyzed by the organization.

Answer 25

Data

Question 26

It enables organizations to access, store and modify data.

Answer 26

Database engines

Question 27

It determines the logical structure for each database.

Answer 27

Database Schema

Question 28

It is for a wide variety of tasks, including logging and auditing, or rollbacks and restarts.

Answer 28

Automation

Question 29

It unifies data processes into one visualized workflow, accessed via multiple devices and locations, and enable different users to display different views of one database schema.

Answer 29

Centralization

Question 30

It determines roles and privileges for each user, to ensure users gain limited access to corporate data and prevent abuse of privileges.

Answer 30

Access Controls

Question 31

DBMSs often provide an intuitive user experience, which enables users of different skills levels to access and leverage data.

Answer 31

User friendly

Question 32

A type of database that contains a single database located at one location in the network.

Answer 32

Centralized Database

Question 33

A type of database that contains two or more database files located at different locations in the network.

Answer 33

Distributed Database

Question 34

In this database, the data is organized in form of tables.

Answer 34

Relational Database

Question 35

In this database, the data is not organized in form of tables.

Answer 35

Non-relational Database

Question 36

It models information and data into a set of tables with rows and columns.

Answer 36

Relational Database Design (RDD)

Question 37

Each ____ of a relation/table represents a record.

Answer 37

Row

Question 38

Each ____ represents an attribute of data.

Answer 38

Column

Question 39

This is a way to visually represent the architecture, design, and implementation of complex software systems.

Answer 39

Unified Modeling Language (UML)

Question 40

It divides that software system into components and subcomponents.

Answer 40

UML Diagrams

Question 41

The various tables and attributes related to each table are identified.

Answer 41

Define relations/attributes

Question 42

The attribute or set of attributes that help in uniquely identifying a record is identified and assigned as the primary key.

Answer 42

Define primary keys

Question 43

The relationships between the various tables are established with the help of foreign keys.

Answer 43

Define relationships

Question 44

These are attributes occurring in a table that are primary keys of another table.

Answer 44

Foreign keys

Question 45

It is the process of optimizing the database structure.

Answer 45

Normalization

Question 46

It shows the relationships of entity sets stored in a database.

Answer 46

Entity Relationship Diagram (ERD)

Question 47

It is an object, a component of data.

Answer 47

Entity

Question 48

It is a collection of similar entities.

Answer 48

Entity set

Question 49

It illustrates the logical structure of databases.

Answer 49

ER Diagram

Question 50

It is used to sketch out the design of a database.

Answer 50

ER Diagram

Question 51

It is any object, person or activity which the data is recorded.

Answer 51

Entity

Question 52

It is a property of a given entity.

Answer 52

Attributes

Question 53

It is a type of association on entity types.

Answer 53

Relationship

Question 54

Entities are represented by _____

Answer 54

Rectangle

Question 55

It describes the property of an entity.

Answer 55

Attributes

Question 56

An attribute is represented as _____

Answer 56

Oval or ellipses

Question 57

These are further divided in a tree like structure.

Answer 57

Composite

Question 58

These are depicted by double ellipse.

Answer 58

Multivalued

Question 59

These are depicted by dashed ellipse.

Answer 59

Derived

Question 60

Relationship is represented by a ______

Answer 60

Diamond-shaped box

Question 61

It is when a single instance of an entity is associated with a single instance of another entity.

Answer 61

One-to-one relationship

Question 62

It is when a single instance on an entity is associated with more than one instances of another entity.

Answer 62

One-to-many relationship

Question 63

It is when more than one instances of an entity is associated with a single instance of another entity.

Answer 63

Many-to-one relationship

Question 64

It is when more than one instances of an entity is associated with more than one instances of another entity.

Answer 64

Many-to-many relationship

Question 65

It is designed to support to store and to maintain the personal information.

Answer 65

Personal Database

Question 66

It is designed to support to maintain database by a group of people.

Answer 66

Workgroup Database

Question 67

It is designed to support to maintain departmental wise activities in an organization.

Answer 67

Department Database

Question 68

It is designed to support to maintain organization database.

Answer 68

Enterprise Database

Question 69

It performs all the activities of an organization.

Answer 69

Enterprise Database

Question 70

He worked for International Business Machines

Answer 70

Edgar F. Codd

Question 71

He invented the relational model for database management, the theoretical basis for relational databased and relational management systems.

Answer 71

Edgar F. Codd

Question 72

He later won the prestigious Association of Computing Machinery Turing Award for his work.

Answer 72

Edgar F. Codd

Question 73

It is the first DBMS product based on the relational model.

Answer 73

DB2 from IBM

Question 74

It allows both relational and object views of data in the same database.

Answer 74

Object-relational database systems

Question 75

It was designed primarily for decision support applications, which are query-intensive, yet the mainstay of databases in the 1980s was transaction-processing applications, which are update-intensive.

Answer 75

Structured Query Language/Data System (SQL)

Question 76

It is the associated query language that emerges as a new database technology.

Answer 76

XQuery

Question 77

They have been built to handle the data management requirements of very large web sites such as Amazon, Facebook, Google, Microsoft and Yahoo!, and some of these are now offered as web services that can be used by application developers.

Answer 77

Data-storage systems

Question 78

What query language is associated in the first half of the 2000s?

Answer 78

XQuery

Question 79

2 open-source databases systems

Answer 79

PostgreSQL and MySQL

Question 80

What award did Edgar F. Codd received?

Answer 80

Association of Computing Machinery Turing Award

Question 81

Where did Edgar F. Codd worked?

Answer 81

International Business Machines