Networking, DBMS [Computer Networks (25) + DBMS (25)] — 01 Aug 2026 — Free Online Test

Computer Networks

Q1 / 50

Minimum IPv4 header size is

A 10 bytes B 40 bytes C 16 bytes D 20 bytes

Computer Networks

Q2 / 50

What is Tendermint

A BFT consensus algorithm used in blockchains B Physical consensus C Protocol network D Security consensus

Computer Networks

Q3 / 50

Coherent optical uses modulation like

A QAM encoding phase and amplitude for higher capacity B PAM4 only C FM only D AM only

Computer Networks

Q4 / 50

BGP large communities have

A 16-bit values B 32-bit values C 8-bit values D 64-bit values (3 x 32-bit integers)

Computer Networks

Q5 / 50

What is femtocell

A Physical femto B Very small low-power indoor cell for home/office coverage C Protocol femto D Security femto

Computer Networks

Q6 / 50

OSPF Type 2 LSA is

A Network LSA from DR B Router LSA C Summary LSA D External LSA

Computer Networks

Q7 / 50

DNS-based load balancing returns

A Same IP always B No IP C Random IP always D Different IPs for same name based on load or location

Computer Networks

Q8 / 50

IPV6 has got bytes for addressing of hosts.

A 16 B 8 C 4 D 2

Computer Networks

Q9 / 50

AWS security group is

A Authentication group B Access control list only C Physical security device D Stateful virtual firewall for EC2 instances

Computer Networks

Q10 / 50

TCP Vegas uses

A Packet loss signal B Duplicate ACK C RTT change as congestion signal D Timeout signal

Computer Networks

Q11 / 50

CAB stands for

A Critical Advisory Board B Control Access Board C Change Advisory Board D Change Access Board

Computer Networks

Q12 / 50

What is IPv6 anycast address

A Protocol anycast B Security anycast C Physical anycast D Address assigned to multiple interfaces routing to nearest

Computer Networks

Q13 / 50

What is DNS64 used with NAT64

A Synthesizing AAAA records for IPv4-only servers B Protocol DNS64 C Security DNS64 D Physical DNS64

Computer Networks

Q14 / 50

What is inter-frame gap?

A idle time between frames B idle time between frame bits C idle time between packets D none of the above

Computer Networks

Q15 / 50

PaaS provides

A Security only B Infrastructure only C Application only D Development platform with managed infrastructure

Computer Networks

Q16 / 50

SCTP supports

A Half-duplex only B Single-homing only C UDP only D Multi-homing (multiple IP addresses per connection)

Computer Networks

Q17 / 50

What is IANA protocol number registry

A Security registry B Physical registry C Protocol registry D Maintaining assigned protocol numbers for IP and transport layers

Computer Networks

Q18 / 50

Data plane handles

A Actual packet forwarding using FIB B Security policies C Routing protocols D Management

Computer Networks

Q19 / 50

_______ in the data link layer separates a message from one source to a destination, or from other messages going from other sources to other destinations.

A Digitizing B Controlling C Framing D none of the above

Computer Networks

Q20 / 50

Network architecture defines

A Protocol only B Physical layout only C Security only D Structure of hardware software and protocols in a network

Computer Networks

Q21 / 50

Which of the following does UDP guarantee?

A flow control B connection-oriented delivery C flow control D none of the above

Computer Networks

Q22 / 50

What is DKIM selector

A Protocol selector B Security selector C Identifier specifying which DKIM key to use for verification D Physical selector

Computer Networks

Q23 / 50

SHA-256 output is

A 128 bits B 160 bits C 256 bits D 512 bits

Computer Networks

Q24 / 50

DNS resolves

A IP to MAC B Port to IP C MAC to IP D Domain name to IP address

Computer Networks

Q25 / 50

OSI model was developed by which organization

A ISO B IETF C ANSI D IEEE

DBMS

Q26 / 50

Designers use which of the following to tune the performance of systems to support time-critical operations?

A denormalization B redundant optimization C optimization D realization

DBMS

Q27 / 50

What is a reverse key index in Oracle and what problem does it solve?

A An index that searches backwards through the B-tree B An index that stores rows in reverse insertion order C An index where the bytes of the key are reversed before storage in the B-tree distributing sequential key inserts (like auto-increment IDs) across all index leaf blocks instead of always inserting into the rightmost block - reduces right-hand-side contention in OLTP systems D An index with keys stored in reverse alphabetical order

DBMS

Q28 / 50

What is the concept of nested transactions and how do they relate to SAVEPOINTS?

A Nested transactions always commit when the outer transaction commits B Nested transactions are only available in Oracle C Nested transactions are not supported in any DBMS D A nested transaction is a transaction started within another transaction; in most DBMS true nested transactions are not supported but SAVEPOINTs provide similar functionality - a ROLLBACK TO SAVEPOINT is analogous to rolling back an inner transaction while keeping the outer transaction alive

