DBMS-Object-Relational Database Questions and Answers

Practice Mode
Showing 10 of 62 questions
Q51
The shared-memory architecture of parallel database system is closet to the
  • A centralised database system.
  • B distributed database system.
  • C client/server system
  • D None of these
Answer: Option A
Q52
In shared-nothing architecture, each CPU has its own copy of
  • A DBMS
  • B portion of data managed by the DBMS
  • C Operating system
  • D All of these
Answer: Option D
Q53
A global locking system is required in
  • A shared-disk architecture.
  • B Shared-nothing architecture
  • C shared-memory architecture
  • D None of these.
Answer: Option A
Q54
The scalability of shared-disk system is largely determined by the
  • A capacity of the interconnection network mechanism.
  • B throughput of the interconnection network mechanism.
  • C Both (a) and (b)
  • D None of these
Answer: Option C
Q55
Locking is the
  • A coordination of current tasks.
  • B method of synchronising current task.
  • C Both (a) and (b)
  • D None of these
Answer: Option C
Q56
Speed-up is a property in which the time taken for performing a task
  • A decrease in propertion to the increase in the number of CPUs and disks in parallel
  • B increase in propertion to the increase in the number of CPUs and disks in parallel.
  • C Both (a) and (b)
  • D None of these
Answer: Option A
Q57
synchronisation is the
  • A coordination of current tasks.
  • B method of synchronising current task.
  • C Both (a) and (b)
  • D None of these
Answer: Option C
Q58
Parallelism in which the relations are partitioned on multiple disks to reduce the retrieval time of relations from disk is called
  • A I/O parallelism
  • B inter-operation parallelism.
  • C intra-query parallelism.
  • D inter-query parallelism.
Answer: Option A
Q59
In intra-query parallelism
  • A the execution of a single query is done in parallel on multiple CPUs using shared-nothing parallel architecture technique.
  • B multiple transactions are executed in parallel, one by each (CPU).
  • C We parallelise the execution of each individual operation of a task, such as sorting,j projection, join and so on.
  • D the different operations in a query experssion are executed in parallel.
Answer: Option A
Q60
In inter-query parallelism,
  • A the execution of a single query is done in parallel on multiple CPUs using shared-nothing parallel architecture technique.
  • B multiple transactions are executed in paralle, one by each (CPU)
  • C We parallelise the execution of each individual operation of task, such as sorting, projection, join and so on.
  • D the different operations in a query expresion are executed in parallel.
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test