विदेशमा रहेका नेपालीलाई मतदानको व्यवस्था मिलाउन आदेश

सर्वोच्च अदालतले विदेशमा बस्ने नेपालीलाई मतदानको अधिकारबाट वञ्चित नगराउन निर्देशनात्मक आदेश जारी गरेको छ । न्यायाधीशद्वय सपना मल्ल प्रधान र पुरुषोत्तम भण्डारीको संयुक्त इजलासले विभिन्‍न उद्देश्यले विदेशमा रहेका सबै नागरिकको मतदानको अधिकार सुनिश्चित गर्न आवश्यक प्रबन्ध मिलाउन आदेश दिएको हो ।

‘विदेशमा बसेको भए पनि नेपाली नागरिकता नत्यागेको र अन्य कुनै पनि देशको नागरिकता नलिएको, मतदानका लागि कानुनबमोजिमको उमेर पूरा भई मतदाता परिचयपत्र भएको तथा विदेशमा रहेका नागरिकहरूको सम्बन्धमा कूटनीतिक निकायले तयार गर्ने लगतमा अद्यावधिक भएको व्यक्तिलाई बाहिरबाट भोट गर्न योग्य मानी व्यवस्था गर्नू,’ आदेशमा भनिएको छ ।

PSC MSQ SQL Database Question Asnswer Set

PSC MSQ SQL Database Question Asnswer Set

1) DROP is a ................ statement in SQL.

A. Query

B. Embedded SQL

C. DDL

D. DCL

👉Ans:Click hereC. DDL

2) The keyword to eliminate duplicate rows from the query result in SQL is.

A. DISTINCT

B. NO DUPLICATE

C. UNIQUE

D. None of the above

👉Ans:Click hereC. UNIQUE

3) Which of the following aggregate function does not ignore nulls in its results?

A. COUNT

B. COUNT(*)

C. MAX

D. MIN

👉Ans:Click hereB. COUNT(*)

4) In SQL, testing whether a subquery is empty is done using

A. DISTINCT

B. UNIQUE

C. NULL

D. EXISTS

👉Ans:Click hereD. EXISTS

5) ................ operator is used to compare a value to a list of literals values that have been specified.

A. Like

B. Compare

C. Between

D. In

👉Ans:Click hereD. In

6) The language used in application programs to request data from the DBMS is referred to as the

A. DML

B. DDL

C. VDL

D. SDL

👉Ans:Click hereA. DML

7) The DBMS language component which can be embedded in a program is

A. The data definition language(DDL)

B. The data manipulation language(DML)

C. The database administrator(DBA)

D. A query language

👉Ans:Click hereOption B(DML)

8) A DBMS query language is designed to
A. Support end users who use English-like commands.

B. Support in the development of complex applications software.

C. Specify the structure of a database.

D. All of the above

👉Ans:Click hereD. All

9) It is possible to define a schema completely using.

A. VDL and DDL

B. DDL and DML

C. SDL and DDL

D. VDL and DML

👉Ans:Click hereB. DDL and DML

10) Which of the following is correct.

A. a SQL query automatically eliminates duplicates.
B. SQL permits attribute names to be repeated in the same relation.

C. a SQL query will not work if there are no indexes on the relations.

D. None of these.

👉Ans:Click hereD. None

11) Which of the following is a comparison operator in SQL?

A. =

B. LIKE

C. BETWEEN

D. All of the above

👉Ans:Click hereD. All

12) To delete a particular column in a relation the command used is.

A. UPDATE

B. DROP

C. ALTER

D. DELETE

👉Ans:Click hereC. ALTER

13) The ............ operator is used to compare the value to a list of literals values that that have been specified.

A. BETWEEN

B. ANY

C) IN

D) ALL

👉Ans:Click hereA. BETWEEN

14) ............ function divides one numeric expression by another and returns the remainder.

A. POWER

B. MOD

C. ROUND

D. REMAINDER

👉Ans:Click hereB. MOD

15) A data manipulation command the combines the record from one or more tables is called.

A) SELECT

B. PROJECT

C. JOIN

D. PRODUCT

👉Ans:Click hereC. JOIN

16) DDL stands for
A. Data definition language
B. Data description language
C. Data design languages
D. Database dictionary languages.
👉Ans:Click hereA. Data definition language

17) The DDL is used to specify the ........
A. Conceptual schema
B. Internal schema
C. Both
D. None
👉Ans:Click hereA.Conceptual schema