DBMS

Q29 / 50

Relational Algebra is

A Data Definition Language . B Meta Language C Procedural query Language D None of the above

DBMS

Q30 / 50

What is role-based access control (RBAC) in database security?

A RBAC: privileges are assigned to roles (logical groups) and roles are assigned to users; changing a roles privileges automatically affects all users with that role. Direct grants: privileges assigned directly to individual users making management complex and error-prone at scale B Roles can only be assigned to database administrators C RBAC is weaker than direct privilege grants D RBAC is identical to direct privilege grants

DBMS

Q31 / 50

Question::find(1) returns

A All questions B Question with PK=1 or NULL if not found C Questions where id>1 D First question only

DBMS

Q32 / 50

Which SQL creates an auto-updating updated_at column in MySQL

A updated_at DATETIME DEFAULT NOW() B updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP C updated_at DATE D updated_at INT

DBMS

Q33 / 50

What is the index nested loop join and what conditions make it efficient?

A A join algorithm that processes loops in parallel B An index join that works only with primary keys C A nested loop join that creates indexes during execution D A join where for each row in the outer table the DBMS uses an index on the inner tables join key to directly look up matching rows - efficient when: outer table is small inner table has an appropriate index on the join column and join selectivity is low

DBMS

Q34 / 50

What is the formal definition of functional dependency?

A A constraint X determines Y where for any two tuples with the same X value they must also have the same Y value (X functionally determines Y) B A constraint where a function must exist for every attribute C A dependency between stored procedures D A constraint where one table references another

DBMS

Q35 / 50

To add a new column 'marks' INT DEFAULT 0 to existing questions table in Laravel migration

A Schema::create('questions',fn($t)=>$t->integer('marks')) B ALTER TABLE questions ADD marks INT DEFAULT 0 C Schema::table('questions', function(Blueprint $t){ $t->integer('marks')->default(0); }) D DB::statement('ALTER TABLE...')

DBMS

Q36 / 50

X (exclusive) lock is compatible with

A S lock B IS lock C IX lock D No other lock type

DBMS

Q37 / 50

What is a long-running transaction and what problems does it cause in a DBMS?

A A transaction that remains open for an extended period causing: accumulated locks blocking other transactions MVCC undo/version storage growth (old versions cannot be purged) replication lag in logical replication and increased probability of conflict/deadlock B A transaction affecting a large number of rows C A transaction that takes more than 1 second D A transaction that spans multiple database servers

DBMS

Q38 / 50

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

A Candidate key B Sub key C Super key D Foreign key

DBMS

Q39 / 50

What is a partial index (also called filtered index) and when is it beneficial?

A An index that only indexes part of the data physically B An index built incrementally over time C An index that includes only rows satisfying a specified condition (WHERE clause) creating a smaller more efficient index for queries with that condition - e.g. CREATE INDEX ON orders(customer_id) WHERE status=pending D An index on a subset of columns

DBMS

Q40 / 50

Which is NOT a property of ACID transactions?

A Atomicity B Concurrency C Durability D Isolation

DBMS

Q41 / 50

Function-based index allows

A Indexing NULLs B Indexing result of expression/function applied to columns C Indexing stored procedures D Indexing all columns at once

DBMS

Q42 / 50

Atomicity ensures

A Only consistency maintained B Transaction happens in entirety or not at all C Transactions are fast D Data is backed up

DBMS

Q43 / 50

Armstrong's Reflexivity: if Y⊆X then

A X→Z B XZ→YZ C X→Y D Y→X

DBMS

Q44 / 50

Shared (S) lock allows

A One writer only B Multiple concurrent readers no writers C One reader and writer D All operations

DBMS

Q45 / 50

Designers use which of the following to tune the performance of systems to support timecritical operations?

A Denormalization B Redundant optimization C Optimization D Realization

DBMS

Q46 / 50

The set of permitted value for each attribute is called its

A Attribute set B Attentive range C Domain D Group

DBMS

Q47 / 50

A relation is considered a:

A Column B One dimensional table C Two dimensional table D Three dimensional table

DBMS

Q48 / 50

A transparent DBMS

A both can not hide sensitive information from users and keeps its logical structure hidden from users B keeps its physical structure hidden from users C can not hide sensitive information from users D keeps its logical structure hidden from users

DBMS

Q49 / 50

Aggregate functions are functions that take a as input and return a single value.

A collection of values B single value C aggregate value D both collection of values & single value

DBMS

Q50 / 50

Which of the following hardware component is the most important to the operation of a database management system?

A High resolution video display B Printer C High speed, large capacity disk D Mouse

Submit Test?