Databases MCQs – Set 30

By Atul Sahu • Computer Science, Databases

Databases MCQs – Set 30

UGC NET Paper 2 Computer Science NOV 2017 – Databases

581. Which SQL command changes fields in a record?

Databases • DML • UGC NET Paper 2 Computer Science NOV 2017

A. LOOK-UP B. INSERT C. MODIFY D. CHANGE

582. Match RDBMS integrity types:

Databases • Integrity constraints • UGC NET Paper 2 Computer Science NOV 2017

A. (iii)(iv)(i)(ii) B. (iv)(iii)(ii)(i) C. (iv)(ii)(iii)(i) D. (ii)(iii)(iv)(i)

583. In RDBMS, different classes of relations created to prevent anomalies via?

Databases • Normalization • UGC NET Paper 2 Computer Science NOV 2017

A. Functional Dependencies B. Data integrity C. Referential integrity D. Normal Forms

584. In SQL, which is an aggregate function?

Databases • SQL functions • UGC NET Paper 2 Computer Science NOV 2017

A. SELECT B. CREATE C. AVG D. MODIFY

585. Which is/are true regarding ‘view’ in DBMS?

Databases • Views • UGC NET Paper 2 Computer Science NOV 2017

A. Only (a) is true B. Only (b) is true C. Both (a) and (b) are true D. Neither is true

586. Expression AB+ĀB = ?

Discrete Structures and Optimization • Boolean Algebra • UGC NET Paper 2 Computer Science NOV 2017

A. A∪B B. A⊗B C. (A∪B)–A D. (A⊗B)∪A

587. Encode data 0011 as 7-bit even-parity Hamming code.

Discrete Structures and Optimization • Error-Control Coding • UGC NET Paper 2 Computer Science NOV 2017

A. 11110 B. 101110 C. 1000011 D. 11100

588. A graph has an Eulerian circuit iff it’s connected and all vertices have __ degree.

Discrete Structures and Optimization • Graph Theory • UGC NET Paper 2 Computer Science NOV 2017

A. even degree B. odd degree C. any degree D. even count

589. Minimum edges in a connected n-vertex graph is __.

Discrete Structures and Optimization • Graph Theory • UGC NET Paper 2 Computer Science NOV 2017

A. n(n–1) B. n(n–1)/2 C. n² D. n–1

590. Octal 4057.06 to decimal = __.

Discrete Structures and Optimization • Number Bases • UGC NET Paper 2 Computer Science NOV 2017

A. 2095.75 B. 2095.075 C. 2095.937 D. 2095.0937

591. # divisible by 2, 5, 7 between 1–250?

Discrete Structures and Optimization • Number Theory • UGC NET Paper 2 Computer Science NOV 2017

A. 2 B. 3 C. 5 D. 8

592. A poset is a lattice if every two elements have a ___.

Discrete Structures and Optimization • Order Theory • UGC NET Paper 2 Computer Science NOV 2017

A. unique LUB B. unique GLB C. both D. none

593. “x1 is a clone of x” based on identical physical attributes—cloning is an equivalence relation. Impression?

Discrete Structures and Optimization • Relations • UGC NET Paper 2 Computer Science NOV 2017

A. true B. false C. cannot compute D. none

594. For Y = √(–2x + 3), domain and range are __.

Discrete Structures and Optimization • Functions & Relations • UGC NET Paper 2 Computer Science NOV 2017

A. x ≥ 3/2, y ≥ 0 B. x > 3/2, y ≤ 0 C. x ≥ 3/2, y ≤ 0 D. x ≤ 3/2, y ≤ 0

595. Max edges in an n-node undirected graph (no self‐loops)?

Discrete Structures and Optimization • Graph Theory • UGC NET Paper 2 Computer Science NOV 2017

A. n^2 B. n(n – 1) C. n(n + 1) D. n(n – 1)/2

596. The uncertainty in a symbol system is called __.

Discrete Structures and Optimization • Information Theory • UGC NET Paper 2 Computer Science NOV 2017

A. Bandwidth B. Entropy C. Loss D. Quantum

597. Absorption law states

Discrete Structures and Optimization • Boolean algebra • UGC NET Paper 2 Computer Science NOV 2017

A. X+X=X B. X·X=X C. X+X·Y=X D. None

598. (A+B)/AB equals

Discrete Structures and Optimization • Boolean algebra • UGC NET Paper 2 Computer Science NOV 2017

A. A ⊕ B B. A ∪ B C. (A ⊕ B) ∪ A D. (A ∪ B) ⊕ A

599. Aligning two 100-section disks painted red/blue can match at least how many sections?

Discrete Structures and Optimization • Combinatorics • UGC NET Paper 2 Computer Science NOV 2017

A. 100 B. 125 C. 150 D. 175

600. Number of different labeled trees with 8 nodes is

Discrete Structures and Optimization • Graph Theory • UGC NET Paper 2 Computer Science NOV 2017

A. 256 B. 255 C. 248 D. none

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 30

Related Posts