Bissoy.com
Doctors Medicines MCQs Q&A

Which of the following is/are true with reference to ‘view’ in DBMS? (a) A ‘view’ is a special stored procedure executed when certain event occurs. (b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query. 

Which of the following is/are true with reference to ‘view’ in DBMS? (a) A ‘view’ is a special stored procedure executed when certain event occurs. (b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query.  Correct Answer Only (b) is true

The correct answer is "option 2".

Key Points

  • A view is a virtual table that is used to view or manipulate parts of the table.
  • A view can select rows on the basis of certain conditions & fields from one or more tables present in the database is used to create a view.
  • View is not a special stored procedure but is a virtual table that occurs after executing a pre-compiled query. Hence, View in DBMS is a virtual table.

Related Questions

The following are the two statements relating to the theory of probability. Indicate the statements being correct or incorrect.
Statement I The probability of the joint occurrence of independent events A and B is equal to the probability of event A multiplied by the probability of event B or vice-versa.
Statement II The probability of the joint occurrence of independent event A and dependent event B is equal to the probability of event A multiplied by the conditionalprobability of event B when event A has occurredor vice-versa.
Point out the correct statement. * executes a Hive query and prints results to standard output b) executes a Hive query and prints results to standard output c) executes a Hive query and prints results to standard output d) All of the mentioned
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;
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
The following sentences form a paragraph. The sentences P,Q,R and S are not ordered properly.Choose the option that arranges these sentences in the proper order. P.  A person using virtual reality equipment is able to "look around" the artificial world, move around in it, and interact with virtual features or items. Q. Their aim is to simulate a user's physical presence in a virtual or imaginary environment.  R. Current VR technology most commonly uses virtual reality headsets or multi-projected environment.  S. They use sometimes in combination with physical environments or props, to generate realistic images, sounds and other sensations.
Given below are four statements- (p) The second principal focus of a lens is the position of the object, real or virtual whose image is at infinity. (q) The second principal focus of a lens is the position of the image, real or virtual whose object is at infinity. (r) The first principal focus of a lens is the position of the object, real or virtual whose image is at infinity. (s) The first principal focus of a lens is the position of the image, real or virtual whose object is at infinity.  Examine the above statements and find which among then are correct. 
In throwing a six faced die, let A be the event that an even number occurs, B be the event that an odd number occurs and C be the event that a number greater than 3 occurs. Which one of the following is correct?
A coin is tossed thrice. Let X be the event that head occurs in each of the first two tosses. Let Y be the event that a tail occurs on the third toss. Let Z be the event that two tails occur in three tosses. Based on the above information, which one of the following statements is TRUE?
You develop an inventory management application called XYZManagement that will call aMicrosoft SQL Server stored procedure named sp_GetDailyXYZSales. The stored procedure will run a query that returns your daily sales total as an output parameter.This total will be displayed to users in a message box.
Your application uses a SqlCommand object to run sp_GetDailyXYZSales. You write the
following code to call sp_GetDailyXYZSales:
SqlConnection cnn = new SqlConnection(myConnString);
SqlCommand cmd = new SqlCommand(“sp_GetDaily XYZ Sales”, cnn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter prm = cmd.Parameters.Add(“@ItemTotal”,SqlDbType.Int);
prm.Direction = ParameterDirection.Output;
cnn.Open();
cmd.ExecuteNonQuery();
Now you must write additional code to access the output parameter. Which code segment should you use?
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?