TestMaker

TestMaker

​
Sign in

(Midterm) Advanced Database Systems Mocktest BSIT - 505

(Midterm) Advanced Database Systems Mocktest BSIT - 505
82 questions • 5 mo ago
  • Xai Alexandrei Delos Reyes
    • Report

    Question list

  • 1

    It is a collection of operations that form a single logical unit of work

    Transaction

  • 2

    is the equivalent of a single SQL statement in an application program or transaction.

    Database Request

  • 3

    satisfies the constraints specified in the schema.

    Database consistent state

  • 4

    A DBMS uses this to keep track of all the transactions that update the database.

    Transaction log

  • 5

    In Properties of transactions, which is described as it requires that all operations (SQL requests) of a transaction should be completed.

    Atomicity

  • 6

    In Properties of transactions, it ensures that only valid data following all rules and constraints will be written in the database. When a transaction results in invalid data, the database reverts to its previous state

    Consistency

  • 7

    In Properties of transactions, it is when the data used during the execution of a current transaction cannot be used by another transaction until the first one is completed.

    Isolation

  • 8

    In Properties of transactions, it ensures that once transaction changes are done and committed, they cannot be undone or lost.

    Durability

  • 9

    In SQL Transaction commands, This marks the beginning of transaction execution.

    BEGIN TRANSACTION

  • 10

    In SQL Transaction commands, this signals a successful end of the transaction so that any changes (updates) executed by the transaction can be safely committed to the database and will not be undone.

    COMMIT

  • 11

    In SQL Transaction commands, This signals that the transaction has ended unsuccessfully so that any changes or effects that the . transaction may have applied to the database must be undone.

    ROLLBACK TRANSACTION

  • 12

    In SQL Transaction commands, it is a point in a transaction when you can roll the transaction back to a certain point without rolling back the entire transaction.

    SAVE TRANSACTION

  • 13

    In SQL Transaction commands, it returns the number of BEGIN TRANSACTION statements that have occurred on the current connection.

    @@TRANCOUNT

  • 14

    in this state, a transaction stays in this state to perform READ and WRITE operations. Which Transaction Execution States is being described?

    Active state

  • 15

    where the final statement in queries has been executed Which Transaction Execution States is being described?

    Partially committed state

  • 16

    after all the operation has been completed Which Transaction Execution States is being described?

    Committed state

  • 17

    if one of the operations cannot be done or proceed Which Transaction Execution States is being described?

    Failed State

  • 18

    corresponds to the transaction leaving the system and if it is either committed or aborted Which Transaction Execution States is being described?

    Terminated

  • 19

    which best describes concurrency control?

    When several transactions execute simultaneously in the database, there will be a chance that the consistency and integrity of data may no longer be preserved.

  • 20

    occurs when two concurrent transactions, T1 and T2, are updating the same data element, and one of the updates is lost (overwritten by the other transaction). Which concurrency problem is being described?

    Lost Update

  • 21

    occurs when two transactions, T1 and T2, are executed concurrently, and the first transaction (T1) is rolled back after the second transaction (T2) has already accessed the uncommitted data. Which concurrency problem is being described?

    Uncommitted data

  • 22

    occur when a transaction accesses data before and after one or more other transactions finish working with the same data. Which concurrency problem is being described?

    Inconsistent retrievals

  • 23

    It guarantees exclusive use of data item to a current transaction.

    Lock

  • 24

    Which statement is NOT TRUE about Locks

    The entire table is locked.

  • 25

    Which statement is NOT TRUE about database-level lock

    The entire table is locked

  • 26

    Which statement is NOT TRUE about Table-Level Locks

    Locks the entire database

  • 27

    Which statement is NOT TRUE about Row-level locks?

    Locks the entire database

  • 28

    Which statement is NOT TRUE about Binary Lock?

    An exclusive lock exists when access is reserved specifically for the transaction that locked the object.

  • 29

    Which statement is NOT TRUE about shared/ exclusive locks

    Has only two states: locked (1) and unlocked (0)

  • 30

    It occurs when two (2) transactions wait indefinitely for each other to unlock data.

    Deadlock

  • 31

    A transaction requesting a new lock is aborted when there is the possibility that a deadlock can occur. If the transaction is aborted, all changes made by this transaction are rolled back, and all locks obtained by the transaction are released. Which technique of deadlock control is being described?

    Deadlock prevention

  • 32

    The DBMS periodically tests the database for deadlocks. If a deadlock is found, the “victim” transaction is aborted (rolled back and restarted), and another transaction continues. Which technique of deadlock control is being described?

    Deadlock detection

  • 33

    The transaction must obtain all the locks it needs before it can be executed. However, the serial lock assignment required in deadlock avoidance increases action response time. Which technique of deadlock control is being described?

    Deadlock avoidance

  • 34

    It is when a transaction can read data that is not committed yet.

    Dirty Read

  • 35

    a transaction reads a given row at time T1, and then it reads the same row at time T2, yielding different results. The original row may have been updated or deleted.

    Non-repeatable read

  • 36

    a transaction executes a query at time T1, and then it runs the same query at time T2, yielding additional rows that satisfy the query.

    Phantom Read

  • 37

    Which statement is NOT TRUE about READ UNCOMMITTED

    it is a default isolation level for SQL Server

  • 38

    Which statement is NOT TRUE about A READ COMMITTED

    Ensures that no other transactions can modify or delete data that has been read by the current transaction until the current transaction commits

  • 39

    Which statement is NOT TRUE about A REPEATABLE READ

    Most restrictive level and gives solution to the phantom read problem.

  • 40

    Which statement is NOT TRUE about A SERIALIZABLE isolation

    Is the least restrictive isolation level

  • 41

    It is a database designed to enable and support business intelligence (BI) activities, especially analytics.

    data warehouse

  • 42

    In Characteristics of Data Warehouses (DW), It is when the DW can analyze data about a particular subject or functional area.

    Subject-Oriented

  • 43

    In Characteristics of Data Warehouses (DW), It is when the DW creates consistency among different data types from different sources.

    Integrated

  • 44

    In Characteristics of Data Warehouses (DW), It is when the data in DW represents the flow of data through time. It can be organized weekly, monthly, or annually, etc.

    Time-variant

  • 45

    In Characteristics of Data Warehouses (DW), it is once data is in a data warehouse, it is stable and does not change.

    Non-volatile

  • 46

    In Components of Data Warehouse (DW), This is a databank that stocks all enterprise data and makes it manageable for reporting.

    Data Warehouse Database

  • 47

    In Components of Data Warehouse (DW), These tools are used for performing all the conversions, summarizations, and all the changes needed to transform data into a unified format in the data warehouse

    Extraction, Transformation, and Loading Tools (ETL)

  • 48

    In Components of Data Warehouse (DW), it is data about data that describes the data warehouse. It provides the source, transformation, integration, storage, usage, relationships, and history of each data element.

    Metadata

  • 49

    contains information about the warehouse, which is used by data warehouse designers and administrators. Which type of Metadata is this?

    Technical Metadata

  • 50

    It contains details that give end-users an easy way to understand the information stored in the data warehouse. Which type of Metadata is this?

    Business Metadata

  • 51

    In Components of Data Warehouse (DW), it corporate users generally cannot work with databases directly.

    Data Warehouse Access Tools

  • 52

    In Data Warehouse Access Tools, it help users produce corporate reports for analysis that can be in the form of spreadsheets, calculations, or interactive visuals.

    Query and reporting tool

  • 53

    In Data Warehouse Access Tools, In such cases, custom reports are developed using application development tools when built-in graphical and analytical tools do not satisfy the analytical needs of an organization.

    Application development tools

  • 54

    In Components of Data Warehouse (DW), a process of discovering meaningful new correlations, patterns, and trends by mining a large amount of data.

    Data mining

  • 55

    In Components of Data Warehouse (DW), it allow users to analyze the data using elaborate and complex multi-dimensional views.

    OLAP tools

  • 56

    In Components of Data Warehouse (DW), a small, single-subject data warehouse subset that provides decision support for the particular user group.

    Data Marts

  • 57

    It is a data-modeling technique used to map multi-dimensional decision support data into a relational database.

    star schema

  • 58

    In a star schema, these are data that will be included in reports and used as the basis of business decisions. It contains measurement or facts to the data and foreign key to dimension table.

    Facts table

  • 59

    In a star schema, these are attributes that qualify and provide more information about facts. It contains dimensions of a fact and they are joined to fact table via foreign key.

    Dimension table

  • 60

    It is a software tool that is used for data analysis and reporting purposes for business decisions

    Online Analytical Processing (OLAP)

  • 61

    an operational system that manages the day-to-day transactions of an organization

    Online Transaction Processing (OLTP)

  • 62

    Which Statement is NOT TRUE about OLAP

    Manages day to day operations

  • 63

    Which Statement is NOT TRUE about OLTP

    Provides historical data for reporting and planning

  • 64

    In Characteristics of OLAP, It is when Data is processed and viewed as part of a multi-dimensional structure.

    Multi-dimensional data analysis techniques

  • 65

    In Characteristics of OLAP, To deliver efficient decision support

    Advanced Database support

  • 66

    In Characteristics of OLAP, to permit the user to navigate the data in a way that simplifies and accelerates decision making or data analysis with easy-to-use graphical interfaces

    Easy-to-use end-user interfaces

  • 67

    In types of OLAP, extends OLAP functionality to multi-dimensional database management systems (MDBMS). It is best suited to manage, store, and analyze multi-dimensional data

    Multi-dimensional OLAP (MOLAP)

  • 68

    In types of OLAP, It works directly with relational databases. Fact and dimension tables are stored as relations.

    Relational OLAP (ROLAP)

  • 69

    Which Statement is NOT TRUE about ROLAP?

    Uses data cubes

  • 70

    Which Statement is NOT TRUE about MOLAP?

    Unlimited dimensions

  • 71

    In OLAP Operations, an extension of the GROUP BY clause that is used to create subtotals and grand totals for a set of columns

    ROLLUP operator

  • 72

    In OLAP Operations, Like ROLLUP, this generates subtotals for all the combinations of grouping column s specified in the GROUP BY clause.

    CUBE operator

  • 73

    In OLAP Operations, allows you to write a cross-tabulation, which means you can aggregate your results and rotate rows into columns

    PIVOT operator

  • 74

    It refers to analyzing massive amounts of data in a data warehouse or other sources to uncover hidden trends, patterns, and relationships. This explains the past and predicting the future for analysis

    Data mining

  • 75

    In data mining techniques, used to retrieve important and relevant information about data and metadata.

    Classification

  • 76

    In data mining techniques, used to identify data that are like each other. This process helps to understand the differences and similarities between the data.

    Clustering

  • 77

    In data mining techniques, used to identify and analyze the relationship between variables.

    Regression

  • 78

    In data mining techniques, used to help find the association between two or more Items. It discovers a hidden pattern in the data set.

    Association Rules

  • 79

    In data mining techniques, used to observe data items in the dataset that do not match an expected pattern or expected behavior.

    Outer detection Rules

  • 80

    In data mining techniques, used to discover or identify similar patterns or trends in transaction data for a certain period.

    Sequential Patterns

  • 81

    In data mining techniques, used to combine other data mining techniques like trends, sequential patterns, clustering, classification, etc. It analyzes past events or instances in the right sequence for predicting a future event.

    Prediction

  • 82

    Which statement is FALSE about data mining?

    used to identify and analyze the relationship between variables.

    • The Contemporary World Mock test (Prelims)

    The Contemporary World Mock test (Prelims)

    Xai Alexandrei Delos Reyes · 58 questions · 2 y ago

    The Contemporary World Mock test (Prelims)

    The Contemporary World Mock test (Prelims)

    58 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock test (Prelims)

    Computing Mock test (Prelims)

    Xai Alexandrei Delos Reyes · 67 questions · 2 y ago

    Computing Mock test (Prelims)

    Computing Mock test (Prelims)

    67 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Programming Mock Test (Prelims)

    Programming Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 64 questions · 2 y ago

    Programming Mock Test (Prelims)

    Programming Mock Test (Prelims)

    64 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Entrepreneurship Mock Test (Prelims)

    Entrepreneurship Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 23 questions · 2 y ago

    Entrepreneurship Mock Test (Prelims)

    Entrepreneurship Mock Test (Prelims)

    23 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock Test (Midterms) BSIT 107

    Computing Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 76 questions · 2 y ago

    Computing Mock Test (Midterms) BSIT 107

    Computing Mock Test (Midterms) BSIT 107

    76 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Math Mock Test (Prelims)

    Math Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 48 questions · 2 y ago

    Math Mock Test (Prelims)

    Math Mock Test (Prelims)

    48 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Programming Mock Test (Midterms) BSIT 107

    Programming Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 52 questions · 2 y ago

    Programming Mock Test (Midterms) BSIT 107

    Programming Mock Test (Midterms) BSIT 107

    52 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    UTS Mock Test (Midterms) BSIT107

    UTS Mock Test (Midterms) BSIT107

    Xai Alexandrei Delos Reyes · 40 questions · 2 y ago

    UTS Mock Test (Midterms) BSIT107

    UTS Mock Test (Midterms) BSIT107

    40 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 38 questions · 2 y ago

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Entrepreneurship Mock Test (Midterms) BSIT 107

    38 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Contemporary World Mock Test (Midterms) BSIT 107

    Contemporary World Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 28 questions · 2 y ago

    Contemporary World Mock Test (Midterms) BSIT 107

    Contemporary World Mock Test (Midterms) BSIT 107

    28 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Math Mocktest (Midterms) BSIT 107

    Math Mocktest (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 24 questions · 2 y ago

    Math Mocktest (Midterms) BSIT 107

    Math Mocktest (Midterms) BSIT 107

    24 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computer Programming Mocktest (Pre-finals)

    Computer Programming Mocktest (Pre-finals)

    Xai Alexandrei Delos Reyes · 26 questions · 2 y ago

    Computer Programming Mocktest (Pre-finals)

    Computer Programming Mocktest (Pre-finals)

    26 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Math Mocktest (Pre-Finals)

    Math Mocktest (Pre-Finals)

    Xai Alexandrei Delos Reyes · 19 questions · 2 y ago

    Math Mocktest (Pre-Finals)

    Math Mocktest (Pre-Finals)

    19 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock Test (Pre-finals)

    Computing Mock Test (Pre-finals)

    Xai Alexandrei Delos Reyes · 36 questions · 2 y ago

    Computing Mock Test (Pre-finals)

    Computing Mock Test (Pre-finals)

    36 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Computing Mock Test Finals

    Computing Mock Test Finals

    Xai Alexandrei Delos Reyes · 26 questions · 2 y ago

    Computing Mock Test Finals

    Computing Mock Test Finals

    26 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Comprog 2nd sem (prelims) BSIT 205

    Comprog 2nd sem (prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 63 questions · 2 y ago

    Comprog 2nd sem (prelims) BSIT 205

    Comprog 2nd sem (prelims) BSIT 205

    63 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Discrete Math 2nd sem (prelims) BSIT 205

    Discrete Math 2nd sem (prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 36 questions · 2 y ago

    Discrete Math 2nd sem (prelims) BSIT 205

    Discrete Math 2nd sem (prelims) BSIT 205

    36 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation (Prelim) BSIT 205

    Art Appreciation (Prelim) BSIT 205

    Xai Alexandrei Delos Reyes · 56 questions · 2 y ago

    Art Appreciation (Prelim) BSIT 205

    Art Appreciation (Prelim) BSIT 205

    56 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    Ethics 2nd sem (Prelims) BSIT 205

    Ethics 2nd sem (Prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 45 questions · 2 y ago

    Ethics 2nd sem (Prelims) BSIT 205

    Ethics 2nd sem (Prelims) BSIT 205

    45 questions • 2 y ago
    Xai Alexandrei Delos Reyes

    STS 2nd Sem (Prelim) BSIT 205

    STS 2nd Sem (Prelim) BSIT 205

    Xai Alexandrei Delos Reyes · 40 questions · 1 y ago

    STS 2nd Sem (Prelim) BSIT 205

    STS 2nd Sem (Prelim) BSIT 205

    40 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Systems Administration 2nd sem (Prelims) BSIT 205

    Systems Administration 2nd sem (Prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 72 questions · 1 y ago

    Systems Administration 2nd sem (Prelims) BSIT 205

    Systems Administration 2nd sem (Prelims) BSIT 205

    72 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Discrete Mathematics (Midterms) BSIT 205

    Discrete Mathematics (Midterms) BSIT 205

    Xai Alexandrei Delos Reyes · 52 questions · 1 y ago

    Discrete Mathematics (Midterms) BSIT 205

    Discrete Mathematics (Midterms) BSIT 205

    52 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation (Midterm) BSIT 205

    Art Appreciation (Midterm) BSIT 205

    Xai Alexandrei Delos Reyes · 56 questions · 1 y ago

    Art Appreciation (Midterm) BSIT 205

    Art Appreciation (Midterm) BSIT 205

    56 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Ethics Mocktest (Midterms) BSIT205

    Ethics Mocktest (Midterms) BSIT205

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    Ethics Mocktest (Midterms) BSIT205

    Ethics Mocktest (Midterms) BSIT205

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Comprog Mocktest (Midterm) BSIT 205

    Comprog Mocktest (Midterm) BSIT 205

    Xai Alexandrei Delos Reyes · 61 questions · 1 y ago

    Comprog Mocktest (Midterm) BSIT 205

    Comprog Mocktest (Midterm) BSIT 205

    61 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    System Administration Mocktest (Midterms) BSIT 205

    System Administration Mocktest (Midterms) BSIT 205

    Xai Alexandrei Delos Reyes · 65 questions · 1 y ago

    System Administration Mocktest (Midterms) BSIT 205

    System Administration Mocktest (Midterms) BSIT 205

    65 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Math Mocktest (Pre-finals) BSIT 205

    Math Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 49 questions · 1 y ago

    Math Mocktest (Pre-finals) BSIT 205

    Math Mocktest (Pre-finals) BSIT 205

    49 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 66 questions · 1 y ago

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    Art Appreciation Mocktest (Pre-finals) BSIT 205

    66 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Ethics Mocktest (Pre-finals) BSIT 205

    Ethics Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 50 questions · 1 y ago

    Ethics Mocktest (Pre-finals) BSIT 205

    Ethics Mocktest (Pre-finals) BSIT 205

    50 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Computer Programming Mocktest (Pre-finals) BSIT 205

    Computer Programming Mocktest (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 33 questions · 1 y ago

    Computer Programming Mocktest (Pre-finals) BSIT 205

    Computer Programming Mocktest (Pre-finals) BSIT 205

    33 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    System Administration (Pre-finals) BSIT 205

    System Administration (Pre-finals) BSIT 205

    Xai Alexandrei Delos Reyes · 52 questions · 1 y ago

    System Administration (Pre-finals) BSIT 205

    System Administration (Pre-finals) BSIT 205

    52 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Art Appreciation Finals BSIT 205

    Art Appreciation Finals BSIT 205

    Xai Alexandrei Delos Reyes · 35 questions · 1 y ago

    Art Appreciation Finals BSIT 205

    Art Appreciation Finals BSIT 205

    35 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Data Structures and Algorithms (Mocktest) BSIT 307

    Data Structures and Algorithms (Mocktest) BSIT 307

    Xai Alexandrei Delos Reyes · 52 questions · 1 y ago

    Data Structures and Algorithms (Mocktest) BSIT 307

    Data Structures and Algorithms (Mocktest) BSIT 307

    52 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    Xai Alexandrei Delos Reyes · 23 questions · 1 y ago

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    Object Oriented Programming Mock Test (Mocktest) BSIT 307

    23 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    Xai Alexandrei Delos Reyes · 58 questions · 1 y ago

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    Human Computer Interactions Mocktest (Prelims) BSIT 307

    58 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Principles of Communication Mocktest (Prelims) BSIT 307

    Principles of Communication Mocktest (Prelims) BSIT 307

    Xai Alexandrei Delos Reyes · 37 questions · 1 y ago

    Principles of Communication Mocktest (Prelims) BSIT 307

    Principles of Communication Mocktest (Prelims) BSIT 307

    37 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Principles of Communication Mocktest (Midterms) BSIT 307

    Principles of Communication Mocktest (Midterms) BSIT 307

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    Principles of Communication Mocktest (Midterms) BSIT 307

    Principles of Communication Mocktest (Midterms) BSIT 307

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    Xai Alexandrei Delos Reyes · 50 questions · 1 y ago

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    Data Structures and Algorithms Mocktest (Midterm) BSIT 307

    50 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    Xai Alexandrei Delos Reyes · 13 questions · 1 y ago

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    Object Oriented Programming Mock Test (Midterm) BSIT 307

    13 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    Xai Alexandrei Delos Reyes · 35 questions · 1 y ago

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    Human Computer Interactions Mocktest (Midterms) BSIT 307

    35 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Readings In Philippine History (Midterms) Mocktest

    Readings In Philippine History (Midterms) Mocktest

    Xai Alexandrei Delos Reyes · 16 questions · 1 y ago

    Readings In Philippine History (Midterms) Mocktest

    Readings In Philippine History (Midterms) Mocktest

    16 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Discrete Structures and Algorithms (Midterms) Mocktest

    Discrete Structures and Algorithms (Midterms) Mocktest

    Xai Alexandrei Delos Reyes · 10 questions · 1 y ago

    Discrete Structures and Algorithms (Midterms) Mocktest

    Discrete Structures and Algorithms (Midterms) Mocktest

    10 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    Principles of Communication (Midterm) Mocktest

    Principles of Communication (Midterm) Mocktest

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    Principles of Communication (Midterm) Mocktest

    Principles of Communication (Midterm) Mocktest

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    Xai Alexandrei Delos Reyes · 74 questions · 1 y ago

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    TECHNOPRENEURSHIP PRELIMS BSIT 402

    74 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) PH Popular Culture Mocktest BSIT 402

    (Prelim) PH Popular Culture Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 19 questions · 1 y ago

    (Prelim) PH Popular Culture Mocktest BSIT 402

    (Prelim) PH Popular Culture Mocktest BSIT 402

    19 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Integrative Programming BSIT 402

    (Prelim) Integrative Programming BSIT 402

    Xai Alexandrei Delos Reyes · 46 questions · 1 y ago

    (Prelim) Integrative Programming BSIT 402

    (Prelim) Integrative Programming BSIT 402

    46 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Quantitive Methods Mocktest BSIT 402

    (Prelim) Quantitive Methods Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 39 questions · 1 y ago

    (Prelim) Quantitive Methods Mocktest BSIT 402

    (Prelim) Quantitive Methods Mocktest BSIT 402

    39 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) System Integration and Architecture BSIT 402

    (Prelim) System Integration and Architecture BSIT 402

    Xai Alexandrei Delos Reyes · 29 questions · 1 y ago

    (Prelim) System Integration and Architecture BSIT 402

    (Prelim) System Integration and Architecture BSIT 402

    29 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Network Technology Mocktest BSIT 402

    (Prelim) Network Technology Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 68 questions · 1 y ago

    (Prelim) Network Technology Mocktest BSIT 402

    (Prelim) Network Technology Mocktest BSIT 402

    68 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Prelim) Information Management Mocktest BSIT 402

    (Prelim) Information Management Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 45 questions · 1 y ago

    (Prelim) Information Management Mocktest BSIT 402

    (Prelim) Information Management Mocktest BSIT 402

    45 questions • 1 y ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 28 questions · 10 mo ago

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    (Pre-Finals) Quantitative Research Mocktest BSIT 402

    28 questions • 10 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Information Management Mocktest

    (Finals) Information Management Mocktest

    Xai Alexandrei Delos Reyes · 64 questions · 9 mo ago

    (Finals) Information Management Mocktest

    (Finals) Information Management Mocktest

    64 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Philippine Popular Culture Mocktest

    (Finals) Philippine Popular Culture Mocktest

    Xai Alexandrei Delos Reyes · 46 questions · 9 mo ago

    (Finals) Philippine Popular Culture Mocktest

    (Finals) Philippine Popular Culture Mocktest

    46 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Integrative Programming Mocktest BSIT 402

    (Finals) Integrative Programming Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 24 questions · 9 mo ago

    (Finals) Integrative Programming Mocktest BSIT 402

    (Finals) Integrative Programming Mocktest BSIT 402

    24 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Network Technology Mocktest BSIT 402

    (Finals) Network Technology Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 37 questions · 9 mo ago

    (Finals) Network Technology Mocktest BSIT 402

    (Finals) Network Technology Mocktest BSIT 402

    37 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Quantitative Methods Mocktest BSIT 402

    (Finals) Quantitative Methods Mocktest BSIT 402

    Xai Alexandrei Delos Reyes · 18 questions · 9 mo ago

    (Finals) Quantitative Methods Mocktest BSIT 402

    (Finals) Quantitative Methods Mocktest BSIT 402

    18 questions • 9 mo ago
    Xai Alexandrei Delos Reyes

    Application Development Mocktest (Prelim) BSIT 505

    Application Development Mocktest (Prelim) BSIT 505

    Xai Alexandrei Delos Reyes · 72 questions · 6 mo ago

    Application Development Mocktest (Prelim) BSIT 505

    Application Development Mocktest (Prelim) BSIT 505

    72 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    Xai Alexandrei Delos Reyes · 60 questions · 6 mo ago

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    Data and Digital Communication Mocktest (Prelim) BSIT 505

    60 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    (Handout 1 Only!) Advanced Systems Integration and Architecture Mocktest (Prelim) BSIT 505

    (Handout 1 Only!) Advanced Systems Integration and Architecture Mocktest (Prelim) BSIT 505

    Xai Alexandrei Delos Reyes · 38 questions · 6 mo ago

    (Handout 1 Only!) Advanced Systems Integration and Architecture Mocktest (Prelim) BSIT 505

    (Handout 1 Only!) Advanced Systems Integration and Architecture Mocktest (Prelim) BSIT 505

    38 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    Xai Alexandrei Delos Reyes · 42 questions · 6 mo ago

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    Enterprise Architecture Mocktest (Prelims) BSIT 505

    42 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    Xai Alexandrei Delos Reyes · 44 questions · 6 mo ago

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    Professional Issues in Information Technology Mocktest (Prelims) BSIT 505

    44 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Application Development Mocktest (Midterm) BSIT 505

    Application Development Mocktest (Midterm) BSIT 505

    Xai Alexandrei Delos Reyes · 42 questions · 6 mo ago

    Application Development Mocktest (Midterm) BSIT 505

    Application Development Mocktest (Midterm) BSIT 505

    42 questions • 6 mo ago
    Xai Alexandrei Delos Reyes

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    Xai Alexandrei Delos Reyes · 61 questions · 5 mo ago

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    Event-Driven Programming Mocktest (Midterm) BSIT - 505

    61 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    Xai Alexandrei Delos Reyes · 80 questions · 5 mo ago

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    Data and Digital Communication Mocktest (Midterm) BSIT - 505

    80 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    Xai Alexandrei Delos Reyes · 68 questions · 5 mo ago

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    (Midterm) Advanced Systems and Integration Architecture BSIT - 505

    68 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 69 questions · 5 mo ago

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    (Midterms) Enterprise Architecture Mocktest BSIT 505

    69 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    (Midterm) Professional Issues in Information Technology BSIT 505

    (Midterm) Professional Issues in Information Technology BSIT 505

    Xai Alexandrei Delos Reyes · 38 questions · 5 mo ago

    (Midterm) Professional Issues in Information Technology BSIT 505

    (Midterm) Professional Issues in Information Technology BSIT 505

    38 questions • 5 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals)Event-Driven Programming Mocktest BSIT 505

    (Pre-Finals)Event-Driven Programming Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 59 questions · 4 mo ago

    (Pre-Finals)Event-Driven Programming Mocktest BSIT 505

    (Pre-Finals)Event-Driven Programming Mocktest BSIT 505

    59 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-finals) Application Development Mocktest BSIT 505

    (Pre-finals) Application Development Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 41 questions · 4 mo ago

    (Pre-finals) Application Development Mocktest BSIT 505

    (Pre-finals) Application Development Mocktest BSIT 505

    41 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Data and Digital Communication Mocktest BSIT 505

    (Pre-Finals) Data and Digital Communication Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 57 questions · 4 mo ago

    (Pre-Finals) Data and Digital Communication Mocktest BSIT 505

    (Pre-Finals) Data and Digital Communication Mocktest BSIT 505

    57 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) ASIA Mocktest BSIT 505

    (Pre-Finals) ASIA Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 44 questions · 4 mo ago

    (Pre-Finals) ASIA Mocktest BSIT 505

    (Pre-Finals) ASIA Mocktest BSIT 505

    44 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 72 questions · 4 mo ago

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    (Pre-Finals) Advanced Database Systems Mocktest BSIT 505

    72 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 42 questions · 4 mo ago

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    (Pre-Finals) Enterprise Architecture Mocktest BSIT 505

    42 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505

    (Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 62 questions · 4 mo ago

    (Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505

    (Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505

    62 questions • 4 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Application Development Mocktest BSIT 505

    (Finals) Application Development Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 62 questions · 3 mo ago

    (Finals) Application Development Mocktest BSIT 505

    (Finals) Application Development Mocktest BSIT 505

    62 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    Xai Alexandrei Delos Reyes · 61 questions · 3 mo ago

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    (Finals) Data and Digital Communication Mocktest BSIT - 505

    61 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Advanced Database Systems Mocktest BSIT 505

    (Finals) Advanced Database Systems Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 62 questions · 3 mo ago

    (Finals) Advanced Database Systems Mocktest BSIT 505

    (Finals) Advanced Database Systems Mocktest BSIT 505

    62 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Enterprise Architecture Mocktest BSIT 505

    (Finals) Enterprise Architecture Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 60 questions · 3 mo ago

    (Finals) Enterprise Architecture Mocktest BSIT 505

    (Finals) Enterprise Architecture Mocktest BSIT 505

    60 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 27 questions · 3 mo ago

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    (Finals) Professional issues in Information Technology Mocktest BSIT 505

    27 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Finals) Event-Driven Programming Mocktest BSIT 505

    (Finals) Event-Driven Programming Mocktest BSIT 505

    Xai Alexandrei Delos Reyes · 65 questions · 3 mo ago

    (Finals) Event-Driven Programming Mocktest BSIT 505

    (Finals) Event-Driven Programming Mocktest BSIT 505

    65 questions • 3 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 41 views · 42 questions · 1 mo ago

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    (Prelims) Mobile Systems and Technologies Mocktest BSIT 604

    41 views • 42 questions • 1 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Great Books Mocktest BSIT 604

    (Prelims) Great Books Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 46 views · 75 questions · 1 mo ago

    (Prelims) Great Books Mocktest BSIT 604

    (Prelims) Great Books Mocktest BSIT 604

    46 views • 75 questions • 1 mo ago
    Xai Alexandrei Delos Reyes

    (Prelims) Management Information Systems Mocktest BSIT - 604

    (Prelims) Management Information Systems Mocktest BSIT - 604

    Xai Alexandrei Delos Reyes · 70 views · 94 questions · 25 d ago

    (Prelims) Management Information Systems Mocktest BSIT - 604

    (Prelims) Management Information Systems Mocktest BSIT - 604

    70 views • 94 questions • 25 d ago
    Xai Alexandrei Delos Reyes

    (Prelims) Programming Languages Mocktest BSIT 604

    (Prelims) Programming Languages Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 26 views · 79 questions · 25 d ago

    (Prelims) Programming Languages Mocktest BSIT 604

    (Prelims) Programming Languages Mocktest BSIT 604

    26 views • 79 questions • 25 d ago
    Xai Alexandrei Delos Reyes

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 33 views · 99 questions · 22 d ago

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    (Prelims) Web Systems and Technologies Mocktest BSIT 604

    33 views • 99 questions • 22 d ago
    Xai Alexandrei Delos Reyes

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 33 views · 92 questions · 20 d ago

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    (Prelims) Information Assurance and Security Mocktest BSIT 604

    33 views • 92 questions • 20 d ago
    Xai Alexandrei Delos Reyes

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 16 questions · 9 d ago

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    (Midterms) Mobile Systems and Technologies Mocktest BSIT 604

    16 questions • 9 d ago
    Xai Alexandrei Delos Reyes

    (Midterm) Great Books Mocktest BSIT 604

    (Midterm) Great Books Mocktest BSIT 604

    Xai Alexandrei Delos Reyes · 74 questions · 3 d ago

    (Midterm) Great Books Mocktest BSIT 604

    (Midterm) Great Books Mocktest BSIT 604

    74 questions • 3 d ago
    Xai Alexandrei Delos Reyes

    Question list

  • 1

    It is a collection of operations that form a single logical unit of work

    Transaction

  • 2

    is the equivalent of a single SQL statement in an application program or transaction.

    Database Request

  • 3

    satisfies the constraints specified in the schema.

    Database consistent state

  • 4

    A DBMS uses this to keep track of all the transactions that update the database.

    Transaction log

  • 5

    In Properties of transactions, which is described as it requires that all operations (SQL requests) of a transaction should be completed.

    Atomicity

  • 6

    In Properties of transactions, it ensures that only valid data following all rules and constraints will be written in the database. When a transaction results in invalid data, the database reverts to its previous state

    Consistency

  • 7

    In Properties of transactions, it is when the data used during the execution of a current transaction cannot be used by another transaction until the first one is completed.

    Isolation

  • 8

    In Properties of transactions, it ensures that once transaction changes are done and committed, they cannot be undone or lost.

    Durability

  • 9

    In SQL Transaction commands, This marks the beginning of transaction execution.

    BEGIN TRANSACTION

  • 10

    In SQL Transaction commands, this signals a successful end of the transaction so that any changes (updates) executed by the transaction can be safely committed to the database and will not be undone.

    COMMIT

  • 11

    In SQL Transaction commands, This signals that the transaction has ended unsuccessfully so that any changes or effects that the . transaction may have applied to the database must be undone.

    ROLLBACK TRANSACTION

  • 12

    In SQL Transaction commands, it is a point in a transaction when you can roll the transaction back to a certain point without rolling back the entire transaction.

    SAVE TRANSACTION

  • 13

    In SQL Transaction commands, it returns the number of BEGIN TRANSACTION statements that have occurred on the current connection.

    @@TRANCOUNT

  • 14

    in this state, a transaction stays in this state to perform READ and WRITE operations. Which Transaction Execution States is being described?

    Active state

  • 15

    where the final statement in queries has been executed Which Transaction Execution States is being described?

    Partially committed state

  • 16

    after all the operation has been completed Which Transaction Execution States is being described?

    Committed state

  • 17

    if one of the operations cannot be done or proceed Which Transaction Execution States is being described?

    Failed State

  • 18

    corresponds to the transaction leaving the system and if it is either committed or aborted Which Transaction Execution States is being described?

    Terminated

  • 19

    which best describes concurrency control?

    When several transactions execute simultaneously in the database, there will be a chance that the consistency and integrity of data may no longer be preserved.

  • 20

    occurs when two concurrent transactions, T1 and T2, are updating the same data element, and one of the updates is lost (overwritten by the other transaction). Which concurrency problem is being described?

    Lost Update

  • 21

    occurs when two transactions, T1 and T2, are executed concurrently, and the first transaction (T1) is rolled back after the second transaction (T2) has already accessed the uncommitted data. Which concurrency problem is being described?

    Uncommitted data

  • 22

    occur when a transaction accesses data before and after one or more other transactions finish working with the same data. Which concurrency problem is being described?

    Inconsistent retrievals

  • 23

    It guarantees exclusive use of data item to a current transaction.

    Lock

  • 24

    Which statement is NOT TRUE about Locks

    The entire table is locked.

  • 25

    Which statement is NOT TRUE about database-level lock

    The entire table is locked

  • 26

    Which statement is NOT TRUE about Table-Level Locks

    Locks the entire database

  • 27

    Which statement is NOT TRUE about Row-level locks?

    Locks the entire database

  • 28

    Which statement is NOT TRUE about Binary Lock?

    An exclusive lock exists when access is reserved specifically for the transaction that locked the object.

  • 29

    Which statement is NOT TRUE about shared/ exclusive locks

    Has only two states: locked (1) and unlocked (0)

  • 30

    It occurs when two (2) transactions wait indefinitely for each other to unlock data.

    Deadlock

  • 31

    A transaction requesting a new lock is aborted when there is the possibility that a deadlock can occur. If the transaction is aborted, all changes made by this transaction are rolled back, and all locks obtained by the transaction are released. Which technique of deadlock control is being described?

    Deadlock prevention

  • 32

    The DBMS periodically tests the database for deadlocks. If a deadlock is found, the “victim” transaction is aborted (rolled back and restarted), and another transaction continues. Which technique of deadlock control is being described?

    Deadlock detection

  • 33

    The transaction must obtain all the locks it needs before it can be executed. However, the serial lock assignment required in deadlock avoidance increases action response time. Which technique of deadlock control is being described?

    Deadlock avoidance

  • 34

    It is when a transaction can read data that is not committed yet.

    Dirty Read

  • 35

    a transaction reads a given row at time T1, and then it reads the same row at time T2, yielding different results. The original row may have been updated or deleted.

    Non-repeatable read

  • 36

    a transaction executes a query at time T1, and then it runs the same query at time T2, yielding additional rows that satisfy the query.

    Phantom Read

  • 37

    Which statement is NOT TRUE about READ UNCOMMITTED

    it is a default isolation level for SQL Server

  • 38

    Which statement is NOT TRUE about A READ COMMITTED

    Ensures that no other transactions can modify or delete data that has been read by the current transaction until the current transaction commits

  • 39

    Which statement is NOT TRUE about A REPEATABLE READ

    Most restrictive level and gives solution to the phantom read problem.

  • 40

    Which statement is NOT TRUE about A SERIALIZABLE isolation

    Is the least restrictive isolation level

  • 41

    It is a database designed to enable and support business intelligence (BI) activities, especially analytics.

    data warehouse

  • 42

    In Characteristics of Data Warehouses (DW), It is when the DW can analyze data about a particular subject or functional area.

    Subject-Oriented

  • 43

    In Characteristics of Data Warehouses (DW), It is when the DW creates consistency among different data types from different sources.

    Integrated

  • 44

    In Characteristics of Data Warehouses (DW), It is when the data in DW represents the flow of data through time. It can be organized weekly, monthly, or annually, etc.

    Time-variant

  • 45

    In Characteristics of Data Warehouses (DW), it is once data is in a data warehouse, it is stable and does not change.

    Non-volatile

  • 46

    In Components of Data Warehouse (DW), This is a databank that stocks all enterprise data and makes it manageable for reporting.

    Data Warehouse Database

  • 47

    In Components of Data Warehouse (DW), These tools are used for performing all the conversions, summarizations, and all the changes needed to transform data into a unified format in the data warehouse

    Extraction, Transformation, and Loading Tools (ETL)

  • 48

    In Components of Data Warehouse (DW), it is data about data that describes the data warehouse. It provides the source, transformation, integration, storage, usage, relationships, and history of each data element.

    Metadata

  • 49

    contains information about the warehouse, which is used by data warehouse designers and administrators. Which type of Metadata is this?

    Technical Metadata

  • 50

    It contains details that give end-users an easy way to understand the information stored in the data warehouse. Which type of Metadata is this?

    Business Metadata

  • 51

    In Components of Data Warehouse (DW), it corporate users generally cannot work with databases directly.

    Data Warehouse Access Tools

  • 52

    In Data Warehouse Access Tools, it help users produce corporate reports for analysis that can be in the form of spreadsheets, calculations, or interactive visuals.

    Query and reporting tool

  • 53

    In Data Warehouse Access Tools, In such cases, custom reports are developed using application development tools when built-in graphical and analytical tools do not satisfy the analytical needs of an organization.

    Application development tools

  • 54

    In Components of Data Warehouse (DW), a process of discovering meaningful new correlations, patterns, and trends by mining a large amount of data.

    Data mining

  • 55

    In Components of Data Warehouse (DW), it allow users to analyze the data using elaborate and complex multi-dimensional views.

    OLAP tools

  • 56

    In Components of Data Warehouse (DW), a small, single-subject data warehouse subset that provides decision support for the particular user group.

    Data Marts

  • 57

    It is a data-modeling technique used to map multi-dimensional decision support data into a relational database.

    star schema

  • 58

    In a star schema, these are data that will be included in reports and used as the basis of business decisions. It contains measurement or facts to the data and foreign key to dimension table.

    Facts table

  • 59

    In a star schema, these are attributes that qualify and provide more information about facts. It contains dimensions of a fact and they are joined to fact table via foreign key.

    Dimension table

  • 60

    It is a software tool that is used for data analysis and reporting purposes for business decisions

    Online Analytical Processing (OLAP)

  • 61

    an operational system that manages the day-to-day transactions of an organization

    Online Transaction Processing (OLTP)

  • 62

    Which Statement is NOT TRUE about OLAP

    Manages day to day operations

  • 63

    Which Statement is NOT TRUE about OLTP

    Provides historical data for reporting and planning

  • 64

    In Characteristics of OLAP, It is when Data is processed and viewed as part of a multi-dimensional structure.

    Multi-dimensional data analysis techniques

  • 65

    In Characteristics of OLAP, To deliver efficient decision support

    Advanced Database support

  • 66

    In Characteristics of OLAP, to permit the user to navigate the data in a way that simplifies and accelerates decision making or data analysis with easy-to-use graphical interfaces

    Easy-to-use end-user interfaces

  • 67

    In types of OLAP, extends OLAP functionality to multi-dimensional database management systems (MDBMS). It is best suited to manage, store, and analyze multi-dimensional data

    Multi-dimensional OLAP (MOLAP)

  • 68

    In types of OLAP, It works directly with relational databases. Fact and dimension tables are stored as relations.

    Relational OLAP (ROLAP)

  • 69

    Which Statement is NOT TRUE about ROLAP?

    Uses data cubes

  • 70

    Which Statement is NOT TRUE about MOLAP?

    Unlimited dimensions

  • 71

    In OLAP Operations, an extension of the GROUP BY clause that is used to create subtotals and grand totals for a set of columns

    ROLLUP operator

  • 72

    In OLAP Operations, Like ROLLUP, this generates subtotals for all the combinations of grouping column s specified in the GROUP BY clause.

    CUBE operator

  • 73

    In OLAP Operations, allows you to write a cross-tabulation, which means you can aggregate your results and rotate rows into columns

    PIVOT operator

  • 74

    It refers to analyzing massive amounts of data in a data warehouse or other sources to uncover hidden trends, patterns, and relationships. This explains the past and predicting the future for analysis

    Data mining

  • 75

    In data mining techniques, used to retrieve important and relevant information about data and metadata.

    Classification

  • 76

    In data mining techniques, used to identify data that are like each other. This process helps to understand the differences and similarities between the data.

    Clustering

  • 77

    In data mining techniques, used to identify and analyze the relationship between variables.

    Regression

  • 78

    In data mining techniques, used to help find the association between two or more Items. It discovers a hidden pattern in the data set.

    Association Rules

  • 79

    In data mining techniques, used to observe data items in the dataset that do not match an expected pattern or expected behavior.

    Outer detection Rules

  • 80

    In data mining techniques, used to discover or identify similar patterns or trends in transaction data for a certain period.

    Sequential Patterns

  • 81

    In data mining techniques, used to combine other data mining techniques like trends, sequential patterns, clustering, classification, etc. It analyzes past events or instances in the right sequence for predicting a future event.

    Prediction

  • 82

    Which statement is FALSE about data mining?

    used to identify and analyze the relationship between variables.