Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

SSC General Knowledge_Current Affairs Interview Questions
Questions Answers Views Company eMail

Which is not a feature of the American Constitution? (a) Federation (b) Written constitution (c) Republic (d) Cabinet system

2 7101

The State in India with the largest coastline is: (a) Tamil Nadu (b) Kerala (c) Andhra Pradesh (d) Maharashtra

44 180268

The driest part of India is: (a) Western Rajasthan (b) Jammu & Kashmir (c) Gujarat (d) Madhya Pradesh

7 30064

?Laterite Soil? is found in India in: (a) Western Ghats (b) Eastern Ghats (c) Deccan Plateau (d) Satpura region in Madhya Pradesh

5 17752

Kanishka patronised (A) Mahayana Buddhism (B) Hinayana Buddhism (C) Buddhism (D) Bhagvatism

10 19961

The gas used for artificial ripening of green fruit is (A) Ethylene (B) Ethane (C) Carbon dioxide (D) Acetylene

7 43817

The hottest part in the gas flame is known as the (A) Luminous zone (B) Dark zone (C) Blue zone (D) Non-Luminous zone

4 17789

The preamble of our Constitution reads : India is a (a) Sovereign, Socialist, Secular, Democratic Republic (b) Sovereign, Democratic, Socialist, Secular Republic (c) Socialist, Democratic, Secular Republic (d) Democratic, Sovereign, Secular, Socialist Republic

2 9259

India opted for a federal form of government because of (a) Vast territory (b) Cultural integration (c) Linguistic and regional diversity (d) Administrative convenience

6 14205

The Fundamental Rights granted to the Indian citizens are (a) Justiciable (b) Non-justiciable (c) Sometimes justiciable and sometimes non-justiciable (d) None of the above

1 3099

In which one of the following cases did the Supreme Court declare that a Constituent Assembly should be convened to amend the Fundamental Rights? (a) Golak Nath vs the State of Punjab (b) Gopalan?s Case (c) Keshava Nand Bharati?s Case (d) None of the above

1 5341

Who said that the Directive Principles of State Policy are just like ?A cheque on bank payable at the convenience of the bank?? (a) Shri Jawaharlal Nehru (b) Dr. B.R. Ambedkar (c) Dr. Rajendra Prasad (d) Prof. K. T. Shah

3 30624

If there is a vacancy in the office of the President, it must be filled up within a period of (a) One year (b) Two years (c) Three years (d) Six months

1 18166

The disputes regarding the election of the President are decided by (a) The Rajya Sabha (b) The Supreme Court (c) The Lok Sabha (d) The Chief Election Commissioner

5 58821

How is the size of the Council of Ministers determined? (a) The Parliament specifies it (b) The Constitution specifies it (c) The Prime Minister determines it but not to exceed 15 percent of the total membership of Lok Sabha (d) The President determines it according to the exigencies of time

1 17821

Post New SSC General Knowledge_Current Affairs Interview Questions


SSC General Knowledge_Current Affairs Interview Questions


Un-Answered Questions

Hi, I am new in oracle(SQL), could anyone help me in writing a correct SQL. Below is the table structure. Table: Subsc Fields: 1. Sub_no (this field will hold values of subscriber nos, for e.g. S111111, S222222, S333333, S444444, etc.) 2. s_status (this field will hold values for different status of subscriber, for e.g. 'A', 'S', 'C', etc.) 3. cus_id (this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) Table: Bill Fields: 1. Bill_no this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) 2. b_status = (this field will hold values for different status of bill for e.g. 'O', 'C', 'S', etc.) Note: 1. The Sub_no is a Primary key of Subsc table. 2. The cus_id is a foreign in Subsc table (referred from Bill_no field of Bill table) 3. The Bill_no field is the Primary key of Bill table. Query A --> I wrote a query to select cus_id/Bill_no which is in status open (b_status = 'O') and having more than two active subscriber (i.e. S_status = 'A') in it ( i.e. more the two subscribers in same bill). select s.cus_id from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id having count(sub_no) = 2 Problem : The above query will give the cus_id (or rather bill_no) which are in open status (b_status ='O) and which are having TWO ACTIVE Subscribers (s_status ='A') in it. However, this query will also lists the cus_id/bill_no which are having more than TWO subscribers in it (but only two subscriber will be in Active status (s_status = 'A') and the others will be in s_status = 'C' or s_status = 'S'. Help needed: I want to write a query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it. B--> If I include the sub_no in the above query then NO row are returned. select s.cus_id, s.sub_no from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id, s.sub_no having count(sub_no) = 2 Help needed: I want to modify the above query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it ALONG with the sub_no. Thanks a lot in advance. Regards, Nitin

1742


what are latest technologies ? and how will keep yourself up to date ?

2417


1. what is the opportunity in hardware & networking in future? 2.how many courses r in networking that fulfill market requrment? 3.who is better for career MCSE or CCNA ,UNIX ?

1629


What is a financial statement version? : fi- general ledger master data

585


Does ip protect data on the network?

615






Explain SS7

1205


Is django good for web development?

192


What do you understand by mail aliases?

534


Define what are the compositions of brass, how can this metal be heat-treated, define what is the melting point of this metal?

490


What is called method in c#?

498


i want m commerce and e commerce topic

1097


What are the security laws which are implemented to secure data in a cloud ?

297


Is rewriting notes a good way to study?

103


What is mq?

508


What is the difference between grid and off- grid system??

1463