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

In 8085 which is called as High order / Low order Rigister?

Answer

Flag is called as Low order rigister & Accumulator is called as High order Rigister.

Report Error

View answer Workspace Report Error Discuss

Subject: Hardware

1 2379
Q:

Which of he following Chief Minister has been selected for the award of ‘Transformative Chief Minister’ by The US India Business Council ?

A) N. Chandrababu Naidu B) Devendra Fadnavis
C) K. Chandra Shekar Rao D) Mamata Banerjee
 
Answer & Explanation Answer: A) N. Chandrababu Naidu

Explanation:

Chief Minister of Andhra Pradesh, N Chandrababu Naidu has been selected for another prestigious award. The US India Business Council has selected the CM for award of ‘Transformative Chief Minister’ and Naidu would be receiving coveted award at second annual West Coast summit which to be held in California on May 8, 2017.

Report Error

View Answer Report Error Discuss

Filed Under: General Awareness
Exam Prep: Bank Exams

2 2379
Q:

Closely stacked flattened sacs (plants only)

A) Vacuoles B) Lysosomes
C) Golgi apparatus D) None of the above
 
Answer & Explanation Answer: C) Golgi apparatus

Explanation:
Report Error

View Answer Report Error Discuss

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

4 2379
Q:

Which statement fragments a table as round robin?

A) FRAGMENT AS ROUND ROBIN IN dbspace 1, dbspace 2 B) FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
C) FRAGMENT TABLE BY ROUND ROBIN IN dbspace1, dbspace 2 D) FRAGMENT BY ROUND ROBIN
 
Answer & Explanation Answer: B) FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

2 2378
Q:

What would be the output of the following program?

main()

{

     char ch ='A';

      printf ("%d%d", sizeof (ch), sizeof ('A'));

}

Answer

1   2

Report Error

View answer Workspace Report Error Discuss

Subject: Programming

0 2377
Q:

Head Quaters of NATO is located in 

A) Newyork B) Brussels
C) Alaska D) California
 
Answer & Explanation Answer: B) Brussels

Explanation:

Head Quaters of NATO is located in Brussels

Report Error

View Answer Report Error Discuss

Filed Under: World Organisations

5 2376
Q:

What is made of water but if you put it into water it will die?

Answer

An Ice Cube is what made of water and will die if we put it in water.

Report Error

View answer Workspace Report Error Discuss

Subject: Logic Puzzles Exam Prep: Bank Exams

6 2375