Loading MS Word
Showing posts with label MCQ Sets. Show all posts
Showing posts with label MCQ Sets. Show all posts
Most Important Question Set-2 for Competitive Exams
1. What is the file extension of ms access database?
a. .mad b. .adb c. .dbm d. .mdb
2. The latest version of ms access is
a. 2000 b. 8.0 c. Xp d. 2006
3. Which of the following statement is not correct?
a. Save the database file before
working on it b. Macro is not an
object
c. Query works on sql standard d. Form is the front-end object
4. Which of the following statement is correct?
a. Table can be created in two ways b. Query stores the data
like table
c. From can be created in two ways d. Reports can be
generated without any table
5. Data can be defined as
a. Piece of information b.
Raw facts c. Recessed information d.
none
6. Collection of data is known as
a. Database b.
Dbms c.
Rdbms d. Information
7. When data is processed, it obtains
a. Database b.
dbms c.
rdbms d. Information
8. DBMS stands for
a. database managerial system b.
database management system
c. database basic managerial
system d.
database basic management system
9. The key difference between dbms
and rdbms is termed in
a. 12 Codd's rules b.
6 Codd's rules c. relationship d.
None of above
10. Fields are also termed as
a. column b.
record c.
entity d. row
11. Association among entities is expressed in the term of
a. attributes b. Relationship c.
query d. properties
12. When primary key is applied to the field, the field
a. will not accept null values b.
Will not accept duplicates
c. both a& b d. none of
above
13. When indexing is done in the particular field, the field
a. Will not accept null valued b. May or May not accept
duplicates
c. both a &b d. none of above
14. Which of the following option is best suit for ms access
definition?
a. dbms
b.
rdbms c.
back end d.
Microsoft database
15. Tables, forms, queries, reports all are the
a. objects b.
field c.
database d.
Options
16. You have to apply the constraint of 'not null' values, than
which property you will apply?
a. primary key b.
index c.
required d. a
& c
17. ole stands for
a. Object link & Engaging b. object linking & Embedding
c. object like & energy d. Online linking & embedding
18. Table can be created by...in ms access
a. 2 ways b.
3 ways c.
4 ways d.
5 ways
19. From which data type drop down menu can be created in access
a. ole
object b.
drop down c. hyperlink d.
Look up wizard
20. Which data types support large number of text (characters)?
a. Memo b.
text c.
ole object d. Look up wizard
21. Which of the following data type is used for Boolean Value?
a. Currency b.
Hyperlink c. Yes/No d.
Look up wizard
22. Maximum Length of field name
a.50 b.
64 c. 255 d.256
23. Which field property allows you to set date in "mm/dd/yy"?
a. date b. format c. field size
d. caption
24. Which is not part of report?
a. Title b.
Report footer c. Detail d. Page footer
25. User cannot left the field blank or field cannot contain the
null value because of the Following property
a. indexed b.
required c. validation d. default value
26. User cannot make duplicate entry because of the following
property
a. indexed b.
required c. validation rule d.
default value
27. You have to set the validation rule for 'date should be earlier
than today' which of the following is correct
a.<=date() b.<=date c.<date()
d.<date
28. you have to set the validation rule for salary should not be
less than 2500 and should not exceed 15000, which of the following is correct
a. <=2500 or >=15000 b.>= 2500 and<=15000 c.<2500
or>15000 d.<2500 and >15000
29. To create the input mask for letter (a to z), entry required,
which of the following character is used
a. l b.? c.
& d. C
30. The special form that links different objects for integration is
called...
a. Package form b.
Entry form c. Switchboard
d.
Auto form
31. Primary key is essential for
a. not to allow duplicate entry b. not to allow null
values
c. to create relationship d. all of above
32. To create the relationship, which of the following is essential?
a. primary b.
foreign key c. both of above
d.
none of above
33. While creating the relationship, the "enforce referential
integrity" means
a. Value cannot be entered into
second table other than specified in the first table's field
b. Value can be entered into the
second table other than specified in the first's table's field
c. Can not make null entries
d. Can not make entries
34. SQL stands for
a. Structured query line b.
structured question line
c. Structured query language d.
Structured question language
35. DCL is a part of DBMS and it stands for
a. Data count language b.
Data control language
c. Data computer language d. Data command language
36. In ms-access, SQL statement can be written by choosing
a. Design view b.
Datasheet view c. Query view d.
sql view
37. How many types of action queries are in ms-access?
a. 4 b. 5 c. 6 d. 7
38. To add or deduct the values on the table, which of the following
query, you will use.
a. Append query b.
update query c. select
query d. none of the above
39. Ms-access form is also termed as ----in database terminology
a. back end b. front end
c. middle edge d. application.
40. To modify a form, you will go from
a. design view b. datasheet view c. form view d.
run view
41. Form can be based on -----
a. table b.
query c. table
& query d. table, query & form
42. ---------------is the output of database
a. Report b. form c.
macro d. query
43. Report can be based on -------------
a. report b. query c. table & query d. table,
query & form
44. The text that is written inside 'Report footer' on three page
long report, how many times will repeat the footer?
a. 2 times b. 3 times c. 4 times repeat d. will not
repeat
45. The grand total is the part of report....
a. Report footer b. page footer c. details d.
report header
46. Set of actions contained in one object is known as
a. Form b. report c. macro d. Query
47. What is the difference between form and report?
a. Form is an object and report is
not. b.
Form relies on report
c. Report relies on form d. form is the front-end part and
report is the final output of database
48. Data can be entered into the table by using
a. Form b.
report c. A and
B d. none on above
49. Report can be created with -----------------table(s) at a time
a. Just one b.
two tables c. three tables d.
many
50. Macro can be used with
a. Form b. report c. Query d. all of the above
Answer Sheet
1
|
d
|
2
|
c
|
3
|
b
|
4
|
b
|
5
|
b
|
6
|
a
|
7
|
d
|
8
|
b
|
9
|
a
|
10
|
a
|
11
|
b
|
12
|
c
|
13
|
c
|
14
|
b
|
15
|
a
|
16
|
D
|
17
|
b
|
18
|
b
|
19
|
d
|
20
|
a
|
21
|
c
|
22
|
c
|
23
|
b
|
24
|
d
|
25
|
b
|
26
|
a
|
27
|
c
|
28
|
b
|
29
|
b
|
30
|
c
|
31
|
d
|
32
|
c
|
33
|
a
|
34
|
c
|
35
|
b
|
36
|
d
|
37
|
a
|
38
|
a
|
39
|
b
|
40
|
a
|
41
|
c
|
42
|
a
|
43
|
c
|
44
|
d
|
45
|
a
|
46
|
c
|
47
|
d
|
48
|
a
|
49
|
d
|
50
|
d
|
||||||||||||
Most Important Question Set of Nepal Oil Corporation Exam
Most Important Question Set
of Nepal Oil Corporation
1.
Which command transfer the contents sector by sector from one disk to another
disk?
a. Xcopy b. Diskcomp c. Copy d. Diskcopy
2.
Which one is true for unconditional disk formatting?
a. Check/ Scan surface after
format b.
Do not Check/ Scan surface after format
c. Transfer system files after
format d. All of the above
3.
MO Disk is
a. Optical disk b. Magnetic Disk
c. Semiconductor Disk d.
Disk based on Optical & Magnetic technology
4. Which is not internal command?
a. Mem b. Mkdir c. Path d.
Prompt
5. The output quality of the …….. is better than others.
a. CRT monitor b.
LCD Monitor c. Both
A & B d.
None
6. The command is used to give new name for file
a. Ren b. Rename c. Move d. All of
the above
7. The ……………… translates the source code into machine code
a. Translator b. Assembler c. Compiler d.
Interpreter
8. Which is external command?
a. Path b. Prompt c. Vol d. None
9. Which number system uses the both number and characters to represent number?
a. Binary b. Octal c.
Decimal d.
Hexadecimal
10. The command used to create logical drive for specific location of Disk.
a. Fdisk b. Subst c. Format d. All of
the above
11. Which memory uses ultra-violet rays to erase its content.
a. EPROM b. EEPROM c.
EAPROM d.
ROM
12. The command used to create logical drive for specific location of Disk.
a. Fdisk b. Subst c. Format d. All of
the above
13. Which is the original System prompt?
a. C> b. C:\> c. C:> d.
None
14. The Size of First Floppy disk was
a. 9" b. 8" c. 51/4" d.
31/2"
15. The key types the complete previous command in prompt.
a. F1 b. F2 c. F3 d.
F4
16. The maximum length of any single path from the root directory?
a. 54 b. 63 c. 127 d.
132
17. The organization and interconnection of the various functional components of a computer system is called…
a. Design b. Architecture c. Network d. Graphics
18. The device used in Geographical mapping
a. Bar Code b. Plotter c.
Digitizer d. Scanner
19. The command is used to change directory.
a. CD b. CD\ c. Chdir.. d.
All of the above
20. Which is a not valid symbol for the file name?
a. @ b. # c. $ d.
/
21. Offline operation is the operation of devices without the control of
a. Memory b. CPU c.
Control unit d. ALU
22. Which was the first commercially available microprocessor?
a. Intel 308 b. Intel 4004 c.
Intel 4005 d. Intel 8086
23. Monitor is also known as …
a. VDU b. TV c.
VUD d. None
24. Which file contains the configuration about system?
a. Autoexec.bat b. Himem.sys c. Config.sys d.
All
25. Which device driver configure extended memory and High memory area (HMA)?
a. IO.sys b. Himem.sys c. Emm386.exe d. Command.com
26. DDR stands for
a. Double Data Rate b. Double Density Rate c. Density Data Rate d. All of the above
27. Which is the function of ROMBIOS?
a. POST operation b. Boot start-up operation c. Bootstrap loading d. A and B
28. Which is not valid for user file name?
a. Ram.123 b. Ram.doc c.
Suman.exe d. Ram.txt
29. The number of sectors per track in high density floppy disk is
a. 9 b. 15 c. 18 d.
36
30. The signal converter is used in most of the output device is…
a. Decoder b. Modem c.
Gate d. Multiplexure
31. Which switch will display the contents from specified directory and subdirectory?
a. /p b. /b c. /s d.
/d
32. The name of chip will be applied for dynamic and high power computing based on very latest technology
a.
Microprocessor b. Biochip c. Robot chip d.
Ultra-Chip
33. The full form of PDA is
a. Personal
Digital Assistant b. Personal Diary Assistant
c. Personal Data
Assistant d. Professional Data Assistant
34. The command is used to display the status of disk
a. Diskcomp b. Disk copy c. Chkdsk d.
Dir
35. The access method is used to read data from the cassette memory.
a. Direct b.
Random c.
Sequential d. All of the above
36. The most input device that contains a series of switches which generates a series of different pulse code when user presses it.
a. Keyboard b. Mouse c. Piano d.
None of the above
37. Pico means
a. 1 millionth
part b. 1 billionth part c. 1 trillionth part d. 1 Quillinarth part
38. The quality of printer depends upon
a. Technology b. Price c.
Resolution d. All of the above
39. Which was the first generation computer?
a. IBM-650 b. IBM -1400 c. IBM system / 370 d. IBM system / 360
40. Large data bus width causes
a. Transmit data
faster b. Faster computing c. Slow execution d. All of the above
41. The first computer introduced to Nepal for 2038 census was
a. IBM 1400 b. IBM 1401 c. ICL 2051 d.
ICL 2950
42. Which one is not correct for OS
a. OS interprets
the user command b.
Provides the platform to other application
c. Slower the
computer speed d.
Manage the Files & Disk
43. Half byte is also known as
a. Data b. Bit c. Byte d. Nibble
44. The function of control unit is
a. To transfer
data to primary storage b.
To store program instructions
c. To perform
logic operations d.
To decode program instructions
45. The maximum capacity of 2HD- 3 ½" Floppy disk.
a. 1.44 Mb b. 1.44 MB c. 1.4 MB d.
1.4 Mb
46. The collections of instructions is called
a. Database b. File c. Program d.
All of the above
47. The Writing method in CDROM is called
a. Copying b. Burning c. Embedding d.
None of method
48. The system date is in ………….. Date format.
a. ANSI b. British c. American d. International
49. The data bus is
a.
Bi-directional b.
Uni-directional c.
Multi-directional d. None of the above
50. First OS was developed in
a. 1958 b. 1976 c. 1950 d.
1946
Answer Sheet
1
|
d
|
2
|
a
|
3
|
d
|
4
|
a
|
5
|
a
|
6
|
a
|
7
|
a
|
8
|
d
|
9
|
d
|
10
|
b
|
11
|
a
|
12
|
b
|
13
|
a
|
14
|
b
|
15
|
c
|
16
|
b
|
17
|
b
|
18
|
c
|
19
|
d
|
20
|
c
|
21
|
c
|
22
|
b
|
23
|
a
|
24
|
c
|
25
|
c
|
26
|
a
|
27
|
d
|
28
|
c
|
29
|
c
|
30
|
a
|
31
|
c
|
32
|
b
|
33
|
c
|
34
|
c
|
35
|
c
|
36
|
a
|
37
|
c
|
38
|
c
|
39
|
a
|
40
|
a
|
41
|
d
|
42
|
c
|
43
|
d
|
44
|
c
|
45
|
b
|
46
|
c
|
47
|
b
|
48
|
c
|
49
|
a
|
50
|
c
|
||||||||||||
Subscribe to:
Posts (Atom)