Aspire Faculty ID #18871 · Topic: UGC NET Computer Science Nov 2021 (Paper II) · Just now
UGC NET Computer Science Nov 2021 (Paper II)

Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a $2\times2\times2$ table as shown below.
toothache$\neg$toothache
catch$\neg$catchcatch$\neg$catch
cavity$0.108$$0.012$$0.072$$0.008$
$\neg$cavity$0.016$$0.064$$0.144$$0.576$
Which of the DBMS component ensures that concurrent execution of multiple operations on the database results into a consistent database state?

Solution

Concurrent execution means many transactions may execute at the same time.

The transaction processing system controls concurrency and recovery.

It ensures that even with multiple transactions, the database remains in a consistent state.

Logs help in recovery, buffer manager manages memory pages, and file manager manages storage files.

Previous 10 Questions — UGC NET Computer Science Nov 2021 (Paper II)

Nearest first
1
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
2
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
3
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
4
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
5
Consider a domain consisting of three Boolean variables Toothache, Cavity, and Catch. The full joint distribution is a …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
6
Consider the sentence below.There is a country that borders both India and Pakistan.Which of the following logical expr…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
7
Which among the following statement(s) is(are) FALSE?A. Greedy best-first search is not optimal but is often efficient.…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
8
Consider the given tree below. Calculate the value at the root of the tree using alpha‐beta pruning algorithm.
Topic: UGC NET Computer Science Nov 2021 (Paper II)
9
Given below are two statementsStatement I: Breadth-First Search is optimal when all the step costs are equal whereas un…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
10
Which agent deals with the happy and unhappy state?
Topic: UGC NET Computer Science Nov 2021 (Paper II)

Next 10 Questions — UGC NET Computer Science Nov 2021 (Paper II)

Ascending by ID
1
Consider following two statements:Statement I: Relational database schema represents the logical design of the database…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
2
Given a fixed-length record file that is ordered on the key field. The file needs $B$ disk blocks to store $R$ number o…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
3
Given the following STUDENT-COURSE scheme:STUDENT(Rollno, Name, courseno)COURSE(courseno, coursename, capacity)where Ro…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
4
STUDENT(Rollno, Name, Courseno)COURSE(Courseno, Coursename, Capacity)where Rollno is the primary key of relation STUDEN…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
5
Suppose a B tree is used for indexing a database file. Consider the following information:size of the search key field …
Topic: UGC NET Computer Science Nov 2021 (Paper II)
6
Given a relation scheme $R(x,y,z,w)$ with functional dependencies set$F=\{x\to y,\ z\to w\}$.All attributes take single…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
7
A company is consuming parts in the manufacturing of other products. Each of the part is either manufactured within the…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
8
 A transaction may be in one of the following states during its execution life cycle in concurrent execution envir…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
9
 Which of the following is used to create a database schema?
Topic: UGC NET Computer Science Nov 2021 (Paper II)
10
Given memory access time as $p$ nanoseconds and additional $q$ nanoseconds for handling the page fault. What is the eff…
Topic: UGC NET Computer Science Nov 2021 (Paper II)
Ask Your Question or Put Your Review.

loading...