1
In MS-Word, ______ allows the user to type the text directly inside it.
A
Cable
B
Print
C
Callouts
D
Numbers only
Explanation
Callouts are a type of graphic object in which you can type text directly.
Advance Computer Science
DBMS Software (MS Access)
20
MEDIUM
2
In the context of MS Access, where does the 'New File' task pane appear after selecting 'File -> New'?
A
On the left side of the window
B
On the right side of the window
C
At the bottom of the window
D
In a pop-up dialog box
Explanation
🌟 Quick Verification
- Direct Answer: On the right side of the window.
- Core Concept: The MS Access interface uses a task pane on the right side to facilitate new file creation.
🧠 Solution Blueprint
- Key Fact: The 'New File' task pane is explicitly positioned on the right side of the window to guide the user toward the 'Blank database' option.
3
In MS Access, how can we create relationship between two tables in the GUI?
A
Drag the foreign key of a table into primary key of another table
B
Drag any field from parent table and drop on child table
C
Drag the primary key of a table into foreign key of another table
D
Any of these can be done to create relationship
Explanation
To create a relationship, typically the primary key is drag-and-dropped onto the corresponding foreign key.
4
UPP Computer Operator 21-12-2018 (Batch-01)In MS word, You can display the "Find and Replace" Dialog box by pressing which of the following Function Keys ?
A
F5
B
CTRL + F5
C
CTRL + F4
D
F4
Explanation
Note: The standard shortcut for 'Find and Replace' in MS Word is Ctrl + H. None of the given options are standard. However, if this is an exam question, it may be considered an error in the question paper.
5
To delete backwards in the case of mistakes, the ______ key is used.
A
Shift
B
Backspace
C
Delete
D
Tab
Explanation
The 'Backspace' key is used to delete characters to the left of the cursor (deleting backwards).
Sign up free to save progress
No credit card required
6
UPPCL JE 31-01-2019 (Batch-02)Which is a popular software used primarily for creating documents such as letters, brochures, learning activities, tests, quizzes and students' homework assignments?
A
Paint
B
MS Word
C
MS Access
D
Calculator
Explanation
MS Word is used for document creation.
7
If you enter the formula "=SUM(A1:A4)" in cell A5, it would:
| A | B | |
|---|---|---|
| 1 | 50 | |
| 2 | 100 | |
| 3 | 150 | |
| 4 | 200 | |
| 5 | Total |
A
Display 500 in cell A5
B
Display 450 in cell A5
C
Display 300 in cell A5
D
Display 400 in cell A5
Explanation
SUM(50, 100, 150, 200) = 500. Therefore, 500 will be displayed in cell A5.
8
Assertion (A): The 'Edit Relationships' dialog box appears immediately after selecting 'Tools → Relationships'.
Reason (R): The 'Edit Relationships' dialog box is triggered only when a field is dragged from one table to the corresponding field in another table.
A
Both A and R are true and R is the correct explanation of A
B
Both A and R are true but R is not the correct explanation of A
C
A is true but R is false
D
A is false but R is true
Explanation
🌟 Quick Verification
- Direct Answer: The correct answer is A is false but R is true.
- Core Concept: The 'Edit Relationships' dialog is not the first screen; it is a secondary dialog triggered by the action of linking fields.
🧠 Solution Blueprint
- Step-by-Step Reasoning:
- Assertion Analysis: Selecting 'Tools → Relationships' opens the 'Show Table' dialog box, not the 'Edit Relationships' box. Thus, the Assertion is false.
- Reason Analysis: The 'Edit Relationships' box is indeed triggered by dragging a field from one table to another. Thus, the Reason is true.
9
UPPCL (Office Assistant III) 23-09-2018State whether the following statements pertaining to PowerPoint 2013 are true or false.
i) Translate option which translates selected text into different languages is NOT available in PowerPoint 2013.
ii) Research option in 'proofing' group menu gives alternative word to selected word.
iii) The Comments pane has three default buttons: Insert comment, Previous and Next
A
i) True, ii) True, iii) True
B
i) False, ii) True, iii) True
C
i) True, ii) True, iii) False
D
i) True, ii) False, iii) True
Explanation
Statement (i) is False because the translate option is available. The other statements (ii) and (iii) are True.
10
Arrange the following steps in the correct chronological order to save a table in MS Access Design View: 1. Click 'Yes' to the save prompt. 2. Enter the table name in the 'Save As' dialog box. 3. Attempt to close the 'Table1: Table' page. 4. Respond to the Primary Key prompt.
A
3 -> 1 -> 2 -> 4
B
1 -> 3 -> 2 -> 4
C
3 -> 2 -> 1 -> 4
D
4 -> 3 -> 1 -> 2
Explanation
🌟 Quick Verification
- Direct Answer: The correct answer is 3 -> 1 -> 2 -> 4.
- Core Concept: The saving process in MS Access Design View follows a specific sequence of prompts to ensure structural integrity and unique identification.
🧠 Solution Blueprint
- Step-by-Step Solution:
- Step 1: The user initiates the save by attempting to close the page (Step 3).
- Step 2: The system prompts to save changes, and the user clicks Yes (Step 1).
- Step 3: The 'Save As' dialog box appears, allowing the user to enter the table name (Step 2).
- Step 4: Finally, the system prompts to define a Primary Key (Step 4).
Full Mock Tests
Take Full-Length Mock Tests
Test your complete preparation with timed mock tests. Get detailed analytics and compare scores with other aspirants.
Explore Test Series
11
UPPCL ARO 13-09-2018The column of a Microsoft Access table is known as a/an:
A
Inverted row
B
vertical cell
C
record
D
field
Explanation
In a database (MS Access), a column of a table is called a 'field'.
12
Which one of the following slide views can be used to view all slide in a single screen in MS PowerPoint?
A
Slide sorter view
B
Slide master view
C
Normal view
D
Outline view
Explanation
Slide Sorter view is used to view all slides as thumbnails on a single screen.
13
UPPCL TG-2 26.06.2016Which of the following can be created in Excel?
A
Line graphs and pie charts
B
Only line graphs
C
Bar charts, line graphs and pie charts
D
Bar charts and line graphs
Explanation
Excel can create various types of charts including bar charts, line graphs, and pie charts.
14
UPPCL-JE 31-01-2019 (Batch-01)In MS Word, which of the following options under "Change Case" is used to convert the selected text from upper case to lower case and vice versa?
A
Lower case
B
Sentence case
C
Toggle case
D
Upper case
Explanation
Toggle case reverses the case of the text (e.g., 'a' to 'A' and 'A' to 'a').
15
Assertion (A): In MS Access, a user can choose not to define a Primary Key during the table saving process. Reason (R): The Primary Key is mandatory for every table in MS Access to function correctly.
A
Both A and R are true and R is the correct explanation of A
B
Both A and R are true but R is not the correct explanation of A
C
A is true but R is false
D
A is false but R is true
Explanation
🌟 Quick Verification
- Direct Answer: The correct answer is A is true but R is false.
- Core Concept: While a Primary Key is a best practice for unique identification, it is not strictly mandatory for saving a table in MS Access.
🧠 Solution Blueprint
- Reasoning:
- Assertion Analysis: It is true that the system prompts for a Primary Key, and the user can select 'No', resulting in the table being saved without one.
- Reason Analysis: The reason is false because MS Access does not enforce a Primary Key as a mandatory requirement for saving; it is optional based on user requirements.
16
UPPCL (Office Assistant III) 23-09-2018Which shortcut key will undo an action?
A
Ctrl + L
B
Ctrl + Z
C
Ctrl + Y
D
Ctrl + J
Explanation
Ctrl + Z is used to 'Undo'.
17
UPPCL (TG-II) 24-01-2019 (Morning)Which of the following statement is wrong?
i) In Microsoft PowerPoint 2016, the slide sorter option is placed under the 'Review Tab'
ii) In Microsoft PowerPoint 2016, to add music to your presentation, click the Insert tab → Media group → Audio
A
Both (i) and (ii)
B
Neither (i) and nor (ii)
C
Only (i)
D
Only (ii)
Explanation
Statement (i) is wrong because Slide Sorter is in the 'View' tab, not the 'Review' tab. Statement (ii) is correct.
18
Consider the following statements regarding the methods to create a table in MS Access: 1. The 'Create table in Design view' option requires the user to define the structure, including fields and data types, before entering data. 2. The 'Create table by using wizard' option provides sample tables categorized into business and personal types. 3. The 'Create table by entering data' option requires the user to specify data types for all fields before entering data. Which of the above statements are correct?
A
1 and 3 only
B
1 and 2 only
C
2 and 3 only
D
1, 2, and 3
Explanation
🌟 Quick Verification
- Direct Answer: The correct answer is 1 and 2 only.
- Core Concept: MS Access provides three distinct methods for table creation, each with specific requirements regarding structure and data entry flow.
🧠 Concept Blueprint
- The Core Entity: Table Creation Methods:
- Design View: Focuses on structural definition (fields/data types) first.
- Wizard: Uses pre-defined templates (Business/Personal).
- Entering Data: Allows simultaneous design and entry without pre-defining data types.
- Why It is Correct:
- Statement 1 is correct as Design View is explicitly for structural planning.
- Statement 2 is correct as the Wizard uses those specific categories.
- Statement 3 is incorrect because 'Create table by entering data' specifically allows users to bypass pre-defining data types.
📊 Fact Spotlight
| Method | Key Characteristic | Data Type Requirement |
|---|---|---|
| Design View | Structural Planning | Required First |
| Wizard | Templates | Pre-defined |
| Entering Data | Simultaneous | Not Required |
💡 Exam Strategy & Trivia
Tip
Common Pitfall: Students often confuse the 'Entering Data' method with the 'Design View' method. Remember: Entering Data = No Data Types needed initially.
Memorable Trivia: MS Access is a relational database management system that simplifies table creation through these three distinct UI-driven workflows.
19
UPPCL Office Assistant III 17-10-2018 (Morning)In MS PowerPoint 2016, which of the following is not a valid slide layout.
A
Title and Content
B
Picture with caption
C
Blank with Title
D
Comparison
Explanation
There is no standard layout named 'Blank with Title' in MS PowerPoint. Title and Content, Picture with caption, and Comparison are valid layouts.
20
The keyboard shortcut to "cut" something is:
A
Shift + X
B
Shift + Alt
C
Ctrl + C
D
Ctrl + X
Explanation
The 'Ctrl + X' shortcut is used to cut any object or text in MS Word.
Free Forever
Track Your Progress
Sign up for free to save your progress, access unlimited questions, and get personalized recommendations.
You're Doing Great! 🎯
Sign up free to unlock unlimited questions, save your progress, and access all DBMS Software (MS Access) questions.
Unlimited PYQs Progress Tracking Mock Tests
✨ Free forever • No credit card • 2 sec signup with Google
All Chapters
Advance Computer Science
12345Current678910111213141516171819202122
Fundamentals of Computer
513+ questions
Word Processing (MS Word)
457+ questions
Spreadsheet Software (MS Excel)
147+ questions
Presentation Software (MS PowerPoint)
162+ questions
DBMS Software (MS Access)
224+ questions
C and C++ Programming
128+ questions
Java
89+ questions
.NET and C#
61+ questions
Artificial Intelligence and Machine Learning
175+ questions
Python Programming
92+ questions
Blockchain Technology
83+ questions
Principles of Programming and OOPs
630+ questions
Data Structures and Algorithms
288+ questions
Computer Organization and Operating System
302+ questions
Communication and Network Concepts
627+ questions
Network Security
97+ questions
Database Management System
223+ questions
System Analysis and Design
226+ questions
Internet of Things and its Application
318+ questions
Major Developments in IT
103+ questions
Pedagogy of Computer Science
119+ questions
Digital Logic Systems
268+ questions