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

Computer Networks

Q1 / 50

MPLS QoS can use

A EXP bits (TC field) in label header B Physical priority C Protocol bits D IP header only

Computer Networks

Q2 / 50

What is anti-entropy in distributed systems

A Physical entropy B Protocol entropy C Periodically comparing and synchronizing state between nodes D Security entropy

Computer Networks

Q3 / 50

TCP MSS negotiation occurs at

A After first data B Data transfer phase C Connection setup SYN SYN-ACK D Connection teardown

Computer Networks

Q4 / 50

IPv6 loopback address is

A 0::1 B ::1 C ::0 D FF::1

Computer Networks

Q5 / 50

What is proof of authority

A Consensus using trusted validators (private blockchains) B Protocol authority C Security authority D Physical authority

Computer Networks

Q6 / 50

What is CWE

A Common Weakness Enumeration (types of weaknesses) B Security CWE C Protocol CWE D Physical CWE

Computer Networks

Q7 / 50

What is alert fatigue

A Physical fatigue B Analysts ignoring alerts due to excessive volume C Security fatigue D Protocol fatigue

Computer Networks

Q8 / 50

Bit to physical signal conversion is

A Transport layer B Physical layer C Application layer D Network layer

Computer Networks

Q9 / 50

PE-router in MPLS is

A Provider core router B Customer edge router C Provider Edge router connecting customer to MPLS D Peering router

Computer Networks

Q10 / 50

The _____of errors is more difficult than the ______.

A correction; detection B detection; correction C creation; correction D creation; detection

Computer Networks

Q11 / 50

5G PFCP is between

A UPF and DN B SMF and UPF C AMF and UPF D gNB and AMF

Computer Networks

Q12 / 50

YANG module defines

A Security policy B Network hardware C Protocol implementation D Structure of configuration and operational data

Computer Networks

Q13 / 50

What is microcell

A Physical micro B Security micro C Small outdoor cell for urban infill D Protocol micro

Computer Networks

Q14 / 50

NTP port is

A 67 B 69 C 123 D 68

Computer Networks

Q15 / 50

A simple parity-check code can detect __________ errors.

A an even-number of B two C no errors D an odd-number of

Computer Networks

Q16 / 50

C-RAN stands for

A Coded RAN B Carrier RAN C Centralized or Cloud Radio Access Network D Cellular RAN

Computer Networks

Q17 / 50

What is LAA (Licensed Assisted Access)

A Security LAA B Protocol LAA C Physical LAA D LTE using unlicensed 5 GHz as secondary carrier

Computer Networks

Q18 / 50

DF bit in IPv4 header stands for

A Default Field B Dont Fragment C Dynamic Fragment D Data Field

Computer Networks

Q19 / 50

HTTP/2 head-of-line blocking still exists at

A HTTP level B Application level C TCP level D TLS level

Computer Networks

Q20 / 50

DHCP is which layer

A Layer 7 (Application uses UDP) B Layer 3 C Layer 4 D Layer 2

Computer Networks

Q21 / 50

Traceroute identifies path by

A Incrementing TTL values and reading ICMP Time Exceeded responses B ARP requests C Ping sweeps D DNS queries

Computer Networks

Q22 / 50

Bus topology uses a central cable called

A Uplink B Backbone C Trunk D Spine

Computer Networks

Q23 / 50

IP address___________ the physical address.

A is the same as B has no relation with C means D none

Computer Networks

Q24 / 50

What is WAN emulator used for

A Security emulation B Protocol emulation C Physical emulation D Simulating WAN conditions (latency loss jitter) in lab

Computer Networks

Q25 / 50

The physical layer of OSI deals with

A Encryption B IP addressing C Bit transmission over medium D MAC addressing

DBMS

Q26 / 50

What is the purpose of INSTEAD OF triggers on views and what problem do they solve?

A Triggers that prevent all DML on views B Triggers defined on views that fire INSTEAD OF the attempted INSERT/UPDATE/DELETE allowing custom logic to translate the DML operation on the view into appropriate operations on the underlying base tables - enabling updates on otherwise non-updatable views C Triggers that update views automatically when base tables change D Triggers that replace view definitions

DBMS

Q27 / 50

Composite index (A,B,C): which query CAN use this index

A WHERE B=5 (no A) B WHERE C=3 (no A or B) C WHERE B=5 AND C=3 (no A) D WHERE A=1 AND B=5 (leading columns)

DBMS

Q28 / 50

A single further allows the user to be authenticated once, and multiple applications can then verify the user’s identity through an authentication service without requiring reauthentication.

A openid B sign-on system C security assertion markup language (saml) D virtual private database (vpd)

DBMS

Q29 / 50

What is the purpose of GRANT and REVOKE statements in SQL and which classification do they fall under?

A They are DDL statements for schema management B They are DML statements for data manipulation C They are DQL statements for querying data D They are DCL (Data Control Language) statements - GRANT gives specific privileges (SELECT, INSERT, UPDATE, DELETE, EXECUTE) to users/roles on database objects; REVOKE removes those privileges

