Public Service Commission Preparation & Blogging

Post Top Ad

Ms-Office Practical Guides

In this section, we present the learning materials for your computer practical exam especially in Ms-Office. Most important, frequently asked Questions, Practical Guides, Practice Sets, and Tips & Tricks from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the practical exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's started to learn.


Ms-Word

Practical Guides

Ms-Word

Asked Papers

Ms-Word

Practice Sets

Ms-Word

Tips & Tricks


Ms-Excel

Practical Guides

Ms-Excel

Asked Papers

Ms-Excel

Practice Sets

Ms-Excel

Tips & Tricks


Ms-Powerpoint

Practical Guides

Ms-Powerpoint

Asked Papers

Ms-Powerpoint

Practice Sets

Ms-Powerpoint

Tips & Tricks


Ms-Access

Practical Guides

Ms-Access

Asked Papers

Ms-Access

Practice Sets

Ms-Access

Tips & Tricks


Multiple Choice Questions Sets

Here we presents the selected, Most important, frequently asked Multiple Choice Questions from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the written exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's Get started to learn.


Ms-Word

MCQ Sets

Ms-Excel

MCQ Sets

Ms-Powerpoint

MCQ Sets

Ms-Access

MCQ Sets


HTML

MCQ Sets

Operating System

MCQ Sets



Interviews Preparations

The most important part of preparing for an Interview is practice. Preparation is the key to a successfull interview so take a look at Preparations Questions and Tips & Tricks how to answer them. Let's Get started to learn.


Interview Questions

Asked Before

Tips & Tricks

Based on Experience



Question Papers

I knew its hard to find the right question papers in internet from one website. But it's good to say here i collects questions papers sets that are previously asked from psc exams. These questions will be helpful for the final preparation of your exam. Let's start to expand your knowledge.


Section Officer

Asked Before

Computer Officer

Asked Papers

Nayab Subba

Asked Papers

Computer Operator

Asked Papers


Kharidar

Asked Papers

Asst. C.O.

Asked Papers



Modal Practice Paper Sets

Here we have writes some sample practical paper sets for your exam. Try to solve these questions within time at home frequently. If you solve this within time you will cover almost every quetions in exam hall. These questions will be helpful for the final preparation of your exam. Let's start to practice.


Section Officer

Modal Sets

Computer Officer

Asked Papers

Nayab Subba

Modal Sets

Computer Operator

Modal Sets


Kharidar

Modal Sets

Asst. C.O.

Modal Sets



Tutorials & Courses

In this section, we presents the learning materials for your Public Service Commission exam, bank exam, Nea exam, institutional exan etc. This section contains chapters with solutions, cources, or any thing that helps for your written exam, practical exam & interview based on curriculam. Let's start to prepare for your exam.


Section Officer

Tutorials

Computer Officer

Tutorials

Nayab Subba

Tutorials

Computer Operator

Tutorials


Kharidar

Tutorials

Asst. C.O.

Tutorials



Blogging & Wordpress Tutorials, Courses

In this place, you will find blogging tips, new strategies, and will teach you how to be a bogger with just the most basic computer skills. Everything you need to know to start blogging-we'll show you how step by step for blogging and wordpress. Let's Get started to learn.


Wordpress

Tips

Blogging

Tips

Wordpress

New Strategies

Blogging

New Strategies


Blogging

Make Money

Wordpress

Make money

Blogging

Guide

Wordpress

Guide


Blogging

For Beginners

Wordpress

For Beginners

Blogging

Tutorials

Wordpress

Tutorials


Wordpress

How to start?

Blogging

How to start?

Blogging

Intermediate

Wordpress

Intermediate


Post Top Ad


