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

Sun life of Canada is operating in India in alliance with

A) AB Birla Group B) Sahara Group
C) Bermans D) Thapars
 
Answer & Explanation Answer: A) AB Birla Group

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Business Awareness

7 2802
Q:

There are five boxes in a cargo hold. The weight of the first box is 200 kg and the weight of the second box is 20% higher than the weight of the third box, whose weight is 25% higher than the first box’s weight. The fourth box at 350 kg is 30% lighter than the fifth box. Find the difference in the average weight of the four heaviest boxes and the four lightest boxes.

A) 51.5 kg B) 75 kg
C) 37.5 kg D) 112.5 kg
 
Answer & Explanation Answer: B) 75 kg

Explanation:
Report Error

View Answer Report Error Discuss

0 2802
Q:

What are the basic expansion card types?

Answer

The basic expansion card types in A+ Hardware certification are ISA and PCI, ISA these can be used only on XT, AT and ATX boards. The industry now considers ISA obsolate.

Report Error

View answer Workspace Report Error Discuss

Subject: Hardware

0 2802
Q:

The longest sea beach in India is

A) Chapora beach B) Diu beach
C) Aksa beach D) Marina beach
 
Answer & Explanation Answer: D) Marina beach

Explanation:
Report Error

View Answer Report Error Discuss

2 2802
Q:

Which of the following contributed to the failure of prohibition?

A) it was not imposed strictly on immigrants B) many americans didnt consider drinking to be a crime
C) it adversely affected american productivity D) organized crime controlled illegal alcohol production
 
Answer & Explanation Answer: D) organized crime controlled illegal alcohol production

Explanation:

Crime connected with illegal alcohol production and sale became a major issue so that even many people who had originally supported Prohibition decided that it needed to be repealed.

Report Error

View Answer Report Error Discuss

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

0 2802
Q:

' The Sikhs of New York ' organised the " Turban Day " at Times Square on which date?

A) March 15, 2017 B) April 11, 2017
C) March 14, 2017 D) April 15, 2017
 
Answer & Explanation Answer: D) April 15, 2017

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Important Days and Years
Exam Prep: Bank Exams , CAT
Job Role: Bank Clerk

3 2801
Q:

A basic concept in economics is that all resources are

A) Valuable B) Limited
C) Renewable D) Allocated
 
Answer & Explanation Answer: B) Limited

Explanation:

The basic concept in economics is that all resources are limited.

Report Error

View Answer Report Error Discuss

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

1 2801