Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

2nd year, 1st Sem > DCIT 24 (1st Quiz) > Flashcards

DCIT 24 (1st Quiz) Flashcards

1
Q

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

A

Data

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

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

A

Data

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

It is processed, organized and structured data.

A

Information

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

It provides context for data and enables decision making.

A

Information

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

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

A

Database

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

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

A

Computer databases

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

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

A

Databases

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

They collect information on people, places or things.

A

Databases

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

Databases can be thought of as an?

A

Organized collection of information

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

It is a design of the database.

A

Database Schema

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

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

A

Database Schema

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

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.

A

Data Constraints

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

It is known as the data about the data.

A

Metadata

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

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 _____.

A

Metadata

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

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

A

Database instance

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

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

A

Database instance

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

It is used to access data from the database.

A

Query

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

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

A

Data Manipulation

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

What are the three main operations?

A

Insertion
Deletion
Updation

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

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

A

Data Engine

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

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

A

Database Management

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

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

A

Database Management System (DBMS)

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

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

A

Database Management System (DBMS)

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

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

A

Database Management System (DBMS)

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

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

A

Data

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

It enables organizations to access, store and modify data.

A

Database engines

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

It determines the logical structure for each database.

A

Database Schema

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

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

A

Automation

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

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.

A

Centralization

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

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

A

Access Controls

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

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

A

User friendly

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

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

A

Centralized Database

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

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

A

Distributed Database

34
Q

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

A

Relational Database

35
Q

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

A

Non-relational Database

36
Q

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

A

Relational Database Design (RDD)

37
Q

Each ____ of a relation/table represents a record.

A

Row

38
Q

Each ____ represents an attribute of data.

A

Column

39
Q

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

A

Unified Modeling Language (UML)

40
Q

It divides that software system into components and subcomponents.

A

UML Diagrams

41
Q

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

A

Define relations/attributes

42
Q

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

A

Define primary keys

43
Q

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

A

Define relationships

44
Q

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

A

Foreign keys

45
Q

It is the process of optimizing the database structure.

A

Normalization

46
Q

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

A

Entity Relationship Diagram (ERD)

47
Q

It is an object, a component of data.

A

Entity

48
Q

It is a collection of similar entities.

A

Entity set

49
Q

It illustrates the logical structure of databases.

A

ER Diagram

50
Q

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

A

ER Diagram

51
Q

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

A

Entity

52
Q

It is a property of a given entity.

A

Attributes

53
Q

It is a type of association on entity types.

A

Relationship

54
Q

Entities are represented by _____

A

Rectangle

55
Q

It describes the property of an entity.

A

Attributes

56
Q

An attribute is represented as _____

A

Oval or ellipses

57
Q

These are further divided in a tree like structure.

A

Composite

58
Q

These are depicted by double ellipse.

A

Multivalued

59
Q

These are depicted by dashed ellipse.

A

Derived

60
Q

Relationship is represented by a ______

A

Diamond-shaped box

61
Q

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

A

One-to-one relationship

62
Q

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

A

One-to-many relationship

63
Q

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

A

Many-to-one relationship

64
Q

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

A

Many-to-many relationship

65
Q

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

A

Personal Database

66
Q

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

A

Workgroup Database

67
Q

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

A

Department Database

68
Q

It is designed to support to maintain organization database.

A

Enterprise Database

69
Q

It performs all the activities of an organization.

A

Enterprise Database

70
Q

He worked for International Business Machines

A

Edgar F. Codd

71
Q

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

A

Edgar F. Codd

72
Q

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

A

Edgar F. Codd

73
Q

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

A

DB2 from IBM

74
Q

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

A

Object-relational database systems

75
Q

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.

A

Structured Query Language/Data System (SQL)

76
Q

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

A

XQuery

77
Q

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.

A

Data-storage systems

78
Q

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

A

XQuery

79
Q

2 open-source databases systems

A

PostgreSQL and MySQL

80
Q

What award did Edgar F. Codd received?

A

Association of Computing Machinery Turing Award

81
Q

Where did Edgar F. Codd worked?

A

International Business Machines

2nd year, 1st Sem (11 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions