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?

Edit

Explanation

Define Create Table as Select
  • 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?

Edit

Explanation

Procedure Oriented Languages and Object Oriented Language
Procedure oriented languageObject oriented language
Divided into small parts called functionsDivided 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.