Questions

Q:

What are the different types of SQL statements ?

Answer

SQL statements are broadly classified into three. They are


1. DDL – Data Definition Language


DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.


2. DML – Data Manipulation Language


DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.


3. DCL – Data Control Language


DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

Report Error

View answer Workspace Report Error Discuss

4 2766
Q:

The shape of the nucleus is maintained by

A) the nuclear lamina B) the nuclear envelope
C) the nucleolus D) the endoplasmic reticulum
 
Answer & Explanation Answer: A) the nuclear lamina

Explanation:

The shape of the nucleus is maintained by the nuclear lamina.

Report Error

View Answer Report Error Discuss

Filed Under: General Science
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 2766
Q:

For intra-State movement, the e-way bill by GST council will be rolled out in a phased manner beginning April 15 and will cover all the States by

A) May 1 B) June 1
C) May 31 D) July 31
 
Answer & Explanation Answer: A) May 1

Explanation:

For intra-State movement, the e-way bill will be rolled out in a phased manner beginning April

15 and will cover all the States by June 1. Businesses will continue to file summary sales return

GSTR-3B until June as the GST (Goods and Services Tax) Council has extended the present

system of return-filing by three months. Electronic way or e-way bill for movement of goods

between States would be implemented from April 1.

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 2766
Q:

The delegate who created the compromise for the constitution was

A) Alexander Hamilton B) William Paterson
C) James Madison D) Roger Sherman
 
Answer & Explanation Answer: D) Roger Sherman

Explanation:

Roger Sherman, is the delegate who created the compromise for the U.S constitution.

the_delegate_who_created_the_compromise_for_the_constitution_was1537502237.jpg image

Report Error

View Answer Report Error Discuss

Filed Under: Famous Personalities
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

2 2765
Q:

The Limitation Law, which passed by the British in 1859, addressed which one of the following issues?

A) Loan bonds would not have any legal validity B) Loan bonds signed between money lender and Ryots would have validity only for three years
C) Loan bonds could not be executed by money lenders D) Loan bonds would have validity for ten years
 
Answer & Explanation Answer: B) Loan bonds signed between money lender and Ryots would have validity only for three years

Explanation:

The ryots came to see the moneylender as devious and deceitful. They complained of moneylenders manipulating laws and forging accounts. In 1859 the British passed a Limitation Law that stated that the loan bonds signed between moneylenders and ryots would have validity for only three years. This law was meant to check the accumulation of interest over time. The moneylender, however, turned the law around, forcing the ryot to sign a new bond every three years.

Report Error

View Answer Report Error Discuss

Filed Under: Indian History
Exam Prep: Bank Exams

0 2764
Q:

Controlling marketing activities :

What is annual plan control? Why is it needed in an organisation?

Answer

The annual plan control is one of the four types of marketing control system. Annual plan control is essential in order to determine whether all the marketing efforts undertaken by the organisation has been really worthwhile or not. It aims to achieve sales volume,profits and all those objectives which have been set up in the beginning of the year. In an organisation,the top management and middle level management are responsible for the annual plan control. They have to keep a check on the activities undertaken to implement the plans.


 


 

Report Error

View answer Workspace Report Error Discuss

0 2762
Q:

Each degree of latitude is equals to

A) 112 kms B) 111 kms
C) 110 kms D) 101 kms
 
Answer & Explanation Answer: B) 111 kms

Explanation:

The each degree of latitude is equals to 111 kms approx (69 miles). As Earth is lightly ellipsoid in shape it changes at equator and poles from 110.5 kms to 111.7 kms respectively.

Report Error

View Answer Report Error Discuss

Filed Under: Indian Geography
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

14 2762
Q:

In the following question, a sentence has been given in Direct/Indirect speech. Out of the four alternatives suggested, select the one, which best express the same sentence in Indirect/Direct speech.
Mother said, "Lie down, Arjun."

A) Mother told lie down Arjun. B) Mother told Arjun for lying down.
C) Mother asked Arjun to lie down. D) Mother asked Arjun to be lied down.
 
Answer & Explanation Answer: C) Mother asked Arjun to lie down.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

0 2761