Current Affairs 2016 MCQ Quiz – January 2016 – Set3

Current Affairs Quiz

Please get ready to face any competitive exam with the latest current affairs updates. The following multiple choice questions are covered in this online free current affairs quiz for January 2016 (03-01-2016).

Click on this image to take online exam.

Current Affairs January 2016 Questions and Answers Set -3

Current Affairs Questions and Answers:

Current Affairs 2016 questions answers online mock test quiz for students. Get latest updates on current affairs to face any competitive exams.

1.    Punjab National Bank has launched which digital banking solution on 3rd January 2016?
2.   A new metamaterial which can be used to speed up computers and devise invisibility cloaks is based on the phenomenon of _____________.
3.   Digital payments and commerce firm Paytm has acquired which consumer behaviour prediction platform on 3rd January 2016?
4.   Distant stars with planets orbiting them can harbour life, according to scientists who have discovered a way to measure _________ at surface of distant stars.
5.   Railway Ministry has fast tracked which bullet train corridor on the lines of DMRC by setting up a separate company?
6.   Saudi Arabia has severed ties with which nation amidst escalating tensions over execution of Shia cleric Sheikh Nimr al-Nimr?
7.   Scientists have discovered new way to develop solid state lithium batteries which will not explode or burn easily. This method involves using ________ electrolyte coating.
8.   What is the type of commerce where people get into the habit of transacting online?
9.   Which country beat defending champions Afghanistan to lift the South Asian Football Federation Cup on 3rd January 2016?
10.   Which country celebrated its independence day on January 4, 2016?
11.   Which country’s government has banned former PMs from staying at embassies to carry out private commercial work?
12.   Which pet care portal has Ratan Tata invested in January 2016?
13.   Which state has recognised e-Motor insurance policies for the first time?
14.  Scientists from Ireland have sequenced the _______ genomes from ancient Irish humans for the first time.
15. 2015 SAFF football championship title has been bagged by which of the following ?
16. Alstom, the transportation equipment maker rolled out the first set of railway coaches for the Kochi Metro project. Alstom is related to which country ?
17. Among all Asian and BRICS currencies, which currency is turned out to be the one of the best performers in 2015 ?
18. As per JLL’s top-30 list of the World’s most powerful, productive and connected cities, Mumbai has been ranked at which place ?
19. GOI constitute__________ Committee to study wage structure of Gramin Dak Sevaks.
20. IIM-Kozhikode will host the 52nd Annual Conference of TIES from January 4th, 2016. What does TIES stand for?
21. In the top top-30 list of the World’s most powerful, productive and connected cities, Delhi is ranked at which place ?
22. India defeated which country and won SAFF cup for the seventh time?
23. Inter-ministerial panel for ______gas to be set up soon.
24. Marketing analytics company MetrixLab has conferred which e-commerce giant with the title of ‘Website of the Year India 2015’ ?
25. Name the leader of Communist Party of India (CPI) who passed away recently.
26. Prime Minister Narendra Modi inaugurated the 103rd Indian Science Congress in which city ?
27. Public Enterprises Selection Board has appointed which of the following as the new CMD of defence PSU BEML Ltd ?
28. Recently which bank has announced to buy 4 Air India flats for Rs 90 crore ?
29. Recently which country has created three new military bodies as part of reforms to modernise its military and improve its fighting capacity ?
30. There will be no more interviews for which post in PSB’s?
31. Uttar Pradesh Government has appointed which of the following as its new Director General of Police(DGP) ?
32. What is the tagline for Corporation Bank ?
33. Which Bank has bagged three awards at the ‘National Payments Excellence Awards 2015’ event recently?
34. Which bank has been conferred with three awards at the “National Payments Excellence Awards 2015” ?
35. Which Carnatic vocalist has been conferred with the 2015 Sangita Kalanidhi award?
36. Which Grammy Award winning singer passed away in the last week of December 2015?
37. Which group to invest Rs 500 crore for setting up ethanol plant?
38. Which Indian exchange has launched a web-based portal for registrars and share transfer agents (RTAs) to enable depositories as well as file disclosures ?
39. Which nation has launched an online service platform for lawyers?
40. Which of the following is regarded as the financial capital of India ?
41. Which veteran CPI leader passed away on 2nd January and was general secretary of the party from 1996 to 2012?
42. Which Former Punjab Assembly Speaker passes away recently?

