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

Which IRQ does the system timer commonly use?

A) IRQ 1 B) IRQ 0
C) IRQ 3 D) IRQ 4
 
Answer & Explanation Answer: B) IRQ 0

Explanation:

IRQ-0 is the system timer commonly use in all computers. In a computer, IRQ is an interrupt request which acts as a hardware signal sent to the processor that temporarily stops a running program and allows a special program, an interrupt handler, to run instead.

Report Error

View Answer Report Error Discuss

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

3 2785
Q:

Sound waves cannot travel through

A) Gas B) Liquid
C) Vacuum D) Solid
 
Answer & Explanation Answer: C) Vacuum

Explanation:

Sound waves cannot travel through a Vacuum.

 

A vacuum is an area without any air, like space. So sound cannot travel through space because there is no matter for the vibrations to work in.

Report Error

View Answer Report Error Discuss

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

1 2785
Q:

Where is it legal to tie up your boat?

A) to a lighted buoy B) to a mooring buoy
C) to a non-lateral marker D) to a safe water marker
 
Answer & Explanation Answer: B) to a mooring buoy

Explanation:

Mooring buoy are white with a blue horizontal band. They usually are placed in marinas and other areas where boats are allowed to anchor. These are the only buoys you may tie up to legally.

buoy_mooring_can1532169062.jpg image

Report Error

View Answer Report Error Discuss

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

3 2784
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 2784
Q:

Cognitive neuroscientists can examine the brain with

A) PET & MRI B) Gama images & electrolysis
C) electrolysis & PET D) MRI & electrolysis
 
Answer & Explanation Answer: A) PET & MRI

Explanation:
Report Error

View Answer Report Error Discuss

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

3 2784
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 2784
Q:

Which gas is not produced by volcanic eruptions?

A) Methane B) carbon dioxide
C) sulfur dioxide D) hydrochloric acid
 
Answer & Explanation Answer: A) Methane

Explanation:

Many toxic gases along with water vapour are emitted in vocanic eruptions. All such toxic gases include hydrochloric acid, sulfur dioxide, carbon dioxide, hydrogen sulfide and carbon monoxide. Methane is not produced in the volcanic eruptions.

which_gas_is_not_produced_by_volcanic_eruptions1559201445.jpg image

Report Error

View Answer Report Error Discuss

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

2 2784