Bissoy.com
Doctors Medicines MCQs Q&A

In SQL, we can insert rows in a view in a similar way as we insert them in a table.

In SQL, we can insert rows in a view in a similar way as we insert them in a table. Correct Answer True

In SQL, we can insert rows in a view in a similar way as we insert them in a table i.e. by using the INSERT command. But all the NOT NULL columns from the base table must be included in the view in order for the INSERT command to function.

Related Questions

S1: The right way to get people do things the way you want is not to compel them, drive them or for that matter even beg them or entreat them.
P: The sure way to antagonise an individual is to give him the impression that you are out to force or compel him to do something.
Q: The correct way is, therefore, to arouse a want in them and make them do, whatever you want them to do willingly, happily and eagerly.
R: It is the most difficult thing in the world to make an individual do anything against his will.
S: Even young, innocent children resent being made to do things.
S6: The secret of motivation, therefore, lies in your ability to arouse the right kind of want or thirst in the other people.

The Proper sequence should be:
Find the error in the following SQL statement?
CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, LAST) VALUES(1,’s’,’p’);
Read the given seating arrangement information and answer the question that follows. Prashant, Kamal, Rishi, Sunita, Tanvi, Vimal, Wazir and Yogita are sitting at a square table in such a way that four of them are sitting at four corners of the table, while the other four are sitting in the middle of each of four sides of the table. The four who are sitting at the corners of the table are facing the centre, whereas those who are sitting in the middle of the sides of the table are facing outside. Prashant, who is facing the centre, is sitting third to the right of Vimal. Tanvi, who is facing the centre, is not an immediate neighbour of Vimal. Only one person is sitting between Vimal and Wazir. Sunita sits second to the right of Kamal. Kamal is facing the centre. Rishi is not an immediate neighbour of Prashant. Which of the following statements regarding Kamal is true?
Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is . . . . . . . 
SELECT tbl_1.i1, tbl_2.i2FROM tbl_1 INNER JOIN tbl_2WHERE tbl_1.i1 = tbl_2.i2;
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;
When all the students in a school are made to stand in rows of 54, 30 such rows are formed. If the students are made to stand in rows of 45, how many such rows will be formed ?
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
Read the passage carefully and choose the best answer to each question out of the four alternatives and click the button corresponding to it. Awareness means the capacity to see a coffee pot and hear the birds sing in one's own way, and not the way one was taught. It may be assumed on good grounds that seeing and hearing have a different quality for infants than for grownups and that they are more aesthetic and less intellectual in the first years of life. A little boy sees and hears birds with delight. Then the 'good father' comes along and feels he should 'share' the experience and help his son 'develop'. He says, "That's a jay and this is a sparrow." The moment the little boy is concerned with which is a jay and which is a sparrow, he can no longer see the birds or hear them sing. He has to see and hear them the way his father wants him to. Father has good reasons on his side: since few people can afford to go through life listening to the birds sing, sooner the little boy starts his 'education' the better. Maybe he will be an ornithologist when he grows up.
How do children perceive things around them?
There are 500 seats in Hyatt conference hall, Mumbai, placed in similar rows. After the reconstruction of the hall, the total number of seats became 10% less. The number of rows was reduced by 5 but each row contained 5 seats more than before. How many rows and how many seats in a row were there initially in the hall? 
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?