Current Affairs January 2016 Questions and Answers Set -3

Keywords: Current Affairs MCQ, Current Affairs Mock Test, Current Affairs, Current Affairs Free Online Test, Online Test, Banking, Railways, NDA, SSC, SSC CGL, IBPS, IBPS PO, IBPS Clerk, SSC CHSL, CDS, SCRA, UPSC, SBI Clerk, SBI PO, CTET, IBSP SO, RBI, RBI Assistant, IAS, RRB, competitive exams, quiz, mock test, online test, jobs, Multiple Choice Questions Answers, Bank Exams, Job Seekers, Current Affairs 2016.

Read More

Current Affairs MCQ Quiz – January 2016 – Set2

Current Affairs Quiz

Please get ready to face any competitive exam with the latest current affairs updates. The following multiple choice questions are covered in this online free current affairs quiz for January 2016 (02-01-2016).

Click on this image to take online exam.

Current Affairs Questions and Answers:

Current Affairs 2016 questions answers online mock test quiz for students. Get latest updates on current affairs to face any competitive exams.

1.  e-Commerce industry is estimated to be worth USD 38 billion by 2016 according to which industry body?
2.  Maharashtra government has inked an MoU with which defence company to boost tourism?
3.  Which is the tallest statue of Jesus Christ unveiled on 1st January in Africa?
4. 2015 Sangita Kalanidhi Award conferred upon which of the following vocalist ?
5. AB Bardhan, who has been recently passed away was related to which of the following field ?
6. According to Assocham, e-commerce revenue in 2016 may touch how many billion dollars?
7. Ardhendu Bhushan Bardhan, who passed away recently, was related to which of the following fields?
8. Arunima Sinha is related to which of the following fields?
9. Exercise Shakti 2016 that will be held in 2016 is a military exercise between India and
10. Financing agreement for IDA credit of USD 50 million for Nai Manzil Education and Skills Training for Minorities has been signed with which organisation by India?
11. For what time period has the Indian Government unveiled National Biotechnology Development Strategy?
12. From which month, government will unveil Direct Benefit Transfer (DBT) scheme for kerosene that will enable users to get financial support directly in their bank accounts ?
13. How much fund is being provided to expand a recently launched “Amma Seeds” scheme by Tamil Nadu CM J Jayalalithaa ?
14. In which of the dates the Raptor MoU has been concluded?
15. In which place did Ardhkumbhmela began in January 2016?
16. India’s Petronet LNG ink revised contract with RasGas company of which country ?
17. Name the Grammy-winning singer who passed away on 31 December 2015 and was famous for her album Unforgettable?
18. Name the IPS Officer who was appointed as Director General of Police (DGP) of Uttar Pradesh on 1 January 2015?
19. Natalie Cole, who has been recently passed away was related to which of the following field ?
20. National Remote Sensing Centre (NRSC) on 1 January 2016 signed a MoU with which bank for web-based monitoring of watershed management projects?
21. On 1st January every year, India exchange list of nuclear installations with which Nation that bars them from attacking each other’s atomic facilities ?
22. Qatar Masters Open chess tournament has been clinched by which of the following ?
23. Recently National Bank for Agriculture and Rural Development (NABARD) has signed a MoU with National Remote Sensing Center (NRSC). NABARD head office is located in which city ?
24. Riyal is the currency of which country ?
25. SEBI has recently kicked in a new form for ASBA. What does ASBA stand for?
26. The 21st INCOFYRA (International Conference on Frontiers in Yoga Research and its Applications) is hosted by which of the following cities?
27. The Union Government on 1 January 2016 signed a Financing Agreement of 50 million US dollars with which bank for education and training of minorities?
28. Union Government on 1 January 2016 declared 2016 as the year of
29. Which bank has launched host of digital banking solutions including green PIN and enrichment of its mobile app ?
30. Which committee was constituted by Union Government on 1 January 2015 for holistic interpretation of the provisions of the Cinematograph Act, 1952?
31. Which country has signed a new anti-terror law allowing members of security forces to open fire on suspects who are women, children and disabled?
32. Which of the famous Marathi poet who received the Padma Bhushan, passed away on 30th December 2015?
33. Which of the following cities is the host for the 103rd Indian Science Congress (ISC)?
34. Which of the following countries has won the SAFF Suzuki Cup 2015?
35. Which of the following has become the first Indian state to legally accept Electronic motor insurance policies ?
36. Which of the following Indian state has instigated Investment Promotion Board (IPB) for fast approvals to industrial proposals ?
37. Which of the following Indian state has signed an MoU with private helicopter service company Pawan Hans to boost tourism ?
38. Which of the following state governments has launched the Janma Bhoomi – Maa Vooru programme?
39. Which of the following states became the first state in the country to accept electronic motor insurance policies?
40. Which of the following states celebrate the Raja Rani Music Festival?
41. Which of the following states has launched Amma Seeds scheme?
42. Which of the persons has been appointed as new Director General of Uttar Pradesh police?
43. Which of the persons has received Knighthood from Britain's Queen Elizabeth II?
44. Which of the projects has won the 2015 eASIA Award under Trade Facilitation category by AFACT?
45. Which of the states has launched the second phase of operation smile?
46. Which state Police has enters Limca Book of Records for solving India’s biggest cash heist case ?
47. Which state will host Science Film Festival of India in January 2016?
48. Who among the persons has announced his resignation from the post of Chairman of IIM-A Board?
49. Who among the persons has appointed as Chief Operating Officer of nexGTV?
50. Who among the persons has assumed charge as Chairman and Managing Director of BHEL?
51. Who among the persons has assumed charge as Chairman and Managing Director of Cochin Shipyard?
52. Who among the persons has been selected as the Cricketer of the Year 2015 by BCCI?
53. Who among the persons has been selected as the number one Test bowler and all-rounder in the ICC rankings for 2015?
54. Who among the persons has laid the foundation stone of ambitious Delhi-Meerut Expressway project?
55. Who among the persons has launched the National Biotechnology Programme?
56. Who has taken over as Deputy Chief of Air Staff on 1st January 2016?
57. Who of the following has been appointed as the CMD of Bharat Heavy Electricals Limited (BHEL)?
58. Who on 1 January 2016 assumed the charge of Secretary General of International Sericultural Commission (ISC)?
59. Who was appointed as the Chairman and Managing Director (CMD) of Bharat Heavy Electricals Ltd (BHEL) on 1 January 2016?
60. Who was appointed as the Director General of Police of Manipur on 1 January 2016?
61. Who was conferred with the 2015 Sangita Kalanidhi award on  1 January 2016?
62. With which country did India renewed its relationship in the field of education in the last week of December 2015?

