PSSSB Clerk IT MCQs on Computers and Information Technology Mock Test 2

PSSSB Clerk IT MCQs on Computers and Information Technology MCQs on Computers and Information Technology Mock Test 2, PSSSB Clerk IT MCQs on Computers and Information Technology Mock Test 2,MCQs on Computers and Information Technology Mock Test 2

PSSSB Clerk IT MCQs on Computers and Information Technology Mock Test 2 Base Important Questions:-

1.The activity of a file
A. Is a low percentages of number of records added or deleted from a file
B. If high, reduces processing efficiency for sequential and non-sequential files
C. Is a measure of the percentage of existing records updated during a run
D. Refers to how closely the files fits into the allocated

2.When you have finished entering information into a form
A. The template is written to the data file
B. The contents of the form are written to the data file
C. The contents of the form can be printed
D. None of the above

3. Primitive operations common to all record management systems include
A. Print
B. Sort
C. Look-up
D. None of the above

4. The on-line, softcopy display a customer’s charge account to respond to an inquiry is an examples of a
A. Forecasting report
B. Exception report
C. Regularly scheduled report
D. On demand report

5. In SQL, which command is used to changes data in a table?
A. UPDATE
B. INSERT
C. BROWSE
D. APPEND

6. Which of the following is a serious problem of file management systems?
A. Difficult to update
B. Lack of data independence
C. Data redundancy
D. All of the above

7. An indexing operation
A. Sorts a file using a single key
B. Sorts file using two keys
C. Establishes an index for a file
D. Both (b) and (c)

8. Which command is used to remove a table from the database in SQL?
A. DELETE TABLE
B. DROP TABLE
C. ERASE TABLE
D. UNATTACH TABLE

9. Embedded pointer provide
A. A secondary access path
B. A physical record key
C. An inverted index
D. All of the above

10 . In SQL, the ALTER TABLESPACE command is used
To add/rename data files
A. To change storage characteristics
B. To take a table space online/offline
C. All of the above

PSSSB Clerk IT MCQs on Computers and Information Technology Mock Test 2 Answer Key:-

1. A
2. B
3. C
4. D
5. A
6. D
7. C
8. B
9. A
10. C

WEBSITE NAME :- eduworld24.com

YOUTUBE CHANNEL:- EDUCATION WORLD EW

PSSSB Clerk IT MCQs on Computers and Information Technology