DBMS

Q30 / 50

ER modeling is classified as which design approach?

A Bottom-up approach B Middle-out approach C Top-down approach D Random approach

DBMS

Q31 / 50

BEGIN TRANSACTION / START TRANSACTION

A Commits current transaction B Rolls back current transaction C Explicitly starts a new transaction D Creates a savepoint

DBMS

Q32 / 50

$table->json('metadata') creates

A TEXT column B VARCHAR(4000) C JSON column for native JSON storage D BLOB

DBMS

Q33 / 50

How should overlapping subtypes be handled in ER-to-relational mapping?

A Collapse all subtypes into one table with all attributes B Always create separate independent tables C Use a separate discriminator table D Various strategies: single table with type indicators and nullable columns, separate subtype tables with FK to supertype, or a type membership table allowing multiple type memberships

DBMS

Q34 / 50

What is a window function in SQL and how does it differ from aggregate functions?

A Window functions require PARTITION BY to work B Window functions only work with ORDER BY C Window functions are identical to aggregate functions D Window functions perform calculations across a set of rows related to the current row without collapsing them into a single result row - unlike aggregate functions which collapse groups into single rows

DBMS

Q35 / 50

Dynamic Management View is a type of ___________

A System Defined Views B User Defined View C Simple View D Complex View

DBMS

Q36 / 50

Snapshot of the data in the database at a given instant of time is called

A database instance B all of the options C database schema D database snapshot

DBMS

Q37 / 50

What is the cycle detection algorithm complexity for a wait-for graph with T transactions and E edges?

A O(T squared) always B O(log T) with sorted transactions C O(T + E) using DFS-based cycle detection (Depth-First Search marks visited nodes and detects back edges indicating cycles in the directed graph) D O(T factorial) for complete detection

DBMS

Q38 / 50

The document data model (MongoDB) is best suited for which scenario?

A Storing hierarchical semi-structured data where document structure can vary B Performing complex multi-table JOIN operations C Enforcing strict referential integrity constraints D Storing highly interconnected data with complex relationships

DBMS

Q39 / 50

A weak entity is represented by

A Single rectangle B Single diamond C Double rectangle D Dashed ellipse

DBMS

Q40 / 50

What is the application-level deadlock and how does it differ from database-level deadlock?

A They are identical types of deadlocks B Application-level deadlocks are faster to resolve C Application deadlocks cannot occur with a DBMS D Application-level deadlock: occurs in application code (e.g. Thread A holds Java lock L1 waiting for Java lock L2; Thread B holds L2 waiting for L1) without involving database locks - the database itself is not deadlocked but the application threads are stuck. Different from DB deadlock where DBMS transactions hold DB locks circularly

DBMS

Q41 / 50

Relational schemas and other metadata about relations are stored in a structure called the ____________

A Metadata B Catalog C Log D Data Dictionary

DBMS

Q42 / 50

A derived attribute is one that

A Must be stored permanently B Can be calculated from other attributes C Has multiple values D Cannot be divided

DBMS

Q43 / 50

When normalizing to BCNF what algorithm is used and what is the termination condition?

A Synthesis algorithm terminating when all FDs are single-attribute B Chase algorithm terminating when no more equalities can be derived C Closure algorithm terminating when no new attributes are added D Decomposition algorithm: find a violating FD X to Y (X not a superkey), decompose into R1(X union Y) and R2(R-Y+X), recursively apply until all relations are in BCNF

DBMS

Q44 / 50

In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.

A Desciptive B Derived C Recursive D Relative

DBMS

Q45 / 50

In which the database can be restored up to the last consistent state after the system failure:

A Backup B Recovery C Both D None

DBMS

Q46 / 50

What does SELECT * FROM employees WHERE department_id IN (SELECT department_id FROM departments WHERE location = NULL) return?

A A syntax error B All employees regardless of department C An empty result set - the condition WHERE location = NULL is always FALSE (must use IS NULL instead of = NULL) D All employees in departments with NULL location

DBMS

Q47 / 50

What is the %TYPE and %ROWTYPE attribute in PL/SQL and why is it preferred?

A Deprecated features replaced by explicit types B Pct TYPE is only for numeric columns C Pct ROWTYPE creates a physical copy of the table D Pct TYPE: declares a variable with the same data type as a specific column automatically adapting if the column type changes. Pct ROWTYPE: declares a record with the same structure as a table row or cursor result with fields matching all column names and types

DBMS

Q48 / 50

A logical description of some portion of database that is required by a user to perform task is called as

A system view B user view C logical view D data view

DBMS

Q49 / 50

Projection operator π extracts

A Rows based on condition B Specific columns (attributes) from a relation C All tuples D Only key attributes

DBMS

Q50 / 50

What is CREATE TEMPORARY TABLE and what is its scope?

A Creates a table that is read-only B Creates a table that is shared across all sessions but deleted after 24 hours C Creates a table in a temporary schema visible to all users D Creates a table that is visible only to the current session and is automatically dropped when the session ends or connection closes

Submit Test?