Current Affairs January 2016 Questions and Answers Set -2

Keywords: Current Affairs MCQ, Current Affairs Mock Test, Current Affairs, Current Affairs Free Online Test, Online Test, Banking, Railways, NDA, SSC, SSC CGL, IBPS, IBPS PO, IBPS Clerk, SSC CHSL, CDS, SCRA, UPSC, SBI Clerk, SBI PO, CTET, IBSP SO, RBI, RBI Assistant, IAS, RRB, competitive exams, quiz, mock test, online test, jobs, Multiple Choice Questions Answers, Bank Exams, Job Seekers, Current Affairs 2016.

Read More

Current Affairs MCQ Quiz – January 2016 – Set1

Current Affairs Quiz

Please get ready to face any competitive exam with the latest current affairs updates. The following multiple choice questions are covered in this online free current affairs quiz for January 2016 (01-01-2016).

Click on this image to take online exam.

Current Affairs Questions and Answers:

Current Affairs 2016 questions answers online mock test quiz for students. Get latest updates on current affairs to face any competitive exams.

1. ________inaugurates bio-CNG plant?
2. ________launches host of digital banking solutions.
3. _______records 50% sales growth in 2015.
4. Airtel has acquired which company that has now become its wholly owned subsidiary on 29th December 2015?
5. Bharat Heavy Electricals Ltd(BHEL) has appointed which of the following as its chairman and managing director (CMD) ?
6. Cabinet clears formation of JVs between Indian Railways and states with an initial paid-up capital of how much worth ?
7. Cabinet Committee on Economic Affairs has approved an increase in the budget for implementation of grid-connected solar rooftop systems to how much amount ?
8. Chief Minister J Jayalalithaa has launched the scheme________, for farmers.
9. Department of Commerce’s DAVA has won the 2015 eAsia award under trade facilitation category from AFACT. What does DAVA stand for?
10. eASIA Award 2015 has conferred DAVA (Drug Authentication and Verification Application) project under which of its category ?
11. GoI recently released the MTDS to better manage public borrowings. What does MTDS stand for?
12. Government has formed a committee to review pay structure and social security benefits provided to GraminDakSevaks. It will be headed by which of the folowing ?
13. Govt has constituted a committee for holistic interpretation of the provisions of the Cinematograph Act and Rules. It will be headed by which of the following ?
14. Growth in 8 core sectors of the economy declined to what percent in November?
15. How many countries are members of the ASEAN Economic Community (AEC)?
16. Howard Davis was a/an______.
17. Ian Fraser Lemmy Kilmister, who has been recently passed away was related to which of the following field ?
18. Ian Murdock who recently passed away on 28th December 2015 was known for finding which commercial Linux company?
19. Ian Murdock, who passed away recently, was the founder of which open-source project?
20. India and ______ exchanged list of nuke installations, prisoners.
21. India’s biggest state owned gas importer Petronet LNG has signed a revised contract with______.
22. India’s first underwater tunnel to be set up in which state ?
23. Indian Air Force (IAF) has appointed which of the following as its Deputy Chief of the Air Staff (DCAS) ?
24. Indian cricketer and Bengal all-rounder Laxmi Ratan Shukla announced his retirement from all forms of cricket on 30th December 2015. For which trophy in 2013 was he made the captain of Bengal?
25. Indian origin cancer research expert Harpal Singh Kumar received which honour from Queen Elizabeth II on his work for prevention and treatment of cancer?
26. LPG emergency helpline number _______launched.
27. LRSAM co-developed by India and Israel was successfully test fired on 30th December 2015. What does LRSAM stand for?
28. Natalie Cole who died at 65 was a/an_______.
29. PM unveils plaque for Foundation Stone of_______ Expressway.
30. RBI asked State Level Bankers’ Committee (SLBC) to open banks in villages with a population more than of how many numbers ?
31. Securities and Exchange Board of India proposed fresh norms for public issues of REITs. What are REITs?
32. Swedish Bjorn Isberg has been appointed as the tournament director of which premier hockey league for India?
33. UK’s £2 coins will feature which of the following writer’s portrait ?
34. Union Ministry for Science & Technology and Earth Sciences launched the NBDS 2015-2020. What does NBDS stand for?
35. Which among the following set to launch in India?
36. Which Country has created three new military bodies?
37. Which Country have started first nuclear reactor in ethnic minority region?
38. Which Indian cricketer has ended 2015 as the number one Test bowler and all-rounder ?
39. Which Metro gets first set of trains from Alstom?
40. Which nation has beaten China as the fastest growing economy in 2015?
41. Which of the following committees has been set up to review wage structure of Gramin Dak Sevaks?
42. Which of the following committees is formed to suggest changes in the Cinematograph act?
43. Which of the following has won gold in Men’s 65kg in National Wrestling Championship ?
44. Which of the following has won gold in Women’s 58kg in National Wrestling Championship ?
45. Which of the following organisations has extended a 50 million dollar loan for the Nai Manzil project?
46. Which of the following projects has won the 2015 eASIA Award?
47. Which of the following space agencies has suspended the 2016 InSight Mars mission?
48. Which telecom company has acquired 100 per cent stake in Augere Wireless ?
49. Who has been appointed as the new Bharat Earth Movers Ltd.(BEML) CMD?
50. Who has been approved as the DG of National Centre for Good Governance on 30th December 2015?
51. Who has received official credit for the discovery of element 113?
52. Who of the following has been conferred with 2015 Sangita Kalanidhi award?
53. Who of the following has been named BCCI Cricketer of the Year 2015?
54. Who of the following has been selected for Kerala Tourism’s Nishagandhi Puraskaram 2016?
55. Who took over as Deputy Chief of the Air Staff?
56. Who was awarded 2015 Sangita Kalanidhi Award?

