About this quiz
50 questions covering every section of the note: Slides, Views, DBMS, Keys and SQL.
This Lok Sewa practice set has 50 multiple-choice questions (Subject: Computer Knowledge · For: Kharidar, Nayab Subba, Section Officer · Level: Easy). Take the quiz above first; after that, use the study list below to revise every question with its correct answer and a short explanation.
Study list: all 50 questions with answers and explanations
What is the default extension of a PowerPoint 2016 presentation?
- A) .ppt
- B) .pptx ✔
- C) .pps
- D) .pst
Why: PowerPoint 2007 and later save presentations as .pptx by default. Older versions used .ppt.
Which view shows all slides as small thumbnails so they can be rearranged easily?
- A) Normal view
- B) Slide Sorter view ✔
- C) Notes Page view
- D) Reading view
Why: Slide Sorter view shows all slides as thumbnails, so they can be rearranged by dragging.
The effect that appears when moving from one slide to the next is called:
- A) Animation
- B) Transition ✔
- C) Theme
- D) Layout
Why: A transition is the effect when moving from one slide to the next.
Which key starts a slide show from the first slide?
- A) F1
- B) F5 ✔
- C) F7
- D) F12
Why: F5 starts the show from the beginning; Shift + F5 starts from the current slide.
Which shortcut inserts a new slide in PowerPoint?
- A) Ctrl + N
- B) Ctrl + M ✔
- C) Ctrl + S
- D) Ctrl + D
Why: Ctrl + M adds a new slide; Ctrl + N creates a new presentation.
Which feature controls the design of all slides at once, such as a logo on every slide?
- A) Slide Sorter
- B) Slide Master ✔
- C) Speaker notes
- D) Transition
Why: The Slide Master controls the design of all slides, such as fonts, colours and a logo on every slide.
Which of these is NOT a type of animation in PowerPoint?
- A) Entrance
- B) Emphasis
- C) Exit
- D) Transition ✔
Why: Animation types are Entrance, Emphasis, Exit and Motion Paths. Transition is a separate feature.
Raw facts that have not been processed are called:
- A) Information
- B) Data ✔
- C) Knowledge
- D) Report
Why: Raw facts that have not been processed are data. Processed data becomes information.
Which of these is NOT a database management system?
- A) MS Access
- B) Oracle
- C) MySQL
- D) MS Paint ✔
Why: MS Paint is a drawing program, not a database management system like Access, Oracle or MySQL.
In a database table, one row is called a:
- A) Field
- B) Record ✔
- C) Key
- D) Query
Why: One row in a database table is a record.
In a database table, one column is called a:
- A) Record
- B) Tuple
- C) Field ✔
- D) Report
Why: One column in a database table is a field.
A field whose value is unique for every record and cannot be empty is the:
- A) Foreign key
- B) Primary key ✔
- C) Secondary key
- D) Composite field
Why: The primary key has a unique value for every record and cannot be empty.
A field that links one table to the primary key of another table is a:
- A) Primary key
- B) Foreign key ✔
- C) Unique field
- D) Index
Why: A foreign key links one table to the primary key of another table.
Which MS Access object is used to get specific information from tables, such as students with marks above 80?
- A) Form
- B) Query ✔
- C) Report
- D) Macro
Why: A query gets specific information from tables, such as students with marks above 80.
Which MS Access object is mainly used to print data in a formatted way?
- A) Table
- B) Form
- C) Report ✔
- D) Module
Why: A report prints data in a formatted way.
What is the file extension of an MS Access 2016 database?
- A) .mdb
- B) .accdb ✔
- C) .dbf
- D) .acs
Why: Access 2007 and later databases use the .accdb extension.
Which Access data type fills in numbers automatically for each new record?
- A) Number
- B) AutoNumber ✔
- C) Currency
- D) Yes/No
Why: AutoNumber gives each new record a unique number and is often used as the primary key.
Which SQL command is used to read data from a table?
- A) INSERT
- B) UPDATE
- C) SELECT ✔
- D) DROP
Why: SELECT reads data from a table.
Which SQL command adds new records to a table?
- A) INSERT ✔
- B) ALTER
- C) SELECT
- D) CREATE
Why: INSERT adds new records to a table.
CREATE, ALTER and DROP belong to which group of SQL commands?
- A) DML
- B) DDL ✔
- C) DCL
- D) TCL
Why: They define the structure of tables, so they are Data Definition Language.
The default file extension of a PowerPoint presentation is:
- A) .docx
- B) .xlsx
- C) .accdb
- D) .pptx ✔
Why: The default PowerPoint extension is .pptx.
A single page in a PowerPoint presentation is a:
- A) Slide ✔
- B) Sheet
- C) Page frame
- D) Cell
Why: A single page in a presentation is a slide.
To start a slide show from the beginning, press:
- A) F7
- B) F5 ✔
- C) F12
- D) F1
Why: F5 starts the slide show from the first slide.
Shift + F5 in PowerPoint starts the show from:
- A) The first slide
- B) The last slide
- C) The current slide ✔
- D) The outline
Why: Shift + F5 starts the slide show from the current slide.
Effects applied when moving from one slide to the next are:
- A) Animations
- B) Themes
- C) Layouts
- D) Transitions ✔
Why: Effects between slides are transitions.
Effects applied to text or objects on a slide are:
- A) Animations ✔
- B) Transitions
- C) Themes
- D) Templates
Why: Effects on text or objects within a slide are animations.
The view that shows slide thumbnails for rearranging is:
- A) Normal view only
- B) Slide Sorter view ✔
- C) Reading view
- D) Notes view
Why: Slide Sorter view shows thumbnails for rearranging slides.
A ready-made design with fonts and colours is a:
- A) Macro
- B) Query
- C) Theme ✔
- D) Form
Why: A theme is a ready-made design with matching fonts, colours and effects.
Speaker notes are written in the:
- A) Title bar
- B) Status bar
- C) Ribbon
- D) Notes pane ✔
Why: Speaker notes are written in the Notes pane below the slide.
Which master controls the look of all slides?
- A) Slide Master ✔
- B) Handout Master
- C) Notes Master
- D) Title Master only
Why: The Slide Master controls the look of all slides.
The default file extension of an Access database (2007+) is:
- A) .mdb only
- B) .accdb ✔
- C) .xlsx
- D) .pptx
Why: Access 2007 and later use the .accdb extension.
In a database, a table is made of rows called:
- A) Fields
- B) Queries
- C) Records ✔
- D) Forms
Why: Rows in a table are records.
In a database table, a column is called a:
- A) Record
- B) Report
- C) Macro
- D) Field ✔
Why: Columns in a table are fields.
A field that uniquely identifies each record is the:
- A) Primary key ✔
- B) Foreign key
- C) Index only
- D) Query
Why: The primary key uniquely identifies each record.
A field that links to the primary key of another table is a:
- A) Primary key
- B) Foreign key ✔
- C) Candidate key only
- D) Report
Why: A foreign key links to the primary key of another table.
An Access object used to ask questions of data is a:
- A) Form
- B) Report
- C) Query ✔
- D) Macro
Why: A query asks questions of the data.
An Access object used for entering and viewing data on screen is a:
- A) Query
- B) Report
- C) Table
- D) Form ✔
Why: A form is used to enter and view data on screen.
An Access object used to print formatted summaries is a:
- A) Report ✔
- B) Form
- C) Query
- D) Macro
Why: A report prints formatted summaries.
An Access object that automates tasks is a:
- A) Table
- B) Macro ✔
- C) Report
- D) Form
Why: A macro automates tasks.
The Access data type for whole numbers and amounts used in calculations is:
- A) Short Text
- B) Yes/No
- C) Number ✔
- D) Attachment
Why: The Number data type stores numbers used in calculations.
The Access data type that stores true/false values is:
- A) Number
- B) Memo
- C) Date/Time
- D) Yes/No ✔
Why: The Yes/No data type stores true/false values.
The Access data type that numbers records automatically is:
- A) AutoNumber ✔
- B) Number
- C) Currency
- D) Hyperlink
Why: AutoNumber numbers records automatically.
The view used to change a table's fields and data types is:
- A) Datasheet View
- B) Design View ✔
- C) Print Preview
- D) Layout View only
Why: Design View is used to change a table's fields and data types.
DBMS stands for:
- A) Data Backup Management Software
- B) Digital Base Memory System
- C) Database Management System ✔
- D) Data Bus Management System
Why: DBMS stands for Database Management System.
A relationship where one record links to many records is:
- A) One-to-one
- B) Many-to-many only
- C) No relationship
- D) One-to-many ✔
Why: A one-to-many relationship links one record to many records, such as one customer with many orders.
In PowerPoint, Ctrl + M inserts a:
- A) New slide ✔
- B) New table
- C) New chart
- D) Macro
Why: Ctrl + M inserts a new slide in PowerPoint.
To end a slide show, press:
- A) F5
- B) Esc ✔
- C) Enter
- D) Tab
Why: Press Esc to end a slide show.
Handouts in PowerPoint are used to:
- A) Record narration
- B) Add transitions
- C) Print several slides per page for the audience ✔
- D) Create macros
Why: Handouts print several slides per page for the audience.
Microsoft Access is a:
- A) Spreadsheet program
- B) Presentation program
- C) Web browser
- D) Database management program ✔
Why: Microsoft Access is a database management program.
Sorting records from A to Z is called:
- A) Ascending order ✔
- B) Descending order
- C) Filtering
- D) Grouping
Why: Sorting from A to Z is ascending order.