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

The SQL statements that take care of security and authorization are

A) DDL B) DML
C) DCL D) None
 
Answer & Explanation Answer: C) DCL

Explanation:

Data Control Language takes caare of security and authorization

Report Error

View Answer Report Error Discuss

Filed Under: Software Testing

0 2749
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 2749
Q:

The blind spot of the eye is where the optic nerve leaves the eyeball.

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Everyone of us have a blind spot which is a small portion within the visual field of every eye where the optic nerve and blood vessels leave the eyeball. Optic nerve is connected to brain ehich carries images of what we see.


the_blind_spot_of_the_eye_is_where1536397433.jpg image

Report Error

View Answer Workspace Report Error Discuss

Subject: Biology
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration

0 2749
Q:

Red Cross was founded by

A) J.H.Durant B) Baden Powell
C) Tygve Lie D) Frederic Passey
 
Answer & Explanation Answer: C) Tygve Lie

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: World Organisations

0 2748
Q:

The study of trees is called

A) Histology B) Andreology
C) Sistology D) Dendrology
 
Answer & Explanation Answer: D) Dendrology

Explanation:

The study of trees is called Dendrology.

Report Error

View Answer Report Error Discuss

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

2 2748
Q:

One billionth of a second is called

A) microsecond B) picoseconds
C) millisecond D) nanosecond
 
Answer & Explanation Answer: D) nanosecond

Explanation:

A nanosecond (ns) is an SI unit of time equal to one thousand-millionth of a second or one billionth of a second.

 

  • That is, 1/1,000,000,000 of a second, or 10^−9 seconds.
Report Error

View Answer Report Error Discuss

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

1 2748
Q:

Which state has recorded highest number of tigers in 2018?

A) Karnataka B) Madhya Pradesh
C) Chhattisgarh D) Uttarakhand
 
Answer & Explanation Answer: B) Madhya Pradesh

Explanation:

India being number one in the Tiger population all over the world, Madhya Pradesh state has the highest number of tigers with 526 tigers and Karnataka is second with 524.

Report Error

View Answer Report Error Discuss

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

4 2748