18) Which is used for data retrieval from the database?
A. DDL
B. DML
C. SDL
D. VDL
👉Ans:Click hereB. DML

19) Which is used to specify the user views and their mappings to the conceptual schema?
A. DDL
B. DML
C. SDL
D. VDL
👉Ans:Click hereD.VDL

20) Which command are included in a general purpose programming languages?
A. DDL
B. DML
C. DSL
D. VDL
👉Ans:Click hereB.DML

PSC Assistant Computer Operator Exam 2074-05-07 Solved Answer Paper

लाेक सेवा अायाेग, नेपाल विविध सेवा, राजपत्र अनंकित द्वितीय श्रेणी

सहायक कम्प्युटर अपरेटर वा साे सरह (प्राविधिक) पदकाे प्रतियाेगितात्मक परीक्षा मिति २०७४-०५-०७

Key: (B) विषय सेवा सम्बन्धी ।

Full form, Technical terms, abbreviations, कम्प्युटर सम्बन्धित केही संक्षिप्त तथा पुरा रूपहरू

कम्प्युटर सम्बन्धित केही संक्षिप्त तथा पुरा रूपहरू

Computer related technical terms and abbreviations: (Short form : Full Form)

ACER - Acquisition Collaboration Experimentation Reflection.
ADSL - Asymmetric Digital Subscribe Line.
AMOLED - Active-matrix organic light-emitting diode.
AMR- Adaptive Multi-Rate.
APK - Authenticated public key.
APN - Access Point Name.
ATM - Automated Teller machine.
CDMA - Code Division Multiple Access.
CMOS - Complementary Metal Oxide Semiconductor
COM - Computer Output Microfilm
COMPUTER - Common Oriented Machine Particularly United and used under Technical and Educational Research.
DAT - Digital Audio Tape
DELL - Digital electronic link library.
DIVX - Digital internet video access.
DLNA - Digital Living Network Alliance.
DNSE - Digital natural sound engine.
DTP - Desk top publishing.
DVD - Digital Versitle Disk.
EDGE - Enhanced Data Rates for Globa Evolution.
ESN - Electronic Serial Number.
FSSAI(Fssai) - Food Safety & Standards Authority of India.
GOOGLE - Global Organization Of Oriented Group Language Of Earth.
GPRS - General Packet Radio Service.
GPS - Global Positioning System.
GSM - Global System for Mobile Communications.
HDMI - High-Definition Multimedia Interface.
HP - Hewlett Packard.
HS - HOTSPOT.
HSDPA - High speed down-link packet access.
HSPA - High Speed Packet Access.
HSUPA - High-Speed Uplink Packet Access.
IFSC - Indian Financial System Code.
IMEI - International Mobile Equipment Identity.
ISP - Internet Service Provider.
IVRS - Interactive Voice Response System.
J2ME - Java 2 micro edition.
LCD - Liquid Crystal Display.
LED - Light emitting diode.
MMS - Multimedia Message Service.
MODEM - Modulator-Demodulator.
MPEG - moving pictures experts group.
NFC - Near field communication.
OLED - Organic light-emitting diode.
OS - Operating system.
OTG - On-the-go.
OVI - Ohio Video Intranet.
P.O.I - Point of interest.
PAN - permanent account number.
PDF - portable document format.
PPI - Pixels Per Inch.
QVGA - Quarter Video Graphics Array.
RAM - Random access memory.
ROM - Read only memory.
RSS - Really simple syndication.
SIM - Subscriber Identity Module.
SIS - Installation source.
S-LCD - Super Liquid Crystal Display.
SMS - Short Message Service
SNS - Social network service.
STD - Subscriber Trunk dialling.
TAX - Trunk Automatic Exchange
TFT - Thin film transistor.
UMTS - Universal Mobile Telecommunicati ons System.
UPS - Uninterruptible power supply.
USB - Universal serial Bus.
VGA - Video Graphics Array.
VIRUS - Vital Information Resources Under Siege.
VPN - Virtual private network.
WCDMA - Wide-band Code Division Multiple Access.
Wi-Fi - Wireless fidelity.
WINDOW - Wide Interactive Network Development for Office work Solution.
WLAN - Wireless Local Area Network.
WVGA - Wide video graphics array.
WXGA - Widescreen Extended Graphics Array.
XML - Extensible Markup Language
YAHOO - Yet Another Hierarchical Officious Oracle.

