Which SQL Query is use to remove a table and all its data from the database?
a. Create Table
b. Alter Table
c. Drop Table
d. None of these
Options: Every primary-key value must match a primary-key value in an associated table
B. Every primary-key value must match a foreign-key value in an associated table
C. Every foreign-key value must match a primary-key value in an associated table
D. Every foreign-key value must match a foreign-key value in an associated table
Ans:– c ,
More Database Systems Related questions:
Customer data (name and address, shipping instructions, credit terms, etc.) is provided by the:
Options: manufacturing information system, order entry subsystem, billing subsystem, marketing information system
Options: The tags are used to describe the appearance of the content., Addresses the structuring and manipulation of the data involved., Governs the display of information in a Web browser., All of the above.
Options: One or more conductors that serve as a common connection for a related group of devices, a continuous frequency capable of being modulated or impressed with a second signal, the condition when two or more stations attempt to use the same channel at the same time, a collection of interconnected functional units that provides a data communications service among stations attached to the network
Options: Cells B7 and cell B9 only.
B. Cells B7 through B9.
C. Cell B8 only.
D. None of the above.
Ans:– B ,
Which of the following is true concerning QBE?
Options: An official standard has been defined for QBE., QBE cannot be used for client/server systems., QBE does not give the programmer a visual programming environment., Complete applications can be written using QBE.
Options: a. Is determined by the presentation design and cannot be changed b. Is determined by the presentation design but can be changed in PowerPoint c. Is dependent on the amount of text within the organization chart d. B and c