Database Na Gaya Nung Nakaraan

Question 1

It is a collection of data stored in a format that can easily be accessed.

Answer 1

Database

Question 2

It is a collection of programs which enable its users to access database,
manipulate data, reporting and representation of data.

Answer 2

Database Management System (DBMS)

Question 3

It defines the logical design and
structure of a database and defines how data will be stored, accessed and updated in a database management system.

Answer 3

Database Model

Question 4

4 Database Models

Answer 4

• Hierarchical Model
• Network Model
• Entity-Relationship Model
• Relational Model

Question 5

The data is organized into tree-like structure.

Answer 5

Hierarchical Model

Question 6

An extension of the Hierarchical model. In this model data is organized more like a graph, and are allowed to have more than one parent node.

Answer 6

Network Model

Question 7

In this database model, relationships are created by dividing object of interest into entity and its characteristics into attributes.

Answer 7

Entity-Relationship Model

Question 8

In this model, data is organized in
two-dimensional tables and the relationship is maintained by storing a common field.

Answer 8

Relational Model

Question 9

It defines how the data is organized and how the relations among them are associated.

Answer 9

Database Schema

Question 10

It is a vertical entity in a table that
contains all information associated with a specific field in a table.

Answer 10

Column

Question 11

It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database.

Answer 11

DDL (DATA DEFINITION LANGUAGE)

Question 12

Creates a new table, a view of a table, or other object in the database.

Answer 12

Create

Question 13

Modifies an existing database object, such as a table.

Answer 13

Alter

Question 14

Deletes an entire table, a view of a table or other objects in the database.

Answer 14

Drop

Question 15

The SQL commands that deals with the manipulation of data present in the database.

Answer 15

DML (DATA MANIPULATION LANGUAGE)

Question 16

Retrieves certain records from one or more tables

Answer 16

Select

Question 17

Creates a records

Answer 17

Insert

Question 18

Modifies records

Answer 18

Update

Question 19

Delete record

Answer 19

Delete

Question 20

It mainly deals with the rights, permissions and other controls of the database system.

Answer 20

DCL (DATA CONTROL
LANGUAGE)

Question 21

Gives a privilege to user.

Answer 21

Grant

Question 22

Takes back privileges granted from user.

Answer 22

Revoke

Question 23

It deals with the transaction within the database.

Answer 23

TCL (TRANSACTION CONTROL LANGUAGE)

Question 24

Commit a transaction

Answer 24

Commit

Question 25

rollbacks a transaction in case of any error occurs.

Answer 25

Rollback

Question 26

Sets a savepoint within a transaction.

Answer 26

Savepoint

Question 27

It specify characteristics for the transaction.

Answer 27

Set Transaction

Question 28

It is an attribute that specifies the type of data of any object.

Answer 28

Data Type

Question 29

There are no duplicate rows in a table.

Answer 29

Entity Integrity

Question 30

Enforces valid entries for a given column by restricting the type, the format, or the range of values.

Answer 30

Domain Integrity

Question 31

Rows cannot be deleted, which are used by other records.

Answer 31

Referential Integrity

Question 32

Enforces some specific business rules that do not fall into entity, domain of referential integrity.

Answer 32

User-Defined Integrity

Question 33

What the purpose of the query is.

Answer 33

Action

Question 34

Which table or tables the action will be performed on.

Answer 34

Location

Question 35

What columns rows and data will be affected.

Answer 35

Where