暗記メーカー

暗記メーカー

​

ITEC48 (Garcia)

ITEC48 (Garcia)
33問 • 1年前
  • ユーザ名非公開
    • 通報

    問題一覧

  • 1

    is a collection of data stored in a format that can easily access

    Database

  • 2

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

    Database Management System (DBMS)

  • 3

    defines the logical design and structure of a database and defines how data will stored

    Database Model

  • 4

    This database model organizes data into a tree like structure

    Hierarchical Model

  • 5

    In this model data is organized more like a graph, and allowed to have more than one parent node

    Network Model

  • 6

    In this database model, relationships are created by dividing object of interest into entity

    Entity Relationship Model

  • 7

    In this model, data is organized in two dimentional tables and relationship is maintained by storing a common field

    Relational Model

  • 8

    is the skeleton structured that represents logical view of the entite database

    Database Schema

  • 9

    This Schema pertains to the actual storage of data wnd its form of storage like files, indices, etc

    Physical Database Schema

  • 10

    A logical data model establishes structure of data elements and the relationship among them

    Logical Database Schema

  • 11

    is a database management system that is based on the relational model as introduced by E.F Codd

    Relational Database Management System

  • 12

    is non relational database that scale out better than relational databases are designed with web applications

    NoSQL

  • 13

    a computer language for storing, manipulating and retrieving data

    SQL

  • 14

    is known as the Father of databases

    Dr. Edgar F “Tedd” Codd

  • 15

    Structured Query Language (SQL) Appeared

    1974

  • 16

    What year IBM worked to develop Codd ideas and released a product name System/R

    1978

  • 17

    What year IBM developed the first prototype of relational database and standardized by ANSI

    1986

  • 18

    Components of SQL Process

    1.Query Dispatcher 2.Optimization Engines 3.Classic Query Engine 4.SQL Query Engine

  • 19

    Consists of the SQL Commands that can be used to define the database Schema

    Data Definition Language (DDL)

  • 20

    SQL commands that deal with the manipulation of data present into database

    Data Manipulation Language (DML)

  • 21

    Includes Commands such as grant and revoke

    Data Control Language (DCL)

  • 22

    Data Definition Language Command

    1.Create 2.Alter 3.Drop

  • 23

    Data Manipulation Language (DML)

    1.Select 2.Insert 3.Update 4.Delete

  • 24

    Data Control Language Command (DCL)

    1.Grant 2.Revoke

  • 25

    Transaction Control Language (TCL) Commands

    1.Commit 2.Rollback 3.Savepoint 4.Set Transaction

  • 26

    an attribute that specifies the type of data of any object

    SQL Datatypes

  • 27

    are the rules enforced on data columns on a table. these are used to limit the type of data

    SQL Constraints

  • 28

    is a concept of a process that ensures the accuracy, completeness, consistency, and validity of an organization

    Data Integrity

  • 29

    SQL is followed by a unique set of rules and guidelines called?

    SQL Syntax

  • 30

    There are no duplicate rows in table

    Entity Integrity

  • 31

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

    Domain Integrity

  • 32

    Rows cannot be deleted, which are used by other records

    Referential Integrity

  • 33

    Enforces some specific business rules that do not fall into entity, domain or Referential Integrity

    User Defined Integrity

    • ITEC54 (Anonuevo)

    ITEC54 (Anonuevo)

    ユーザ名非公開 · 67問 · 1年前

    ITEC54 (Anonuevo)

    ITEC54 (Anonuevo)

    67問 • 1年前
    ユーザ名非公開

    ITEC81 (Bayot)

    ITEC81 (Bayot)

    ユーザ名非公開 · 53問 · 1年前

    ITEC81 (Bayot)

    ITEC81 (Bayot)

    53問 • 1年前
    ユーザ名非公開

    ITEC 51 (Anda)

    ITEC 51 (Anda)

    ユーザ名非公開 · 67問 · 1年前

    ITEC 51 (Anda)

    ITEC 51 (Anda)

    67問 • 1年前
    ユーザ名非公開

    ITEC91 (Ronquillo)

    ITEC91 (Ronquillo)

    ユーザ名非公開 · 7問 · 1年前

    ITEC91 (Ronquillo)

    ITEC91 (Ronquillo)

    7問 • 1年前
    ユーザ名非公開

    問題一覧

  • 1

    is a collection of data stored in a format that can easily access

    Database

  • 2

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

    Database Management System (DBMS)

  • 3

    defines the logical design and structure of a database and defines how data will stored

    Database Model

  • 4

    This database model organizes data into a tree like structure

    Hierarchical Model

  • 5

    In this model data is organized more like a graph, and allowed to have more than one parent node

    Network Model

  • 6

    In this database model, relationships are created by dividing object of interest into entity

    Entity Relationship Model

  • 7

    In this model, data is organized in two dimentional tables and relationship is maintained by storing a common field

    Relational Model

  • 8

    is the skeleton structured that represents logical view of the entite database

    Database Schema

  • 9

    This Schema pertains to the actual storage of data wnd its form of storage like files, indices, etc

    Physical Database Schema

  • 10

    A logical data model establishes structure of data elements and the relationship among them

    Logical Database Schema

  • 11

    is a database management system that is based on the relational model as introduced by E.F Codd

    Relational Database Management System

  • 12

    is non relational database that scale out better than relational databases are designed with web applications

    NoSQL

  • 13

    a computer language for storing, manipulating and retrieving data

    SQL

  • 14

    is known as the Father of databases

    Dr. Edgar F “Tedd” Codd

  • 15

    Structured Query Language (SQL) Appeared

    1974

  • 16

    What year IBM worked to develop Codd ideas and released a product name System/R

    1978

  • 17

    What year IBM developed the first prototype of relational database and standardized by ANSI

    1986

  • 18

    Components of SQL Process

    1.Query Dispatcher 2.Optimization Engines 3.Classic Query Engine 4.SQL Query Engine

  • 19

    Consists of the SQL Commands that can be used to define the database Schema

    Data Definition Language (DDL)

  • 20

    SQL commands that deal with the manipulation of data present into database

    Data Manipulation Language (DML)

  • 21

    Includes Commands such as grant and revoke

    Data Control Language (DCL)

  • 22

    Data Definition Language Command

    1.Create 2.Alter 3.Drop

  • 23

    Data Manipulation Language (DML)

    1.Select 2.Insert 3.Update 4.Delete

  • 24

    Data Control Language Command (DCL)

    1.Grant 2.Revoke

  • 25

    Transaction Control Language (TCL) Commands

    1.Commit 2.Rollback 3.Savepoint 4.Set Transaction

  • 26

    an attribute that specifies the type of data of any object

    SQL Datatypes

  • 27

    are the rules enforced on data columns on a table. these are used to limit the type of data

    SQL Constraints

  • 28

    is a concept of a process that ensures the accuracy, completeness, consistency, and validity of an organization

    Data Integrity

  • 29

    SQL is followed by a unique set of rules and guidelines called?

    SQL Syntax

  • 30

    There are no duplicate rows in table

    Entity Integrity

  • 31

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

    Domain Integrity

  • 32

    Rows cannot be deleted, which are used by other records

    Referential Integrity

  • 33

    Enforces some specific business rules that do not fall into entity, domain or Referential Integrity

    User Defined Integrity