Current Affairs January 2016 Questions and Answers Set -1

Keywords: Current Affairs MCQ, Current Affairs Mock Test, Current Affairs, Current Affairs Free Online Test, Online Test, Banking, Railways, NDA, SSC, SSC CGL, IBPS, IBPS PO, IBPS Clerk, SSC CHSL, CDS, SCRA, UPSC, SBI Clerk, SBI PO, CTET, IBSP SO, RBI, RBI Assistant, IAS, RRB, competitive exams, quiz, mock test, online test, jobs, Multiple Choice Questions Answers, Bank Exams, Job Seekers, Current Affairs 2016.

Read More

Tally Interview Questions Answers Quiz

Tally.ERP 9 - the latest evolution of the Tally series-took 3 years and the dedicated efforts of 200 developers to create. It has grown from a basic accounting software package into a simple-yet-sophisticated business management software product. Comprehensive capabilities allow Tally.ERP 9 to meet the needs of small to large businesses with dispersed operations. And traditional functions of a business are handled as capably as the more advanced.

Well, Tally is a complete Enterprise Resource Planning system with a excellent grip in accounting features. Although it has many more core features that a business requires but its hold in accounting is truly commendable. Therefore it is known more for accounting rather than any other of its features.

For example, if you are starting out a general store, what would you require?

