Practice Test Geeks(CTE) Certified Telecommunications Executive Practice Test
← All CTE Flashcard Decks

Database Administration Flashcards

7 cards from real CTE practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Database Administration flashcards as text

  1. A telecom OSS database experiences slow query performance on a table with 50 million CDR records. Which indexing strategy is MOST appropriate?

    Answer: Add a composite index on frequently filtered columns like call_date and subscriber_id

    Composite indexes on high-cardinality filter columns dramatically reduce scan rows for CDR queries.

  2. In a telecom billing database, which isolation level prevents dirty reads while allowing non-repeatable reads?

    Answer: READ COMMITTED

    READ COMMITTED prevents dirty reads by only reading committed data, but allows non-repeatable reads if another transaction commits between reads.

  3. A DBA at a telecom carrier needs to partition a large subscriber table. Which partitioning method is BEST for range-based monthly billing cycles?

    Answer: Range partitioning on bill_date

    Range partitioning on bill_date aligns naturally with monthly billing cycles, enabling efficient partition pruning for period-based queries.

  4. Which database object is used in telecom OSS/BSS systems to enforce referential integrity between subscriber accounts and their associated service orders?

    Answer: Foreign key constraint

    Foreign key constraints enforce referential integrity by ensuring service order records cannot reference non-existent subscriber accounts.

  5. A telecom DBA must ensure the billing database can recover to any point in the last 24 hours. Which backup strategy supports this requirement?

    Answer: Daily full backups with continuous transaction log backups

    Continuous transaction log backups combined with full backups enable point-in-time recovery to any moment within the retention window.

  6. In telecom database replication, what is the PRIMARY difference between synchronous and asynchronous replication?

    Answer: Synchronous replication waits for replica acknowledgment before committing, while asynchronous does not

    Synchronous replication guarantees no data loss by requiring replica confirmation before commit, at the cost of higher write latency.

  7. A telecom company's network inventory database contains NULL values in the 'equipment_vendor' column. Which SQL function returns a default value when NULL is encountered?

    Answer: ISNULL() or COALESCE()

    COALESCE() returns the first non-NULL argument, while ISNULL() (SQL Server) substitutes a specified replacement for NULL values.