Databases MCQs – Set 25

By Atul Sahu • Computer Science, Databases

Databases MCQs – Set 25

UGC NET Paper 2 Computer Science JUNE 2010 – Databases

481. An entity instance is a single occurrence of an _______.

Databases • ER Modeling • UGC NET Paper 2 Computer Science JUNE 2010

A. entity type B. relationship type C. entity and relationship type D. None of these

482. Match: I. 2NF (a) transitive dependencies eliminated; II. 3NF (b) multivalued attrs removed; III. 4NF (c) no partial FDs; IV. 5NF (d) no join dependencies. Codes I II III IV = ?

Databases • Normalization • UGC NET Paper 2 Computer Science JUNE 2010

A. a c b d B. d a b c C. c d a b D. d b a c

483. The PROJECT command creates a new table with:

Databases • Relational Algebra • UGC NET Paper 2 Computer Science JUNE 2010

A. more fields than the original table B. more rows than original table C. both (A) & (B) D. none of these

484. What deletes all file records except structure?

Databases • DML Commands • UGC NET Paper 2 Computer Science JUNE 2010

A. ERASE B. DELETE C. ZAP D. PACK

485. Which command closes an alternate file?

Databases • File Handling • UGC NET Paper 2 Computer Science JUNE 2010

A. SET ALTERNATE OFF B. CLOSE C. CLOSE ALTERNATE D. CLEAR ALL

486. After modifying DBF with 20 records, `? BOF()` prints __.

Databases • File Pointers • UGC NET Paper 2 Computer Science JUNE 2010

A. ? EOF() Prints .T B. ? BOF() Prints F C. ? BOF() Prints T D. ? EOF() Prints F

487. B⁺-trees are preferred over binary trees because __.

Databases • Index Structures • UGC NET Paper 2 Computer Science JUNE 2010

A. Disk capacities are greater than memory capacities B. Disk access much slower than memory access C. Disk data transfer rates are much less than memory data transfer rate D. Disk are more reliable than memory

488. Data security threats include __.

Databases • Security & Threats • UGC NET Paper 2 Computer Science JUNE 2010

A. privacy invasion B. hardware failure C. fraudulent manipulation of data D. encryption and decryption

489. SQL finds branches with assets > any branch in DELHI.

Databases • SQL Queries • UGC NET Paper 2 Computer Science JUNE 2010

A. all branches that have greater asset than any branch located in DELHI. B. all branches that have greater assets than allocated in DELHI. C. the branch that has the greatest asset in DELHI. D. any branch that has greater asset than any branch located in DELHI.

490. Variants of timestamp concurrency control include

Databases • Concurrency Control • UGC NET Paper 2 Computer Science JUNE 2010

A. total ordering B. partial ordering C. multiversion ordering D. all

491. Data warehousing refers to

Databases • Data Warehousing • UGC NET Paper 2 Computer Science JUNE 2010

A. offline storage B. regular backup C. related to mining D. tape vs disk

492. A VSAM file organization is

Databases • File Systems • UGC NET Paper 2 Computer Science JUNE 2010

A. relative record DS B. keyed sequential DS C. entry sequential DS D. all

493. Disk accesses for inserting in a B-tree of height h is

Databases • Indexing • UGC NET Paper 2 Computer Science JUNE 2010

A. O(1) B. O(log h) C. O(h) D. none

494. Decomposition in DB design eliminates

Databases • Normalization • UGC NET Paper 2 Computer Science JUNE 2010

A. redundancy B. inconsistency C. anomalies D. all

495. Which recovery technique in DDBMS?

Databases • Transaction Management • UGC NET Paper 2 Computer Science JUNE 2010

A. 2-phase commit B. backup C. immediate update D. all

496. A transaction’s basic DB operations include

Databases • Transactions • UGC NET Paper 2 Computer Science JUNE 2010

A. Read_item(X) B. Write_item(X) C. both D. none

497. Max keys in a B-tree of order m and depth d is?

Databases • B-Tree Properties • UGC NET Paper 2 Computer Science JUNE 2010

A. d & h B. c & k C. g,b,c,h,i,m D. c & h

498. UWA communicates records between?

Databases • DBMS Interfaces • UGC NET Paper 2 Computer Science JUNE 2010

A. System testing B. White box testing C. Black box testing D. Unit testing

499. In DML, RECONNECT cannot be used with which set?

Databases • DML Statements • UGC NET Paper 2 Computer Science JUNE 2010

A. Circle() B. Ellipse() C. RoundRect() D. Pie()

500. Which is true about BCNF and 3NF?

Databases • Normal Forms • UGC NET Paper 2 Computer Science JUNE 2010

A. Absolute B. Indirect C. Immediate D. Index

Disclaimer for MCQ Quiz
This quiz is for educational purposes only…

0 0 votes

Article Rating

0 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Databases MCQs – Set 25

Related Posts