(Midterm) Advanced Database Systems Mocktest BSIT - 505
問題一覧
1
Transaction
2
Database Request
3
Database consistent state
4
Transaction log
5
Atomicity
6
Consistency
7
Isolation
8
Durability
9
BEGIN TRANSACTION
10
COMMIT
11
ROLLBACK TRANSACTION
12
SAVE TRANSACTION
13
@@TRANCOUNT
14
Active state
15
Partially committed state
16
Committed state
17
Failed State
18
Terminated
19
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
Lost Update
21
Uncommitted data
22
Inconsistent retrievals
23
Lock
24
The entire table is locked.
25
The entire table is locked
26
Locks the entire database
27
Locks the entire database
28
An exclusive lock exists when access is reserved specifically for the transaction that locked the object.
29
Has only two states: locked (1) and unlocked (0)
30
Deadlock
31
Deadlock prevention
32
Deadlock detection
33
Deadlock avoidance
34
Dirty Read
35
Non-repeatable read
36
Phantom Read
37
it is a default isolation level for SQL Server
38
Ensures that no other transactions can modify or delete data that has been read by the current transaction until the current transaction commits
39
Most restrictive level and gives solution to the phantom read problem.
40
Is the least restrictive isolation level
41
data warehouse
42
Subject-Oriented
43
Integrated
44
Time-variant
45
Non-volatile
46
Data Warehouse Database
47
Extraction, Transformation, and Loading Tools (ETL)
48
Metadata
49
Technical Metadata
50
Business Metadata
51
Data Warehouse Access Tools
52
Query and reporting tool
53
Application development tools
54
Data mining
55
OLAP tools
56
Data Marts
57
star schema
58
Facts table
59
Dimension table
60
Online Analytical Processing (OLAP)
61
Online Transaction Processing (OLTP)
62
Manages day to day operations
63
Provides historical data for reporting and planning
64
Multi-dimensional data analysis techniques
65
Advanced Database support
66
Easy-to-use end-user interfaces
67
Multi-dimensional OLAP (MOLAP)
68
Relational OLAP (ROLAP)
69
Uses data cubes
70
Unlimited dimensions
71
ROLLUP operator
72
CUBE operator
73
PIVOT operator
74
Data mining
75
Classification
76
Clustering
77
Regression
78
Association Rules
79
Outer detection Rules
80
Sequential Patterns
81
Prediction
82
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問 · 2年前The Contemporary World Mock test (Prelims)
The Contemporary World Mock test (Prelims)
58問 • 2年前Computing Mock test (Prelims)
Computing Mock test (Prelims)
Xai Alexandrei Delos Reyes · 67問 · 2年前Computing Mock test (Prelims)
Computing Mock test (Prelims)
67問 • 2年前Programming Mock Test (Prelims)
Programming Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 64問 · 2年前Programming Mock Test (Prelims)
Programming Mock Test (Prelims)
64問 • 2年前Entrepreneurship Mock Test (Prelims)
Entrepreneurship Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 23問 · 2年前Entrepreneurship Mock Test (Prelims)
Entrepreneurship Mock Test (Prelims)
23問 • 2年前Computing Mock Test (Midterms) BSIT 107
Computing Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 76問 · 2年前Computing Mock Test (Midterms) BSIT 107
Computing Mock Test (Midterms) BSIT 107
76問 • 2年前Math Mock Test (Prelims)
Math Mock Test (Prelims)
Xai Alexandrei Delos Reyes · 48問 · 2年前Math Mock Test (Prelims)
Math Mock Test (Prelims)
48問 • 2年前Programming Mock Test (Midterms) BSIT 107
Programming Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 52問 · 2年前Programming Mock Test (Midterms) BSIT 107
Programming Mock Test (Midterms) BSIT 107
52問 • 2年前UTS Mock Test (Midterms) BSIT107
UTS Mock Test (Midterms) BSIT107
Xai Alexandrei Delos Reyes · 40問 · 2年前UTS Mock Test (Midterms) BSIT107
UTS Mock Test (Midterms) BSIT107
40問 • 2年前Entrepreneurship Mock Test (Midterms) BSIT 107
Entrepreneurship Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 38問 · 2年前Entrepreneurship Mock Test (Midterms) BSIT 107
Entrepreneurship Mock Test (Midterms) BSIT 107
38問 • 2年前Contemporary World Mock Test (Midterms) BSIT 107
Contemporary World Mock Test (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 28問 · 2年前Contemporary World Mock Test (Midterms) BSIT 107
Contemporary World Mock Test (Midterms) BSIT 107
28問 • 2年前Math Mocktest (Midterms) BSIT 107
Math Mocktest (Midterms) BSIT 107
Xai Alexandrei Delos Reyes · 24問 · 2年前Math Mocktest (Midterms) BSIT 107
Math Mocktest (Midterms) BSIT 107
24問 • 2年前Computer Programming Mocktest (Pre-finals)
Computer Programming Mocktest (Pre-finals)
Xai Alexandrei Delos Reyes · 26問 · 2年前Computer Programming Mocktest (Pre-finals)
Computer Programming Mocktest (Pre-finals)
26問 • 2年前Math Mocktest (Pre-Finals)
Math Mocktest (Pre-Finals)
Xai Alexandrei Delos Reyes · 19問 · 2年前Math Mocktest (Pre-Finals)
Math Mocktest (Pre-Finals)
19問 • 2年前Computing Mock Test (Pre-finals)
Computing Mock Test (Pre-finals)
Xai Alexandrei Delos Reyes · 36問 · 2年前Computing Mock Test (Pre-finals)
Computing Mock Test (Pre-finals)
36問 • 2年前Computing Mock Test Finals
Computing Mock Test Finals
Xai Alexandrei Delos Reyes · 26問 · 2年前Computing Mock Test Finals
Computing Mock Test Finals
26問 • 2年前Comprog 2nd sem (prelims) BSIT 205
Comprog 2nd sem (prelims) BSIT 205
Xai Alexandrei Delos Reyes · 63問 · 2年前Comprog 2nd sem (prelims) BSIT 205
Comprog 2nd sem (prelims) BSIT 205
63問 • 2年前Discrete Math 2nd sem (prelims) BSIT 205
Discrete Math 2nd sem (prelims) BSIT 205
Xai Alexandrei Delos Reyes · 36問 · 2年前Discrete Math 2nd sem (prelims) BSIT 205
Discrete Math 2nd sem (prelims) BSIT 205
36問 • 2年前Art Appreciation (Prelim) BSIT 205
Art Appreciation (Prelim) BSIT 205
Xai Alexandrei Delos Reyes · 56問 · 2年前Art Appreciation (Prelim) BSIT 205
Art Appreciation (Prelim) BSIT 205
56問 • 2年前Ethics 2nd sem (Prelims) BSIT 205
Ethics 2nd sem (Prelims) BSIT 205
Xai Alexandrei Delos Reyes · 45問 · 2年前Ethics 2nd sem (Prelims) BSIT 205
Ethics 2nd sem (Prelims) BSIT 205
45問 • 2年前STS 2nd Sem (Prelim) BSIT 205
STS 2nd Sem (Prelim) BSIT 205
Xai Alexandrei Delos Reyes · 40問 · 2年前STS 2nd Sem (Prelim) BSIT 205
STS 2nd Sem (Prelim) BSIT 205
40問 • 2年前Systems Administration 2nd sem (Prelims) BSIT 205
Systems Administration 2nd sem (Prelims) BSIT 205
Xai Alexandrei Delos Reyes · 72問 · 2年前Systems Administration 2nd sem (Prelims) BSIT 205
Systems Administration 2nd sem (Prelims) BSIT 205
72問 • 2年前Discrete Mathematics (Midterms) BSIT 205
Discrete Mathematics (Midterms) BSIT 205
Xai Alexandrei Delos Reyes · 52問 · 1年前Discrete Mathematics (Midterms) BSIT 205
Discrete Mathematics (Midterms) BSIT 205
52問 • 1年前Art Appreciation (Midterm) BSIT 205
Art Appreciation (Midterm) BSIT 205
Xai Alexandrei Delos Reyes · 56問 · 1年前Art Appreciation (Midterm) BSIT 205
Art Appreciation (Midterm) BSIT 205
56問 • 1年前Ethics Mocktest (Midterms) BSIT205
Ethics Mocktest (Midterms) BSIT205
Xai Alexandrei Delos Reyes · 29問 · 1年前Ethics Mocktest (Midterms) BSIT205
Ethics Mocktest (Midterms) BSIT205
29問 • 1年前Comprog Mocktest (Midterm) BSIT 205
Comprog Mocktest (Midterm) BSIT 205
Xai Alexandrei Delos Reyes · 61問 · 1年前Comprog Mocktest (Midterm) BSIT 205
Comprog Mocktest (Midterm) BSIT 205
61問 • 1年前System Administration Mocktest (Midterms) BSIT 205
System Administration Mocktest (Midterms) BSIT 205
Xai Alexandrei Delos Reyes · 65問 · 1年前System Administration Mocktest (Midterms) BSIT 205
System Administration Mocktest (Midterms) BSIT 205
65問 • 1年前Math Mocktest (Pre-finals) BSIT 205
Math Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 49問 · 1年前Math Mocktest (Pre-finals) BSIT 205
Math Mocktest (Pre-finals) BSIT 205
49問 • 1年前Art Appreciation Mocktest (Pre-finals) BSIT 205
Art Appreciation Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 66問 · 1年前Art Appreciation Mocktest (Pre-finals) BSIT 205
Art Appreciation Mocktest (Pre-finals) BSIT 205
66問 • 1年前Ethics Mocktest (Pre-finals) BSIT 205
Ethics Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 50問 · 1年前Ethics Mocktest (Pre-finals) BSIT 205
Ethics Mocktest (Pre-finals) BSIT 205
50問 • 1年前Computer Programming Mocktest (Pre-finals) BSIT 205
Computer Programming Mocktest (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 33問 · 1年前Computer Programming Mocktest (Pre-finals) BSIT 205
Computer Programming Mocktest (Pre-finals) BSIT 205
33問 • 1年前System Administration (Pre-finals) BSIT 205
System Administration (Pre-finals) BSIT 205
Xai Alexandrei Delos Reyes · 52問 · 1年前System Administration (Pre-finals) BSIT 205
System Administration (Pre-finals) BSIT 205
52問 • 1年前Art Appreciation Finals BSIT 205
Art Appreciation Finals BSIT 205
Xai Alexandrei Delos Reyes · 35問 · 1年前Art Appreciation Finals BSIT 205
Art Appreciation Finals BSIT 205
35問 • 1年前Data Structures and Algorithms (Mocktest) BSIT 307
Data Structures and Algorithms (Mocktest) BSIT 307
Xai Alexandrei Delos Reyes · 52問 · 1年前Data Structures and Algorithms (Mocktest) BSIT 307
Data Structures and Algorithms (Mocktest) BSIT 307
52問 • 1年前Object Oriented Programming Mock Test (Mocktest) BSIT 307
Object Oriented Programming Mock Test (Mocktest) BSIT 307
Xai Alexandrei Delos Reyes · 23問 · 1年前Object Oriented Programming Mock Test (Mocktest) BSIT 307
Object Oriented Programming Mock Test (Mocktest) BSIT 307
23問 • 1年前Human Computer Interactions Mocktest (Prelims) BSIT 307
Human Computer Interactions Mocktest (Prelims) BSIT 307
Xai Alexandrei Delos Reyes · 58問 · 1年前Human Computer Interactions Mocktest (Prelims) BSIT 307
Human Computer Interactions Mocktest (Prelims) BSIT 307
58問 • 1年前Principles of Communication Mocktest (Prelims) BSIT 307
Principles of Communication Mocktest (Prelims) BSIT 307
Xai Alexandrei Delos Reyes · 37問 · 1年前Principles of Communication Mocktest (Prelims) BSIT 307
Principles of Communication Mocktest (Prelims) BSIT 307
37問 • 1年前Principles of Communication Mocktest (Midterms) BSIT 307
Principles of Communication Mocktest (Midterms) BSIT 307
Xai Alexandrei Delos Reyes · 29問 · 1年前Principles of Communication Mocktest (Midterms) BSIT 307
Principles of Communication Mocktest (Midterms) BSIT 307
29問 • 1年前Data Structures and Algorithms Mocktest (Midterm) BSIT 307
Data Structures and Algorithms Mocktest (Midterm) BSIT 307
Xai Alexandrei Delos Reyes · 50問 · 1年前Data Structures and Algorithms Mocktest (Midterm) BSIT 307
Data Structures and Algorithms Mocktest (Midterm) BSIT 307
50問 • 1年前Object Oriented Programming Mock Test (Midterm) BSIT 307
Object Oriented Programming Mock Test (Midterm) BSIT 307
Xai Alexandrei Delos Reyes · 13問 · 1年前Object Oriented Programming Mock Test (Midterm) BSIT 307
Object Oriented Programming Mock Test (Midterm) BSIT 307
13問 • 1年前Human Computer Interactions Mocktest (Midterms) BSIT 307
Human Computer Interactions Mocktest (Midterms) BSIT 307
Xai Alexandrei Delos Reyes · 35問 · 1年前Human Computer Interactions Mocktest (Midterms) BSIT 307
Human Computer Interactions Mocktest (Midterms) BSIT 307
35問 • 1年前Readings In Philippine History (Midterms) Mocktest
Readings In Philippine History (Midterms) Mocktest
Xai Alexandrei Delos Reyes · 16問 · 1年前Readings In Philippine History (Midterms) Mocktest
Readings In Philippine History (Midterms) Mocktest
16問 • 1年前Discrete Structures and Algorithms (Midterms) Mocktest
Discrete Structures and Algorithms (Midterms) Mocktest
Xai Alexandrei Delos Reyes · 10問 · 1年前Discrete Structures and Algorithms (Midterms) Mocktest
Discrete Structures and Algorithms (Midterms) Mocktest
10問 • 1年前Principles of Communication (Midterm) Mocktest
Principles of Communication (Midterm) Mocktest
Xai Alexandrei Delos Reyes · 29問 · 1年前Principles of Communication (Midterm) Mocktest
Principles of Communication (Midterm) Mocktest
29問 • 1年前TECHNOPRENEURSHIP PRELIMS BSIT 402
TECHNOPRENEURSHIP PRELIMS BSIT 402
Xai Alexandrei Delos Reyes · 74問 · 1年前TECHNOPRENEURSHIP PRELIMS BSIT 402
TECHNOPRENEURSHIP PRELIMS BSIT 402
74問 • 1年前(Prelim) PH Popular Culture Mocktest BSIT 402
(Prelim) PH Popular Culture Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 19問 · 1年前(Prelim) PH Popular Culture Mocktest BSIT 402
(Prelim) PH Popular Culture Mocktest BSIT 402
19問 • 1年前(Prelim) Integrative Programming BSIT 402
(Prelim) Integrative Programming BSIT 402
Xai Alexandrei Delos Reyes · 46問 · 1年前(Prelim) Integrative Programming BSIT 402
(Prelim) Integrative Programming BSIT 402
46問 • 1年前(Prelim) Quantitive Methods Mocktest BSIT 402
(Prelim) Quantitive Methods Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 39問 · 1年前(Prelim) Quantitive Methods Mocktest BSIT 402
(Prelim) Quantitive Methods Mocktest BSIT 402
39問 • 1年前(Prelim) System Integration and Architecture BSIT 402
(Prelim) System Integration and Architecture BSIT 402
Xai Alexandrei Delos Reyes · 29問 · 1年前(Prelim) System Integration and Architecture BSIT 402
(Prelim) System Integration and Architecture BSIT 402
29問 • 1年前(Prelim) Network Technology Mocktest BSIT 402
(Prelim) Network Technology Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 68問 · 1年前(Prelim) Network Technology Mocktest BSIT 402
(Prelim) Network Technology Mocktest BSIT 402
68問 • 1年前(Prelim) Information Management Mocktest BSIT 402
(Prelim) Information Management Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 45問 · 1年前(Prelim) Information Management Mocktest BSIT 402
(Prelim) Information Management Mocktest BSIT 402
45問 • 1年前(Pre-Finals) Quantitative Research Mocktest BSIT 402
(Pre-Finals) Quantitative Research Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 28問 · 10ヶ月前(Pre-Finals) Quantitative Research Mocktest BSIT 402
(Pre-Finals) Quantitative Research Mocktest BSIT 402
28問 • 10ヶ月前(Finals) Information Management Mocktest
(Finals) Information Management Mocktest
Xai Alexandrei Delos Reyes · 64問 · 9ヶ月前(Finals) Information Management Mocktest
(Finals) Information Management Mocktest
64問 • 9ヶ月前(Finals) Philippine Popular Culture Mocktest
(Finals) Philippine Popular Culture Mocktest
Xai Alexandrei Delos Reyes · 46問 · 9ヶ月前(Finals) Philippine Popular Culture Mocktest
(Finals) Philippine Popular Culture Mocktest
46問 • 9ヶ月前(Finals) Integrative Programming Mocktest BSIT 402
(Finals) Integrative Programming Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 24問 · 9ヶ月前(Finals) Integrative Programming Mocktest BSIT 402
(Finals) Integrative Programming Mocktest BSIT 402
24問 • 9ヶ月前(Finals) Network Technology Mocktest BSIT 402
(Finals) Network Technology Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 37問 · 9ヶ月前(Finals) Network Technology Mocktest BSIT 402
(Finals) Network Technology Mocktest BSIT 402
37問 • 9ヶ月前(Finals) Quantitative Methods Mocktest BSIT 402
(Finals) Quantitative Methods Mocktest BSIT 402
Xai Alexandrei Delos Reyes · 18問 · 9ヶ月前(Finals) Quantitative Methods Mocktest BSIT 402
(Finals) Quantitative Methods Mocktest BSIT 402
18問 • 9ヶ月前Application Development Mocktest (Prelim) BSIT 505
Application Development Mocktest (Prelim) BSIT 505
Xai Alexandrei Delos Reyes · 72問 · 6ヶ月前Application Development Mocktest (Prelim) BSIT 505
Application Development Mocktest (Prelim) BSIT 505
72問 • 6ヶ月前Data and Digital Communication Mocktest (Prelim) BSIT 505
Data and Digital Communication Mocktest (Prelim) BSIT 505
Xai Alexandrei Delos Reyes · 60問 · 6ヶ月前Data and Digital Communication Mocktest (Prelim) BSIT 505
Data and Digital Communication Mocktest (Prelim) BSIT 505
60問 • 6ヶ月前(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問 · 6ヶ月前(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問 • 6ヶ月前Enterprise Architecture Mocktest (Prelims) BSIT 505
Enterprise Architecture Mocktest (Prelims) BSIT 505
Xai Alexandrei Delos Reyes · 42問 · 6ヶ月前Enterprise Architecture Mocktest (Prelims) BSIT 505
Enterprise Architecture Mocktest (Prelims) BSIT 505
42問 • 6ヶ月前Professional Issues in Information Technology Mocktest (Prelims) BSIT 505
Professional Issues in Information Technology Mocktest (Prelims) BSIT 505
Xai Alexandrei Delos Reyes · 44問 · 6ヶ月前Professional Issues in Information Technology Mocktest (Prelims) BSIT 505
Professional Issues in Information Technology Mocktest (Prelims) BSIT 505
44問 • 6ヶ月前Application Development Mocktest (Midterm) BSIT 505
Application Development Mocktest (Midterm) BSIT 505
Xai Alexandrei Delos Reyes · 42問 · 6ヶ月前Application Development Mocktest (Midterm) BSIT 505
Application Development Mocktest (Midterm) BSIT 505
42問 • 6ヶ月前Event-Driven Programming Mocktest (Midterm) BSIT - 505
Event-Driven Programming Mocktest (Midterm) BSIT - 505
Xai Alexandrei Delos Reyes · 61問 · 6ヶ月前Event-Driven Programming Mocktest (Midterm) BSIT - 505
Event-Driven Programming Mocktest (Midterm) BSIT - 505
61問 • 6ヶ月前Data and Digital Communication Mocktest (Midterm) BSIT - 505
Data and Digital Communication Mocktest (Midterm) BSIT - 505
Xai Alexandrei Delos Reyes · 80問 · 6ヶ月前Data and Digital Communication Mocktest (Midterm) BSIT - 505
Data and Digital Communication Mocktest (Midterm) BSIT - 505
80問 • 6ヶ月前(Midterm) Advanced Systems and Integration Architecture BSIT - 505
(Midterm) Advanced Systems and Integration Architecture BSIT - 505
Xai Alexandrei Delos Reyes · 68問 · 5ヶ月前(Midterm) Advanced Systems and Integration Architecture BSIT - 505
(Midterm) Advanced Systems and Integration Architecture BSIT - 505
68問 • 5ヶ月前(Midterms) Enterprise Architecture Mocktest BSIT 505
(Midterms) Enterprise Architecture Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 69問 · 5ヶ月前(Midterms) Enterprise Architecture Mocktest BSIT 505
(Midterms) Enterprise Architecture Mocktest BSIT 505
69問 • 5ヶ月前(Midterm) Professional Issues in Information Technology BSIT 505
(Midterm) Professional Issues in Information Technology BSIT 505
Xai Alexandrei Delos Reyes · 38問 · 5ヶ月前(Midterm) Professional Issues in Information Technology BSIT 505
(Midterm) Professional Issues in Information Technology BSIT 505
38問 • 5ヶ月前(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 59問 · 4ヶ月前(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
(Pre-Finals)Event-Driven Programming Mocktest BSIT 505
59問 • 4ヶ月前(Pre-finals) Application Development Mocktest BSIT 505
(Pre-finals) Application Development Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 41問 · 4ヶ月前(Pre-finals) Application Development Mocktest BSIT 505
(Pre-finals) Application Development Mocktest BSIT 505
41問 • 4ヶ月前(Pre-Finals) Data and Digital Communication Mocktest BSIT 505
(Pre-Finals) Data and Digital Communication Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 57問 · 4ヶ月前(Pre-Finals) Data and Digital Communication Mocktest BSIT 505
(Pre-Finals) Data and Digital Communication Mocktest BSIT 505
57問 • 4ヶ月前(Pre-Finals) ASIA Mocktest BSIT 505
(Pre-Finals) ASIA Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 44問 · 4ヶ月前(Pre-Finals) ASIA Mocktest BSIT 505
(Pre-Finals) ASIA Mocktest BSIT 505
44問 • 4ヶ月前(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 72問 · 4ヶ月前(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
(Pre-Finals) Advanced Database Systems Mocktest BSIT 505
72問 • 4ヶ月前(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 42問 · 4ヶ月前(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
(Pre-Finals) Enterprise Architecture Mocktest BSIT 505
42問 • 4ヶ月前(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問 · 4ヶ月前(Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505
(Pre-Finals) Professional Issues In Information Technolog Mocktest BSIT 505
62問 • 4ヶ月前(Finals) Application Development Mocktest BSIT 505
(Finals) Application Development Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 62問 · 3ヶ月前(Finals) Application Development Mocktest BSIT 505
(Finals) Application Development Mocktest BSIT 505
62問 • 3ヶ月前(Finals) Data and Digital Communication Mocktest BSIT - 505
(Finals) Data and Digital Communication Mocktest BSIT - 505
Xai Alexandrei Delos Reyes · 61問 · 3ヶ月前(Finals) Data and Digital Communication Mocktest BSIT - 505
(Finals) Data and Digital Communication Mocktest BSIT - 505
61問 • 3ヶ月前(Finals) Advanced Database Systems Mocktest BSIT 505
(Finals) Advanced Database Systems Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 62問 · 3ヶ月前(Finals) Advanced Database Systems Mocktest BSIT 505
(Finals) Advanced Database Systems Mocktest BSIT 505
62問 • 3ヶ月前(Finals) Enterprise Architecture Mocktest BSIT 505
(Finals) Enterprise Architecture Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 60問 · 3ヶ月前(Finals) Enterprise Architecture Mocktest BSIT 505
(Finals) Enterprise Architecture Mocktest BSIT 505
60問 • 3ヶ月前(Finals) Professional issues in Information Technology Mocktest BSIT 505
(Finals) Professional issues in Information Technology Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 27問 · 3ヶ月前(Finals) Professional issues in Information Technology Mocktest BSIT 505
(Finals) Professional issues in Information Technology Mocktest BSIT 505
27問 • 3ヶ月前(Finals) Event-Driven Programming Mocktest BSIT 505
(Finals) Event-Driven Programming Mocktest BSIT 505
Xai Alexandrei Delos Reyes · 65問 · 4ヶ月前(Finals) Event-Driven Programming Mocktest BSIT 505
(Finals) Event-Driven Programming Mocktest BSIT 505
65問 • 4ヶ月前(Prelims) Mobile Systems and Technologies Mocktest BSIT 604
(Prelims) Mobile Systems and Technologies Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 41回閲覧 · 42問 · 1ヶ月前(Prelims) Mobile Systems and Technologies Mocktest BSIT 604
(Prelims) Mobile Systems and Technologies Mocktest BSIT 604
41回閲覧 • 42問 • 1ヶ月前(Prelims) Great Books Mocktest BSIT 604
(Prelims) Great Books Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 46回閲覧 · 75問 · 1ヶ月前(Prelims) Great Books Mocktest BSIT 604
(Prelims) Great Books Mocktest BSIT 604
46回閲覧 • 75問 • 1ヶ月前(Prelims) Management Information Systems Mocktest BSIT - 604
(Prelims) Management Information Systems Mocktest BSIT - 604
Xai Alexandrei Delos Reyes · 70回閲覧 · 94問 · 1ヶ月前(Prelims) Management Information Systems Mocktest BSIT - 604
(Prelims) Management Information Systems Mocktest BSIT - 604
70回閲覧 • 94問 • 1ヶ月前(Prelims) Programming Languages Mocktest BSIT 604
(Prelims) Programming Languages Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 26回閲覧 · 79問 · 1ヶ月前(Prelims) Programming Languages Mocktest BSIT 604
(Prelims) Programming Languages Mocktest BSIT 604
26回閲覧 • 79問 • 1ヶ月前(Prelims) Web Systems and Technologies Mocktest BSIT 604
(Prelims) Web Systems and Technologies Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 33回閲覧 · 99問 · 29日前(Prelims) Web Systems and Technologies Mocktest BSIT 604
(Prelims) Web Systems and Technologies Mocktest BSIT 604
33回閲覧 • 99問 • 29日前(Prelims) Information Assurance and Security Mocktest BSIT 604
(Prelims) Information Assurance and Security Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 33回閲覧 · 92問 · 27日前(Prelims) Information Assurance and Security Mocktest BSIT 604
(Prelims) Information Assurance and Security Mocktest BSIT 604
33回閲覧 • 92問 • 27日前(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 54問 · 16日前(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
(Midterms) Mobile Systems and Technologies Mocktest BSIT 604
54問 • 16日前(Midterm) Great Books Mocktest BSIT 604
(Midterm) Great Books Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 74問 · 10日前(Midterm) Great Books Mocktest BSIT 604
(Midterm) Great Books Mocktest BSIT 604
74問 • 10日前(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 69問 · 4日前(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 04 to 05_Handout Management Information Systems Mocktest BSIT 604
69問 • 4日前(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 36問 · 4日前(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
(Midterms) 06_Handout Management Information Systems Mocktest BSIT 604
36問 • 4日前(Midterms) Programming Languages Mocktest BSIT 604
(Midterms) Programming Languages Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 81問 · 3日前(Midterms) Programming Languages Mocktest BSIT 604
(Midterms) Programming Languages Mocktest BSIT 604
81問 • 3日前(Midterms) Information Assurance and Security Mocktest BSIT 604
(Midterms) Information Assurance and Security Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 84問 · 4日前(Midterms) Information Assurance and Security Mocktest BSIT 604
(Midterms) Information Assurance and Security Mocktest BSIT 604
84問 • 4日前(Midterms) Web Systems an Technologies Mocktest BSIT 604
(Midterms) Web Systems an Technologies Mocktest BSIT 604
Xai Alexandrei Delos Reyes · 87問 · 2日前(Midterms) Web Systems an Technologies Mocktest BSIT 604
(Midterms) Web Systems an Technologies Mocktest BSIT 604
87問 • 2日前問題一覧
1
Transaction
2
Database Request
3
Database consistent state
4
Transaction log
5
Atomicity
6
Consistency
7
Isolation
8
Durability
9
BEGIN TRANSACTION
10
COMMIT
11
ROLLBACK TRANSACTION
12
SAVE TRANSACTION
13
@@TRANCOUNT
14
Active state
15
Partially committed state
16
Committed state
17
Failed State
18
Terminated
19
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
Lost Update
21
Uncommitted data
22
Inconsistent retrievals
23
Lock
24
The entire table is locked.
25
The entire table is locked
26
Locks the entire database
27
Locks the entire database
28
An exclusive lock exists when access is reserved specifically for the transaction that locked the object.
29
Has only two states: locked (1) and unlocked (0)
30
Deadlock
31
Deadlock prevention
32
Deadlock detection
33
Deadlock avoidance
34
Dirty Read
35
Non-repeatable read
36
Phantom Read
37
it is a default isolation level for SQL Server
38
Ensures that no other transactions can modify or delete data that has been read by the current transaction until the current transaction commits
39
Most restrictive level and gives solution to the phantom read problem.
40
Is the least restrictive isolation level
41
data warehouse
42
Subject-Oriented
43
Integrated
44
Time-variant
45
Non-volatile
46
Data Warehouse Database
47
Extraction, Transformation, and Loading Tools (ETL)
48
Metadata
49
Technical Metadata
50
Business Metadata
51
Data Warehouse Access Tools
52
Query and reporting tool
53
Application development tools
54
Data mining
55
OLAP tools
56
Data Marts
57
star schema
58
Facts table
59
Dimension table
60
Online Analytical Processing (OLAP)
61
Online Transaction Processing (OLTP)
62
Manages day to day operations
63
Provides historical data for reporting and planning
64
Multi-dimensional data analysis techniques
65
Advanced Database support
66
Easy-to-use end-user interfaces
67
Multi-dimensional OLAP (MOLAP)
68
Relational OLAP (ROLAP)
69
Uses data cubes
70
Unlimited dimensions
71
ROLLUP operator
72
CUBE operator
73
PIVOT operator
74
Data mining
75
Classification
76
Clustering
77
Regression
78
Association Rules
79
Outer detection Rules
80
Sequential Patterns
81
Prediction
82
used to identify and analyze the relationship between variables.