Start learning →

BCA Cyber Security — free MCQ practice

Choose from 199 questions across 2 subjects and 8 topics. Open any question for its answer and worked solution, or keep learning through bite-sized lessons and reviews with Quill.

Start learning BCA Cyber Security with Quill →

BCA Cyber Security subjects

Explore popular topics

Try a BCA Cyber Security question

Worked practice questions

Using the library analogy, what does the DBMS correspond to?

  1. the bookshelf where books physically sit
  2. the librarian who fetches and re-shelves books
  3. the actual library building structure
  4. the catalogue card index system
Show answer and solution

Correct answer: B. the librarian who fetches and re-shelves books

The DBMS is the software that *manages* the data, the way a librarian manages the books on the shelves. The shelves, the building and the catalogue are all pieces of the library the librarian is the one actively running it. CMU's Lecture 01 makes the same point in plain English: the database is the data, the DBMS is the software.

Open this question →

A schema is best described, in the menu analogy, as

  1. tonight's special dish on the chalkboard
  2. the price the customer paid at the counter
  3. the shape every dish must fit (main course = name + price)
  4. the eviction policy the kitchen uses for stale dishes
Show answer and solution

Correct answer: C. the shape every dish must fit (main course = name + price)

The menu lists what is allowed, not what is being served right now. A schema is an agreement on shape (what columns exist and of what type), not the actual rows. Tonight's special is data, not schema the price paid is a row value eviction policy belongs to the buffer pool, not the schema.

Open this question →

Per the kitchen-brigade analogy, the relational model's three pillars are

  1. select, project, join
  2. schemas, tables, indexes
  3. buffer pool, log, lock manager
  4. structure, integrity, manipulation
Show answer and solution

Correct answer: D. structure, integrity, manipulation

CMU's Lecture 01 names exactly these three: structure (what relations exist and their attributes), integrity (rules the data must satisfy), manipulation (how to read and modify). The other options are real DBMS concepts but not the model's defining pillars.

Open this question →

How to practise

  1. Choose a BCA Cyber Security question and try to work out your answer.
  2. Open the question to check the correct answer and read its worked solution.
  3. Continue in the app for bite-sized lessons, explanations and review with Quill. You can start without creating an account.