Ms-Access (Database Management System)
Collections of questions from Computer Operator Papers (PSC)
Q.1 What is the purpose of Query?
a. Input data                  b. Output data               c. Filter & sort               d. All
Q.2 What happen when selecting record presses delete key?
a. Row will be deleted                                        b. Content will be deleted         
c. Row moves one step up                                d. None of the above
Q.3 Which is the function of relationship?
a. Relate multiple tables                                     b. Relate multiple form
c. Relate table and form                                     d. Relate queries and forms
Q.4 OLE means
a. Open Linking and Embedding                        b. Object linking and embedding
c. Objective Linking and Embedding                  d. Open Link and End
Q.5 In which object SQL is used
a. Query                        b. Form                       c. Report                      d. Macro
Q.6 Which data type doesn't exist in access?
a. Number                     b. Picture                      c. Memo                       d. Text
Q.7 What is there in Record?
a. Collection of fields.                                       b. Collection of number
c. Collection of Rows                                        d. All of the above
Q.8 What operation is not permitted by query?
a. Delete                       b. Entry                                    c. Modify          d. Create table
Q.9 Which is not related with Database?
a. Table                        b. Query                       c. Form                         d. Macro
Q.10 Which is not numeric data type?
a. Byte                          b. Bit                            c. Single                       d. Double
Q.11 Which objects uses table & report?
a. Switch board             b. Query                       c. Report                      d. Form
Q.12 How many relation can be formed with two tables?
a. One                          b. Two                          c. Three                        d. Four
Q.13 Which one is unique field?
a. Primary key               b. Foreign key               c. Index key                  d. None
Q.14 Which is not Data field Type?
a. OLE                          b. Memo                       c. Lookup Wizard          d. E-Mail
Q.15 Which fields appears when report is created with report wizard
a. All fields                   b. Selected fields          c. Related fields                        d. All
Q.16 Full form of E-R diagram
a. Engineer Relational Diagram                          b. Entity Relation Diagram
c. External Relational Diagram                           d. Internal Relation Diagram
Q.17 In Access which wild card is not mostly used?
a. !                               b. #                              c. ?                               d. *
Q.18 Which application program is called database program?
a. Excel                                    b. Word                       c. PowerPoint               d. Access
Q.19 Which one is not relationship type?
a. Many to many            b. Many to one                          c. One to many       d. One to one
Q.20 Which one is not database object?
a. Form                         b. Table                        c. Report                  d. Datasheet
Q.21 Table is
a. Row & Column          b. Field/Column             c. Row & Chart              d. None
Q.22 Which one is used for database management?
a. Jet Engine                 b. Boot & Logic                        c. Procedure                 d. Format
Q.23 Restrict to database file use to another user we protect in
a. Exclusive mode         b. Inclusive mode          c. Extended mode         d. All
Q.24 In Access to insert picture the data type is used
a. OLE                          b. Hyperlink                  c. Lookup wizard           d. Picture
Q.25 In Access table, which components are exist?
a. Field and Column     b. Row and Record       c. Column and Row   d. Row and Cell
Q.26 Which is database program?
a. Oracle                       b. Word                          c. Excel                                    d. None
Q.27 To print table structure is called
a. Documenter              b. Generator                  c. Analyzer                    d. All
Q.28 Which objects extracts the subset of data?
a. Form                         b. Field                         c. Query                        d. Report
Q.29 Which is included in table?
a. Record                      b. Field                      c. Index                               d. All
Q.30 Form and Report is called
a. Object                       b. Field                         c. Record                      d. Column
Q.31 Which one is unique key?
a. Index key      b. Foreign key        c. Assign a common field     d. Primary key
Q.32 To insert a form within form is called
a. Sub Form                  b. Query                       c. Report                      d. Form
Q.33 Which relationship cannot be set between two tables?
a. One to one                b. One to many             c. Many to one       d. Many to many
Q.34 The key used to fast data accessing from database.
a. Index key                  b. Primary key               c. Foreign key               d. All
Q.35 The key used to organized database is sorting manner?
a. Foreign key               b. Index key                  c. Key field                   d. None
Q.36 Form can be build from
a. Table                        b. Table & Query           c. Sub form                  d. None
Q.37 Form is used for
a. To enter data       b. To display message     c. To place different controls  d. All
Q.38 Relationship established with
a. Two identical fields    b. One numeric and other text field
c. Foreign key               d. All of the above
Q.39 Database Management system function
a. Add              b. Delete           c. Append         d. All
Q.40 Filter
a. Extract the subset of data                  b. Extract the numeric data only
c. Extract the character data only           d. None of the above
Q.41 Record is called in database terminology
a. Entity            b. Attribute        c. Relation        d. All of the above
Q.42 Properties of database
a. Consistency              b. Independence           c. Security        d. All of the above
Q.43 Independence means
a. Exclusive      b. Inclusive       c. Sharing         d. None of the above
Q.44 To modify the data type by
a. Table design view      b. Datasheet view          c. Open mode   d. All
Q.45 The extension of index file is
a. ndx               b. idx                c. ind                d. All of the above
Q.46 Tree structure displays the
a. File only        b. Directory only           c. Directory and file name          d. None
Q.47 Which one is the currently popular database?
a. Object oriented          b. Flat file database
c. Object oriented relational database     d. None of the above
Q.48 Query structure
a. Field             b. Records        c. Snapshot      d. Dynaset
Q.49 In Ms Access, if you type sort(abs(-81)), then it display
a. 9                   b. -9                 c. 0                   d. Wrong command
Q.50 Complete horizontal row of the data is called
a. Record          b. Fields           c. Column         d. None of the above
Q.51 Ms Access can import file from
a. Dbase database file  b. Excel workbook    c. Notepad delimited text file     d. All
Q.52 Which is not the database application?
a. Powerpoint    b. Excel                        c. Ms Access    d. All of the above
Q.53 Form can be making from
a. Table & Queries         b. Table only     c. Table & Report          d. Report & Queries
Q.54 DBMS stands for
a. Database Managerial System             b. Database Management System
c. Database Basic managerial System    d. Database Basic Management System
Q.55 OLE stands for
a. Object link & Engaging          b. Object Linking & Embedding
c. Object like & energy              d. Online linking & embedding
Q.56 Table can be created by ____ in ms access
a. 2 ways          b. 3 ways          c. 4 ways          d. 5 ways
Q.57 Which field type is not used in database?
a. Currency       b. Text              c. Number         d. Single
Q.58 Primary key
a. Must have an unique number              b. Not null
c. Used to relate with foreign key           d. All of the above
Q.59 File extension of MS Access?
a. .mdb             b. .mda             c. .mbd             d. .mdp
Q.60 RDBMS uses data source from
a. Flat file         b. Table            c. OLAP            d. None
Q.61 DDL supports for
a. Drop             b. Insert            c. Update          d. Delete
Q.62 Which can you import in MS access?
a. Workbook     b. Slide             c. Word document         d. All of above
Q.63 Which is not database object?
a. Table            b. Form                        c. Macro                       d. Datasheet
Q.64 Which cannot create report from?
a. Table            b. Query           c. Table & Query           d. Filter
Q.65 Which is used for connecting database with front-end object?
a. ADO             b. Record set    c. Query                        d. All of above
Q.66 Which is not database?
a. LISP             b. FoxPro         c. Dbase           d. Oracle
Q.67 Which is an odd?
a. SQL              b. QBE             c. MS access    d. QUEL
Q.68 Which is relationship type?
a. 1:1                b. 1:m               c. m:n               d. All
Q.69 Foreign key is used to
a. Establish relationship     b. Indexing table     c. Unique record     d. All
Q.70 New record is added using
a. append record into from browse menu      b. append record from browse menu
c. add record from edit menu                       d. all of the above
Q.71 In MS access _____ is used to build and modify database objects and also to create new queries.
a. Layout preview          b. Datasheet view          c. Design view  d. Print preview
Q.72 What are the main building blocks of a database?
a. Tables           b. Lists             c. Queries         d. All of the above
Q.73 Which of the following is not a relational database?
a. Reflex           b. FoxPro         c. Dbase IV       d. 4th Dimension
Q.74 A phone number in a database is an example of a
a. File               b. Field             c. Record          d. Sort
Q.75 A _____ helps you perform routine tasks by automating them.
a. Report          b. Query           c. Macro           d. Form
Q.76 Which is the smallest piece of database?
a. Bit                b. Byte             c. Record          d. Table
Q.77 Which is not action query?
a. Append         b. Update         c. Make table    d. Select
Q.78 The shortcut key for add new record?
a. Ctrl + +         b. Alt + +          c. Shift + +       d. None
Q.79 Which is the action query?
a. Append         b. Update         c. Cross tab      d. Parameter
Q.80 The primary key is
a. Redundant key          b. Unique key    c. Index key      d. None
Q.81 The auto-report generates the ____ report
a. Simple          b. Formatted     c. Summary      d. All
Q.82 Database is
a. Relation        b. Order            c. List               d. Collection of data
Q.83 Which of the following is the largest unit of data?
a. Field             b. Database      c. Records        d. Table
Q.84 To add data from which menu
a. Append from browse menu    b. Append from browser
c. Append from briefcase          d. Append from edit menu
Q.85 The append is
a. Adds data mid of record source         b. Adds data top of record source
c. Adds data at the bottom of record source      d. None
Q.86 Which is not the elements of SQL?
a. Select           b. From                        c. Where           d. Main
Q.87 Row is another name of
a. Record          b. Field             c. Table                        d. Query
Q.88 Framework of for storing records in database is a
a. Form             b. Report          c. Query            d. Table
Q.89 Append from command is used to
a. Adds new record form file      b. Add record from a variable
c. Add records from stock         d. All of the above
Q.90 DBMS is
a. Collection of data      b. Set of programs to access data
c. Set of programs to update data         d. All of above
Q.91 In ___ data model are organized into tables
a. Relational      b. Network        c. Tree  d. Hierarchical
Q.92 Which term refers to a collection of related information?
a. Database      b. List   c. Outline          d. Record
Q.93 Oracle and Ms Access are
a. Spreadsheet              b. RDMS
c. Operating system      d. Utility
Q.94 The main output object of MS Access is
a. Table            b. Macro           c. Report          d. Module
Q.95 The extension of dBase data file is
a. .exe              b. .mdb                        c. .dbf              d. .ndx
Q.96 The extension of MS access data file is
a. .mdx             b. .mdb                        c. .dbf              d. .ndx
Q.97 Which of the following software is not used for database design?
a. MS access    b. Oracle           c. SQL server    d. Web Server
Q.98 The arranging data in a logical sequence is called
a. Classifying    b. Sorting         c. Summarizing d. Reproducing
Q.99 DBMS is
a. Application Software             b. System Software
c. Program Software                 d. All of the above
Q.100 What do you mean by Report?
a. Output          b. Modify          c. Entry Format d. Enquiry
Q.101 Database has
a. Design view b. Datasheet view          c. Format view  d. Both a and b
Q.102 Which command is used to display the record that satisfies the specified criteria?
a. FIND QUERY    b. SEARCH QUERY  c. SELECT QUERY    d. LOCATE QUERY
Q.103 Which of the following is not a Access database object?
a. Datasheet     b. Table            c. Form             d. Query
Q.104 What is the maximum character for text field?
a. 64 character          b. 255 character         c. 512 character        d. None
Q.105 Which key is necessary to define relationship between the tables?
a. Secondary key                                  b. Primary key
c. Miscellaneous key                             d. Auxiliary key
Q.106 A tool provided in a database management system that allows users to define the database is called
a. Structured query language                 b. Data definition language
c. Data manipulation language               d. None
Q.107 What is the full form of RDBMS?
a. Relational database management system
b. Rational database management system
c. Record database management system
d. Read database management system
Q.108 Index is used to perform the _______  operation
a. Searching      b. Sorting         c. Validating      d. None
Q.109 The collection of related information is called
a. Database      b. Table            c. Field             d. Record
Q.110 In Ms Access, Wizard helps to
a. Create table   b. Create form   c. Generate report         d. All of the above
Q.111 Filter displays
a. To suppress data and display list of data to meet the criteria
b. To display all data     c. Sort the data             d. All
Q.112 In RDBMS file refers as
a. Table            b. Entities         c. Field             d. None
Q.113 Which is not a field property?
a. Format          b. Indexed        c. Color                        d. Field size
Q.114 Which of the following automates the task?
a. Macro           b. Autotext        c. Wizard          d. Template
Q.115 Each individual data item is called
a. Field                         b. Data type      c. Comment      d. All of the above
Q.116 Which of the following is related to retrieval of data?
a. Query            b. Field             c. Record          d. Table
Q.117 What are the data called?
a. Raw and number        b. Image           b. Facts and figure        d. None
Q.118 Which of the following is the Database Programme?
a. Ms-Access    b. Ms-Word       c. Ms-Excel       d. Ms-Powerpoint
Q.119 What are the files of DBMS called?
a. Table            b. Attribute        c. Filed             d. None
Q.120 __________ is a interface through which the user interacts with the application.
a. Form             b. Module         c. Report          d. Query
Q.121 When key is used to find and distinguish records uniquely?
a. Foreign key   b. Candidate key           c. Primary key   d. All of the above
Q.122 ________ helps to create the fields of a table in Ms-Access.
a. Form view     b. Design view              c. Table view     d. None of the above
Q.123 The technique which define a set of values acceptable for the field is known as
a. validation      b. Verification               c. Relation        d. Audit
Q.124 Technique to speed up data retrieval in database is
a. Speeding      b. Listing          c. Indexing        d. Warping
Q.125 The oldest database models are
a. Object oriented          b. Hierarchical and network model
c. Relational                  d. None
Q.126 Consider the following table student (roll. No, name, grad, subject). Which SQL is correct to retrieve the name of all students having grade "B"
a. SELECT name FROM STUDENTS
b. SELECT name FROM students WHERE grade="B"
c. SELECT name FROM students WHERE grade IN B.
d. Both b and c
Q.127 Which of the following keywords doesn't belong to DDL?
a. CREATE       b. ALTER          c. CONSTRAINT            d. SELECT
Q.128 A ______ constraint restricts values you can insert into a column.
a. CHECK         b. VALIDATE    c. VERIFY         d. Same
Q.129 Term 'Query' is used generally in
a. Word processing       b. Presentation  c. OS    d. Database
Q.130 A _______ key is a column in your table that make each record unique and it cannot have null value.
a. Primary         b. Foreign         c. Edit              d. Update
Q.131 In a relational database, a key that is on the many side of a one to may relationship is known as
a. Primary key   b. Foreign key   c. Secondary key          d. None of the above
Q.132 From which tale, Data fetching will be show
a. Table with less number of columns
b. Table with less number of fields
c. Table without index on columns
d. Table with index on columns
Q.133 Which of the following is not a database application?
a. dBase           b. Edit              c. FoxPro         d. Access
Q.134 Size of a database are usually measured in terms of
a. Tera bytes     b. Mega bytes   c. Data bytes    d. Giga bytes
Q.135 A organized collection of logically related data is known as
a. Data             b. Meta data     c. Database      d. Data versus information
Q.136 A field that uniquely identify each record in a table is
a. Main field      b. Primary key   c. Key field       d. Index key
Q.137 A DBMS allow you to create and maintain a database, create reports, and develop application programs, select the best fit answer
a. Database management approach       b. DBMS uses
c. Database administrator                      d. Query language
Q.138 A large collections of tables are called _____
a. File system   b. Fields           c. Records        d. Databases
Q.139 Which of the following is a database management system?
a. Oracle           b. Ms. Word      c. Lotus 1-2-3    d. None of the above
Q.140 Which of the following is not a data type?
a. Picture          b. Date             c. Numeric        d. Character
Q.141 _____is a collection of data stored in a standardized format designed to be shared by multiple users.
a. Database      b. Record         c. Database management system          d. Relation
Q.142 A field or group of fields that uniquely identifies every row of table is
a. Primary key   b. Foreign key   c. Hot key         d. Access key  
Q.143 The oldest database model are:
a. Hierarchical and network                    b. Relational and object oriented
c. Object oriented and deductive                        d. None of the above
Q.144 The relational model defines two root language - relational algebra & relational calculus for accessing
a. Text file         b. Document file           c. Relational database   d. Flat-file database
Q.145 Meaning of metadata is
a. Data definition           b. Data of data c. Data for data             d. Data dictionary
Q.146 Collection of interrelated data is known as
a. Data model   b. DBMS          c. Database                  d. All of the above
Q.147 Which of the following is not a relational database.
a. Reflex           b. Dbase_IV      c. Sybase                     d. SQL Server
Q.148 The relational algebra is a ____ language.
a. Complex language                 b. Lower level language
c. Procedural language              d. Non-Procedural language
Q.149 The highest level in the hierarchy of data organization is called
a. Data record   b. Data bank     c. Database      d. Data file
Q.150 The basic SQL select statement has three clauses
a. Select, From, Where              b. Select, For, Next  
c. Select, Next, For                   d. Select, Until, End
Q.151 Which of the following is not characteristics of relational database model?
a. Records        b. Tables    c. Tree like structure        d. Complex logical relationship
Q.152 One of the main objective of a DBMS is used to
a. Replace file based systems
b. Create a database for an organization.
c. Facilitate sharing of a database by current and future application.
d. Allow sharing application program.

4 comments:

Post Top Ad