POSTAL RULLING

DOWNLOAD

RH ON 31 DECEMBER 2011

DOWNLOAD

How to Repair a Suspected SQL Database

Sometimes when you connect to your database server, you may find it in suspect mode. Your database server won’t allow you to perform any operation on that database until the database is repaired.

A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc.

To get the exact reason of a database going into suspect mode can be found using the following query

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

Output of the above query will give the errors in the database.

To repair the database, run the following queries in Query Analyzer,

EXEC sp_resetstatus ‘yourDBname’;

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb(‘yourDBname’)

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (‘yourDBname’, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname SET MULTI_USER

      You should keep one thing in mind while using the above queries that the repair mode used here , REPAIR_ALLOW_DATA_LOSS, is a one way operation i.e. once the database is repaired all the actions performed by these queries can’t be undone. There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database before executing above mentioned queries.

HTML Quiz Questions and Answers

CLICK HERE

IPO MODEL PAPER

DOWNLOAD

Model Question for IPO Examination - FHB Part I (Question No 47-66)

Q47   The service books of non –gazetted  officials  on deputation  to Army Postal Service  should kept at a. Office of ADG APS b. Director of  Postal  Accounts , Nagapur C. Account office of Parent  Department

Q48   The service books should be kept  arranged ----------- a. alphabetically  b on the basis of  cadre  c. None  of these

Q49   Preservation  period  for  keeping  service Books after death, resigns and  discharge of employee  is  ------- a. 10  years  b. 2  Years  c.  5  Years

Q50 The  descriptive  particulars  on the --------- of a government servant’s service book should be  reattested  every five year by the supervising officer . a. Last Page b. Second  Page   c.  None of these

Q51  Form ACG 20 is denote ----- a. Monthly  Bills  b. Arrear Bills  c . Bonus  Bills

Q52  The  Period of Joining  time should be  shown separately  in  absentee Statement The above  said statement is  a. True b. False

Q53  When will  prepare  monthly absentee  statement  at Sub  office a. 30th  of Month b. 10th day of  Month  c. 20th day of Month

Q54   From the following  document  , which  is  the supporting document for submission of TA Bills a. GAR 14 –C  b TA-14 C. GPR-23

Q55  The  outstation allowance is  sanctioned for ---------- a. all  officials  b. sorters and mail  Guards c.  None of these

Q56  Abstract Bill is prepared in  form --------- a. ACG 19 (1)  b. ACG 19  c. ACG10

Q57 The  undisbursed  pay and allowance should be  kept  in a  register a. ACG 7 b. ACG 67   c. ACG 54

Q58 Acquittance rolls and offices of the bills  are not to  submitted to the circle office The  above said  stamen is a. True  b False

Q59 The amount paid against advance from GPF -----------     by service money  order a.  Can be transmitted  b. Cannot be transmitted

Q60 The amount of  subsistence allowance in respect of officials under suspension who cannot attend personally  the  due amount  to the officials  forwarded by  service  money  order  to the concerned officials The  above action is a. Correct    b. Not correct

Q61  Special Contingencies  can be incurred without the previous   sanction of Superiorauthority  The above said statement is a.  True  b false

Q62  Contingent charges  may be divided  in to ------------- classes . a. Four  b. Two  c. Five

Q63 The policy regarding  engagement of casual workers   reviewed by  government as per the judgment of Supreme Court  delivered on -------- a. 17th  Jan  1970 b. 17th Feb  1989   c. 17th Jan 1986

Q64  When did minimum wages act formed a. 1956 b. 1982  c. 1948

Q65   The National  Holiday is also considered for calculating the  pay  for contingent staff   is it correct procedure ?   a. Yes  b. No

Q66  what is the time limit for completing  the review  in connection with appointment  of casual  workers in postal department a. 5 Year b. 1 year  c. 6 Months ----------------------------------------------------------------------------------------- Prepared by  S Jaychandran  , System Administrator , Divisional  office , Mavelikara Division-690101 . Please visit   nfpemavelikaradivision.blogspot . com

SQL 2008 R2 EXPRESS EDITION

DOWNLOAD