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

How To improve system redundancy using its grid architecture, where in the XIV System can a partition be mirrored?

A) on same disk in different modules B) on disks in other modules
C) on different disks in the same module D) on same disk, in same module, and in different modules
 
Answer & Explanation Answer: B) on disks in other modules

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

1 2806
Q:

Economic liberalization in India started with ___________.

A) substantial changes in industrial licensing policy   B) convertibility of Indian rupee  
C) doing away with procedural formalities for foreign direct investment D) significant reduction in tax rates  
 
Answer & Explanation Answer: A) substantial changes in industrial licensing policy  

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian Economy
Exam Prep: Bank Exams

1 2806
Q:

What is true about economic resources?

A) Economic resources are limited. B) Economic resources are always controlled by the government.
C) Economic resources include only money. D) Economic resources exist only at the individual level.
 
Answer & Explanation Answer: A) Economic resources are limited.

Explanation:

Economic resources are those goods and services that can be converted into valuable products for individual and business purposes.

There are four major types of economic resources:

1. land,

2. labor,

3. capital and

4. entrepreneurship.

 

Land and labor are natural and human resources, while capital means physical resources or money.

Entrepreneurship converts these resources into usable goods.

 

However, resources have finite values, and proper utilization depends on economic systems and economic decisions.

Report Error

View Answer Report Error Discuss

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

2 2805
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 2805
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 2803
Q:

Which of the following is NOT a social development scheme launched by the Government of India

A) Indira Awas Yojana B) Kutir Jyoti
C) LookEast Policy D) Operation Black Board
 
Answer & Explanation Answer: C) LookEast Policy

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Indian Economy

2 2803
Q:

Which state government banned the sale of 'High in Fat, Salt and Sugar' (HFSS) food in school canteens across the state  ?

A) Rajasthan B) Maharashtra
C) Odisha D) Haryana
 
Answer & Explanation Answer: B) Maharashtra

Explanation:

The Maharashtra government banned the sale of 'High in Fat, Salt and Sugar' (HFSS) food in school canteens across the state. Furthermore, schools have been asked to replace the junk food items with healthy food such as whole grain, home-made rotis, parathas, rice, etc. The government will form a committee to conduct regular checks on schools.

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness

1 2803