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

Kalachakra ceremony is associated with which religion?

A) Buddhism B) Islam
C) Hinduism D) Jainism
 
Answer & Explanation Answer: A) Buddhism

Explanation:

Kalachakra ceremony is associated with Buddhism. It is a way of planting a seed, and the seed will have karmic effect. One doesn't need to be present at the Kalachakra ceremony in order to receive its benefits.

Report Error

View Answer Report Error Discuss

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

18 2931
Q:

In which place India's first HIV case reported in 1986?

A) Bangalore B) Delhi
C) Hyderabad D) Chennai
 
Answer & Explanation Answer: D) Chennai

Explanation:

In Chennai, Tamil Nadu place India's first HIV case reported in 1986 amongst the female sex workers.

Report Error

View Answer Report Error Discuss

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

2 2930
Q:

Which state decided to launch Yuva Swabhiman Yojana for urban poor youth?

A) Madhya Pradesh B) Haryana
C) Himachal Pradesh D) Maharashtra
 
Answer & Explanation Answer: A) Madhya Pradesh

Explanation:

Madhya Pradesh state decided to launch Yuva Swabhiman Yojana for urban poor youth.

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

Receptors for hearing are located in the

A) Vestibule B) Tympanic membrane
C) Semicircular canals D) Cochlea
 
Answer & Explanation Answer: D) Cochlea

Explanation:

Receptors_for_hearing_are_located_in_the1537768165.jpg image

Receptors for hearing the organ of corti or the spiral organ is located in the the mammalian cochlea.

Report Error

View Answer Report Error Discuss

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

0 2929
Q:

The leader of the opposition, (in the manner he had planned to convince them,on) P (realising that he had failed to convince the) Q (assembly,who had a reputation for speech) R (making,was very much disappointed) S

The correct sequence should be

A) P S R Q B) Q S R P
C) R S Q P D) S P R Q
 
Answer & Explanation Answer: C) R S Q P

Explanation:

Since, the sentence starts talking about the leader of the opposition, the connecting statement will be R as it carries a relative pronoun ‘who’ which relates the sentences. S follows as it states the disappointment of the leader and the next statement talked about the reason of disappointment. P would be the concluding statement as it goes with the flow describing how the leader decided to convince the assembly and thus makes a coherent paragraph.

The correct formation would be, ‘The leader of the opposition who had a reputation for speech making was very much disappointed on realising that he had failed to convince the assembly in the manner he had planned to convince them’.

Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

0 2929
Q:

Improve the bracketed part of the sentence.
Father (would have been appreciated) your efforts if you had informed him.

A) would be appreciated B) would have appreciated
C) should have been appreciated D) No improvement
 
Answer & Explanation Answer: B) would have appreciated

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

0 2928
Q:

The largest region of the brain is the

A) Cerebellam B) Cerebrum
C) Medullaoblangata D) None of the above
 
Answer & Explanation Answer: B) Cerebrum

Explanation:

Cerebrum is the largest region of the brain.

the_largest_region_of_the_brain_is_the1551789656.png image

Report Error

View Answer Report Error Discuss

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

2 2928