Bissoy.com
Doctors Medicines MCQs Q&A

To see the table structure, which of the following SQL commands is issued?

To see the table structure, which of the following SQL commands is issued? Correct Answer DESCRIBE tbl_name

The ‘DESCRIBE’ command is issued to see the structure of the table ‘tbl_name’. It shows the structure in the format: Field-Type-Null-Key-Default-Extra. The ‘VIEW’ and ‘SELECT’ commands are used to see the contents of the table.

Related Questions

Consider the following information and answer the questions based on it. Out of the 75 birders, 15 wanted to see only sunbird, 10 wanted to see only flycatcher, 12 wanted to see both sunbird and nuthatch, 15 wanted to see only bee-eater, 13 wanted to see both sunbird and bee-eater, 5 wanted to see both flycatcher and nuthatch and the remaining wanted to see only nuthatch. The difference between the birders who want to see sunbird and those who want to see flycatcher is
Consider the following information and answer the questions based on it. Out of the 75 birders, 15 wanted to see only sunbird, 10 wanted to see only flycatcher, 12 wanted to see both sunbird and nuthatch, 15 wanted to see only bee-eater, 13 wanted to see both sunbird and bee-eater, 5 wanted to see both flycatcher and nuthatch and the remaining wanted to see only nuthatch. How many birders wanted to see only one bird?
Out of the 100 nature lovers, 20 people wanted to see only bison, 30 wanted to see both bison and tiger, 15 wanted to see only leopard, 25 wanted to see only tiger, 5 wanted to see both bison and leopard and the remaining wanted to see only bear. How many people who wanted to see bison did not want to see leopard?
Out of the 100 nature lovers, 20 people wanted to see only bison, 30 wanted to see both bison and tiger, 15 wanted to see only leopard, 25 wanted to see only tiger, 5 wanted to see both bison and leopard and the remaining wanted to see only bear. The ratio of people to wanted to see tiger to those who wanted to see bear is
Consider the following information and answer the questions based on it. Out of the 75 birders, 15 wanted to see only sunbird, 10 wanted to see only flycatcher, 12 wanted to see both sunbird and nuthatch, 15 wanted to see only bee-eater, 13 wanted to see both sunbird and bee-eater, 5 wanted to see both flycatcher and nuthatch and the remaining wanted to see only nuthatch. The ratio of birders who like nuthatch to those who like bee-eaters is
Out of the 100 nature lovers, 20 people wanted to see only bison, 30 wanted to see both bison and tiger, 15 wanted to see only leopard, 25 wanted to see only tiger, 5 wanted to see both bison and leopard and the remaining wanted to see only bear. How many people wanted to see only one animal?
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 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?
Under Section 95 of the Code of Criminal Procedure, 1973, certain publications can be forfeited and search warrant can be issued for the same. In this context, which of the following is/are the correct legal proposition?
1. A news paper cannot be forfeited and search warrant cannot be issued for the same as it would be violative of the fundamental right of speech and expression
2. A book can be forfeited and search warrant can be issued for the same
3. A document can be forfeited and search warrant can be issued for the same
Select the correct answer:
Under section 95 of Criminal Procedure Code certain publications can be forfeited and search warrant can be issued for the same. In this context, the propositions are
1. A newspaper cannot be forfeited and search warrant cannot be issued for the same as it would be violative of the fundamental right of speech and expression and involves the fourth estate.
2. A book can be forfeited and search warrant can be issued for the same.
3. A document can be forfeited and search warrant can be issued for the same.
Which of the following is correct