3i Infotech Placement: Sample Questions 784 - 785 of 1245
Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.
Question 784
Describe in Detail Essay▾
What command is used to create a table by copying the structure of another table?
EditExplanation
- CREATE TABLE … . AS SELECT command creates a table by copying the structure of another table.
- If WHERE clause of the SELECT command contains a FALSE statement- the statement only copies structure:
CREATE TABLE NEWTABLE AS SELECT ⚹ FROM EXISTING TABLE WHERE 1 = 2;
- The where condition is true, then all the rows satisfying the condition will be copied to the new table.
- SQL SELECT statement retrieves data from a table in the database.
- Query may retrieve information from specified columns or from all rows in the table.
Question 785
Describe in Detail Essay▾
What are the main differences between procedure oriented languages and object oriented language?
EditExplanation
Procedure oriented language | Object oriented language |
Divided into small parts called functions | Divided into parts called objects. |
Follows top down approach. | Follows bottom up approach. |
Does not have any access specifiers. | Access specifiers are named public, private, protected, etc. |
Adding new data and function is not easy. | Provide an easy way to add new data and function. |
Overloading is not possible. | Overloading is possible in the form of function overloading and operator overloading |
Example: C, VB, FORTRAN, Pascal. | Example: C ++ , JAVA, VB. NET, C#. NET. |