1. Accounting
2. Billing
3. Sales and profit analysis
4. Banking
5. Inventory
6. Taxation (VAT, TDS, TCS)

Are you preparing for an interview to start your career in Finance and Accounting Field?

Please practice the following free Questions and Answers to get ready for interview.

Tally Questions and Answers Set -1

Tally Questions and Answers Set -2

Tally Questions and Answers Set -3

Tally Questions and Answers Set -4

The following MCQ questions are covered in above mock tests.

1. A Ledger can't be deleted if it is caring Opening Balance
2. We can't select cash in Journal Voucher
3. Memorandum Voucher does not affect Books of Accounts.
4. There is no difference between Shut Company & Delete Company.
5. BOM represents Bill of Materials.
6. Tally package is developed by
7. We can change the Company Information from
8. Company Restore option is available in
9. In general the Financial year from shall be from
10. We can Modify an existing Company from
11. To change Current Date from Gateway of Tally press the key
12. Party account can be created through
13. A ledger may get declaration space for its Alias through
14. F12 is known as
15. What is the utility of Tally Vault Password?
16. We can show Bill wise details of Debtors and Creditors by activating
17. The shortcut key to quit from Tally is
18. How many inbuilt Accounts group are in tally by default?
19. The shortcut used to activate calculator is
20. Suspense Account Group is defined under
21. To activate MRP feature from Gateway of Tally initially we need to press
22. MRP formula for inclusive of vat is
23. Manufacturing Journal creates based on
24. To create Manufacturing Journal which option must be activated
25. How many types of Measurement Units we can create in Tally?
26. To activate Job Costing which options require to be activated?
27. Multiple Godowns are activated from
28. There are _________ predefined ledgers
29. We can see list of Memorandum Vouchers from
30. To print a voucher from Tally we need to press
31. We can see Working Capital figure changing
32. Input Vat Ledger is created under which account?
33. We can create multiple users in Tally activating
34. “Allow components list details (Bill of Materials)” option is activated for
35. Retained Earnings is an alias of
36. We can repeat narration by pressing
37. What is MRP?
38. We can use Stock Journal for
39. Discount Column is available in
40. We can get the report of Interest from
41. We can cancel a voucher using
42. To see reports of Job Work Analysis
43. For reconciliation of Bank press
44. To create Scenario which option require to be activated?
45. Optional Voucher is one type of
46. TDS deduction entry can be made through
47. To create Purchase Order press
48. List of Optional Voucher we can get from
49. Input Vat Credit on Capital goods should be defined under
50. Single Entry mode is applicable for
51. Online voucher creation from Day Book report by pressing
52. Reversing journal is a
53. To hide the name of the Company you need to define
54. To declare a voucher as Post Dated press
55. We can switch from Accounting Voucher to Inventory Voucher pressing
56. Goods returning to a Creditor after challan but before bill we need to pass
57. Branch / Division is a group defined under
58. To use Dr/Cr instead of To/By during Voucher entry or vice versa, Press
59. For Export of Data from Company to Company Tally uses
60. Voucher class is a pre defined voucher type that helps to
61. To alter a master while making an entry or viewing a report
62. To view the TDS report go to
63. To show the cheque number while reconciling Bank Accounts press
64. Data Folder of a Company consists of
65. Total number of Ledgers, Groups, Entries etc. can be shown from
66. Voucher Class for Interest calculation created based on
67. ETCS means
68. What is TAN?
69. To get Payroll Reports choose
70. Payroll Auto fill is done through
71. To see Gratuity Reports go to
72. At the time of Branch Transfer, Sales ledger is created under which Vat/TaxClass?
73. To remove a line at all reports screen, shortcut is
74. How can we see Vat Reports?
75. BOM represents
76. What is the full form of TCS?
77. The shortcut used for Sales Order is
78. Bank OCC a/c is a group defined under
79. Sales Tax Ledger falls under which Group?
80. Alias represents
81. To change the date, shortcut used
82. If we purchase any Fixed asset in credit, we can pass it from
83. To save entry without any amount, we have to use
84. To see the report of Unconventional vouchers go to
85. The shortcut used for Optional vouchers is
86. Transfer of materials from one godown to another godown, use
87. Recording of actual stock as physically verified or counted is done through
88. Predefined Billing terms can be maintained through
89. How many formats are available while Exporting?
90. While exporting Ledgers from Tally to Web Page, we use
91. Budget represents ……………………
92. To see any report in detailed way, press
93. In Service tax Credit Adjustment (%) should be either
94. Service Tax Report can be seen from
95. Can we allow Expenses/Fixed Assets in Purchase vouchers?
96. Transfer from Main Cash to Petty Cash you require to pass ……………… voucher.
97. If the Financial Year from is 1st April 2005 and the Books Beginning from is 1stJanuary 2006 then what will be the Closing Date?
98. Income Tax number of the Company will appear in which report?
99. Patent account falls under
100. Find out which is not a Default Ledger in Tally.

