Computer Knowledge
Computer Software Operations
1,772 Questions
This hub provides extensive practice on computer software operations and keyboard shortcuts. It covers document formatting, spreadsheet navigation, and common application commands. These questions are essential for candidates preparing for banking, railways, and staff selection computer proficiency tests.
Keyboard shortcutsSpreadsheet formattingDocument editingWeb page navigationMail merge operations
Computer Software Operations Questions
-
MYSQL
-
SQL Server
-
DB2
-
Oracle
-
All of the above/ Any database suggested by client
B,D
Correct answer
Explanation
Sybase Exodus typically refers to migration projects from Sybase to SQL Server (Microsoft's successor to Sybase technology) or Oracle. MySQL and DB2 are less common targets for Sybase migrations in enterprise contexts.
-
datetime2
-
date
-
datetime
-
timestamp
-
time
C
Correct answer
Explanation
When migrating Sybase to SQL Server, the Sybase datetime datatype maps directly to SQL Server's datetime datatype because both share the exact same storage layout, range, and fractional precision.
-
SQL Developer
-
SwissSQL
-
SSMA
-
SQLWays
-
SQLLdr
-
RazorSQL
-
people or groups interested in the progress and resolution of a particular work object, but who do not necessarily perform the work in the application
-
clusters of associated work objects, usually relating to a single customer.
-
people or groups who are authorized to perform on restricted types of work objects
-
users set up in the system that are responsible for the timely resolution of outstanding work objects.
A
Correct answer
Explanation
Work parties are stakeholders interested in a work object's progress and outcome - they receive notifications and can view status, but don't necessarily perform the work themselves. Option B describes work object clusters, C describes performers with restricted access, and D describes users responsible for resolution - all different concepts.
-
people or groups interested in the progress and resolution of a particular work object, but who do not necessarily perform the work in the application
-
clusters of associated work objects, usually relating to a single customer.
-
people or groups who are authorized to perform on restricted types of work objects
-
users set up in the system that are responsible for the timely resolution of outstanding work objects.
A
Correct answer
Explanation
Work parties represent people, departments, or companies associated with a case. They have a stake in its progress and resolution but do not necessarily perform the processing tasks within the application itself. The other options confuse them with workbaskets, operator records, or case relationships.
-
%FOUND
-
%NOTFOUND
-
%ROWCOUNT
-
%ISOPEN
D
Correct answer
Explanation
%ISOPEN is a cursor attribute that returns TRUE if the cursor is currently open and FALSE if it is closed. This is useful for checking cursor state before attempting operations that require an open cursor. The other attributes track row existence (%FOUND/%NOTFOUND) or row count (%ROWCOUNT).
A
Correct answer
Explanation
A reference characteristic in SAP BW does not have its own SID or master data tables. Instead, it uses the SID table and master data tables of the characteristic it refers to. This design avoids data redundancy and maintains referential integrity.
-
An attribute of an info object cannot be made navigational if the attribute-only flag on the attribute info object has been checked.
-
Navigational attributes can be used to create aggregates.
-
It is possible to make a display attribute to navigational in an info cube data without deleting all the data from the info cube.
-
Once an attribute is made navigational in an info cube, it is possible to change it back to a display attribute if the data has been deleted from the info cube.
D
Correct answer
Explanation
Navigational attributes cannot be made navigational if the attribute-only flag is set, they can be used for aggregates, and cannot be converted back to display attributes without deleting data. Option D correctly states that once data is deleted, the attribute can be reverted to display status.
-
An info cube needs to contain all info objects of the compounded info object if it has been included in the info cube.
-
An info object cannot be included as a compounding object if it is defined as an attribute only.
-
An info object can be included as an attribute and a compounding object simultaneously.
-
The total length of a compounded info object cannot exceed 60.
A,B,D
Correct answer
Explanation
Compounded info objects require all component objects to be present in the cube. An attribute-only object cannot be used for compounding. An object cannot simultaneously be an attribute and compounding object. The total length is capped at 60 characters for database efficiency.
-
Each characteristic of info cube should be assigned to at least one dimension.
-
One characteristic can be assigned to more than one dimensions.
-
One dimension can have more than one characteristic.
-
More than one characteristic can be assigned to one line item dimension.
A,C
Correct answer
Explanation
Every characteristic must be assigned to at least one dimension for proper organization. A characteristic can only belong to one dimension at a time. However, a single dimension can contain multiple characteristics. Line item dimensions are exceptions to normal dimension rules.
-
It is possible to create ODSs without any data fields.
-
An ODS can have a maximum of 16 key fields.
-
Characteristics and key figures can be added as key fields in an ODS.
-
After creating and activating, an export data source is created automatically.
A,C
Correct answer
Explanation
An ODS can be created with zero data fields (just key fields). Both characteristics and key figures are valid key field types. The 16-key-field limit is incorrect (ODS has no such fixed limit). Export data sources must be created manually, not automatically.
-
ctrl+alt+del+enter
-
alt+l
-
windows logo key+l
-
shift+ctrl
C
Correct answer
Explanation
The Windows logo key + L is the universal keyboard shortcut to lock the Windows screen. This combination works across all modern Windows versions and immediately locks the workstation, requiring password or other authentication to regain access. The other options listed are not valid screen lock shortcuts.
-
File System+ Operating System
-
RDBMS+ Operating System
-
Operation System + File System + RDBMS
-
None of the above
C
Correct answer
Explanation
Documentum Content Server requires a three-layer foundation: the Operating System (Windows/Linux/Unix), a File System for content storage, and a Relational Database Management System (RDBMS) for metadata and object management. All three components are essential - Content Server cannot run without any of them.
-
Docbase, File Storage
-
RDBMS, File Storage
-
File Storage, Repository
-
Docbase, Repository
D
Correct answer
Explanation
In Documentum terminology, a Docbase (better known as a Repository) is where all Documentum objects are stored. The Repository uses both the RDBMS (for metadata/object definitions) and file storage (for actual content files), but the term 'Docbase' or 'Repository' refers to the complete logical storage unit.
-
Properties file
-
Database properties
-
Docbase Config
-
none of the above match the blank
C
Correct answer
Explanation
In Documentum architecture, the Docbase Config object stores configuration and operational parameters for servers accessing the repository. This includes connection settings, server preferences, and runtime information.