Full form of some words
News paper = _North East West South past and present events report._
Chess = _Chariot, Horse, Elephant, Soldiers._
Cold = _Chronic Obstructive Lung Disease._
Joke = _Joy of Kids Entertainment._
Aim = _Ambition in Mind._
Date = _Day and Time Evolution._
Eat = _Energy and Taste._
Tea = _Taste and Energy Admitted._
Pen = _Power Enriched in Nib._
Smile = _Sweet Memories in Lips Expression._
etc. =_End of Thinking Capacity_
OK =_Objection Killed_
Or =_Orl Korec (Greek Word)_
Bye = Be with you Everytime.

PSC MCQ Ms-Word Practice Quiz Set 01

Microsoft Word Practice Quiz Set 01

1. Which of the following is not valid version of MS Office?
 A) Office XP
 B) Office Vista
 C) Office 2007
 D) None of above
➤ Answer: Click hereOption B

2. You cannot close MS Word application by
 A) Choosing File menu then Exit submenu
 B) Press Alt+F4
 C) Click X button on title bar
 D) From File menu choose Close submenu
➤ Answer: Click hereOption D

3. The key F12 opens a
 A) Save As dialog box
 B) Open dialog box
 C) Save dialog box
 D) Close dialog box
➤ Answer: Click hereOption A

4. What is the short cut key to open the Open dialog box?
 A) F12
 B) Shift F12
 C) Alt + F12
 D) Ctrl + F12
➤ Answer: Click hereOption D

5. A feature of MS Word that saves the document automatically after certain interval is available on
 A) Save tab on Options dialog box
 B) Save As dialog box
 C) Both of above
 D) None of above
➤ Answer: Click hereOption A

6. Where can you find the horizontal split bar on MS Word screen?
 A) On the left of horizontal scroll bar
 B) On the right of horizontal scroll bar
 C) On the top of vertical scroll bar
 D) On the bottom of vertical scroll bar
➤ Answer: Click hereOption C

7. Which of the following is not available on the Ruler of MS Word screen?
 A) Tab stop box
 B) Left Indent
 C) Right Indent
 D) Center Indent
 E) All of them are available on ruler
➤ Answer: Click hereOption D

8. What is place to the left of horizontal scroll bar?
 A) Tab stop buttons
 B) View buttons
 C) Split buttons
 D) Indicators
 E) None of above
➤ Answer: Click hereOption B

9. Which file starts MS Word?
 A) Winword.exe
 B) Word.exe
 C) Msword.exe
 D) Word2003.exe
➤ Answer: Click hereOption A

10. How many ways you can save a document?
 A) 3
 B) 4
 C) 5
 D) 6
➤ Answer: Click hereOption A

11. If you want to keep track of different editions of a document which features will you use?
 A) Editions
 B) Versions
 C) Track Change
 D) All of above
➤ Answer: Click hereOption B

12. Background color or effects applied on a document is not visible in
 A) Web layout view
 B) Print Layout view
 C) Reading View
 D) Print Preview
➤ Answer: Click hereOption D

13. What is a portion of a document in which you set certain page formatting options?
 A) Page
 B) Document
 C) Section
 D) Page Setup
➤ Answer: Click hereOption C

14. Borders can be applied to
 A) Cells
 B) Paragraph
 C) Text
 D) All of above
➤ Answer: Click hereOption D

15. Which of the following is not a type of page margin?
 A) Left
 B) Right
 C) Center
 D) Top
➤ Answer: Click hereOption C

16. What is the default left margin in Word 2003 document?
 A) 1"
 B) 1.25"
 C) 1.5"
 D) 2"
➤ Answer: Click hereOption B

17. What is gutter margin?
 A) Margin that is added to the left margin when printing
 B) Margin that is added to right margin when printing
 C) Margin that is added to the binding side of page when printing
 D) Margin that is added to the outside of the page when printing
➤ Answer: Click hereOption C

18. Portrait and Landscape are
 A) Page Orientation
 B) Paper Size
 C) Page Layout
 D) All of above
➤ Answer: Click hereOption A

19. If you need to change the typeface of a document, which menu will you choose?
 A) Edit
 B) View
 C) Format
 D) Tools
➤ Answer: Click hereOption C

20. Which of the following is not a font style?
 A) Bold
 B) Italics
 C) Regular
 D) Superscript
➤ Answer: Click hereOption D