Read More

Oracle Certified Associate, MySQL 5 - 1Z0-870 Online Test Set-1

OCA MySQL5 Certification

The Oracle Certified Associate, MySQL 5 certification is intended for candidates relatively new to using the MySQL database server. The exam 1Z0-870 covers basic database management system concepts and basic SQL.

The topics covered include: Theory, Terminology and Concepts Data Definition using SQL Basic Data Manipulation using SQL Advanced Data Manipulation using SQL Transactions Import/Export We give you knowledge information relevant to the exam specifications. To be able to succeed in the real exam, you’ll need to apply your earned knowledge to the question scenarios. This Exam focuses on the more difficult topics that will likely make a difference in exam results.

The 1Z0-870 Questions & Answers covers all the knowledge points of the real exam. We update our product frequently so our students and aspirants can always have the latest version of the questions and answers.

Questions Covered:


1} Adam works as a Database Administrator for Cashmyiq.com. He creates a table named Students. He wants to create a new table named Class with the help of the Students table. Which of the following syntaxes will Adam use to accomplish the task?

2} You work as a Database Administrator for Cashmyiq.com. The company uses MySQL as its database. You have created two tables named Employees and Departments in the database. Now, you want to display data from both tables. Which of the following actions will you perform to accomplish the task?

3} Which of the following terms is described in the statement below? "It is procedural code that is automatically executed in response to certain events on a particular table or view in a database."

4} You work as a Database Administrator for cashmyiq.com. The company uses MySQL as its database development platform. You have created a table named Employees in the database. You want to display the names of the employees whose salary is more than 5000, but you do not want to display any duplicate content. Therefore, you have written the following query: SELECT emp_id, DISTINCT emp_name WHERE salary > 5000 FROM Employees; Which of the following statements is true about the above query?

5} You work as a Database Administrator for cashmyiq.com. The company uses MySQL as the database platform. You have created a table named Students in the database. The structure of the table is as follows: Stu_ID NUMBER (3) PRIMARY KEY Stu_Name VARCHAR2 (25) NOT NULL Fee NUMBER (8, 2) Class NUMBER (5); You have executed the following statement for the table ""Students"": SELECT e.Stu_Name, m.Fee FROM Students e, Students m WHERE e.Stu_ID = m.stu_ID; Which of the following join types have you used in the above statement?

