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 2791
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 2791
Q:

Correct word of ahmpabja?

Answer

ABP Majha is the correct word of the given jumbled word.

Report Error

View answer Workspace Report Error Discuss

Subject: English Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO

0 2791
Q:

Which has the lowest freezing point?

A) Mercury B) Helium
C) Cesium D) Aluminium
 
Answer & Explanation Answer: B) Helium

Explanation:

Helium has the lowest freezing point of all the elements. When coming to metals, mercury has the lowest freezing point of all the metals.

Report Error

View Answer Report Error Discuss

Filed Under: Chemistry
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , IT Trainer

2 2790
Q:

Answer the following Program

#define CHARSIZE 8

#define MASK(y) (1 << y % CHARSIZE)

#define BITSLOT (y) (y / CHARSIZE)

#define SET(x,y) ( x[BITSLOT(y)] = MASK(y) )

#define TEST(x,y) ( x[BITSLOT(y)] & MASK(y) )

#define NUMSLOTS(n) ((n + CHARSIZE - 1) / CHARSIZE)

 

Give the above macros how would you

1. declare an array arr of 50 bits

2. put the 20th bit on

3. test whether the 40th bit is on or off

Answer

1. char arr[NUMSLOTS(50)];


2. SET (arr, 20);


3. if (TEST (arr, 40))

Report Error

View answer Workspace Report Error Discuss

Subject: Programming

0 2790
Q:

Type of government in Nigeria today?

A) Federal B) Republic
C) Presidential system D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

Nigeria, an African country on the Gulf of Guinea. 

 

Nigeria has a Federal Republic and Presidential system of Government.

Report Error

View Answer Report Error Discuss

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

1 2790
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 2789
Q:

Which among the following is not a asin country selected to the UN committee on Human rights three year term beginning january, 1995

A) Srilanka B) Pakistan
C) Phillippines D) India
 
Answer & Explanation Answer: B) Pakistan

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Organisations

3 2788