6} You work as a Database Administrator for cashmyiq.com. The company uses MySQL as its database. You have created a new table named Employees, which keeps all the information of the employees. You want to add a new row to the Employees table. Which of the following statements will you use to accomplish the task?

7} Which of the following statements is correct for equijoin used to join two tables named Employees and Department?

8} Which of the following properties of concurrency control refers to the requirement that other operations cannot access or see the data in an intermediate state during the execution of a transaction?

9} Consider the exhibit given below: Which of the following queries will return the name of the customer who placed the highest amount of orders and the total order amount?

10} You work as a Database Administrator for cashmyiq.com. The company uses MySQL as its database. You have created a table named Employees in the database. You want to create a list of employees working in the organization, but you do not want to display any duplicate row in the report. Which of the following statements will help you to accomplish the task?

11} Adam works as a Database Administrator for cashmyiq.com. The company uses MySQL as its database. Adam has created a table named Employees in the database. He wants to retrieve the information of those employees who have at least one person reporting to them. Which of the following queries will Adam execute to accomplish the task?

12} You work as a Database Administrator for cashmyiq.com. The company uses MySQL as its database. The database contains a table named Employees. You want to remove an index named Emp_name_idx from the Employees table. Which of the following statements should you use to accomplish the task?

13} You work as a Database Administrator for Cashmyiq.com. The company uses the MySQL database. You have created a table named Employees. The table contains the following structurE. The company has three departments. A task has been assigned to you to calculate the sum of the average length of employees' last name per department. Which of the following queries will you execute to accomplish the task?

14} Which of the following are true about UPDATE statements? Each correct answer represents a complete solution. Choose all that apply.

15} Which of the following are the types of numeric literals that can be used in arithmetic expressions? Each correct answer represents a complete solution. Choose all that apply.

16} You work as a Database Administrator for Cashmyiq.com. The company uses MySQL as its database. You have written two statements, which are as follows: 1. SELECT DISTINCT OBJECT_TYPE FROM USER_OBJECTS; 2. SELECT OBJECT_TYPEFROM ALL_OBJECTS; Which of the following options explains the difference between the results of these two statements? Each correct answer represents a complete solution. Choose all that apply.

17} Which of the following will be true about a table column if you plan to create an index on that column? Each correct answer represents a complete solution. Choose all that apply.

18} You work as a Database Administrator for Cashmyiq.com. The company uses the MySQL database. You have created a new table named Employees in the database and performed update operation but you got an error because of the last transaction. Now, you want to terminate the last transaction. Which of the following commands can you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

19} Which of the following statements will delete all the records from the table T1? Each correct answer represents a complete solution. Choose all that apply.

20} You work as a Database Administrator for Cashmyiq.com. The company uses MySQL as its database. You want to use group functions, so you have decided to put an alias of group functions as 'GP'. Which of the following are the correct ways to use group functions? Each correct answer represents a complete solution. Choose all that apply.

21} Adam works as a Database Administrator for Cashmyiq.com. Adam has created a table named Students. In this table, Adam wants to create a column to store the fees of students. Which of the following data types will Adam use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

22} Fill in the blank with the appropriate word. The ________data type defines a date that is combined with a time of day along with fractional seconds that is based on a 24-hour clock.

23} Fill in the blank with the appropriate word. A ______specifies that the value of a column (or columns), upon which the index is based, must be unique.

24} A______ provides a concise and flexible means for matching strings of text, such as particular characters, words, or patterns of characters.

25} Drag and drop the correct constraint types to their corresponding specifications

Read More

Tell Me About Yourself - HR Interview

Tell me about yourself

The following links will help you to know about the best answers related to HR personal interview question and most commonly asked question "Tell me about yourself".

Top Ten answers: 

1) Tell me about yourself best answers from www.cashmyiq.com
2) Tell me about yourself best answers from www.talkenglish.com
3) Tell me about yourself best answers from www.forbes.com
4) Tell me about yourself best answers from www.youtube.com
5) Tell me about yourself best answers from www.monster.com
6) Tell me about yourself best answers from www.job-hunt.org
7) Tell me about yourself best answers from www.indiabix.com

Read More