Question
a.
DROP SCHEMA command
b.
PICK SCHEMA command
c.
DELETE SCHEMA command
d.
RESTRICT SCHEMA command
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The command in SQL which is used when any of the schema is no longer needed in relation is classified as
Similar Questions
Discover Related MCQs
Q. In the declaration statement DECIMAL (I, j), the 'I' is classified as
View solution
Q. In fixed length character string CHAR(n), the 'n' represents
View solution
Q. The relations that are declared in SQL through CREATE VIEW statements are classified as
View solution
Q. In SQL, the identifier which are used to indicate the user of schema is classified as
View solution
Q. If the explicit value of attributes is not provided in SQL then the value included in new tuple in such situation is called
View solution
Q. The command used in SQL which deletes the table definition as well as all the records available in the table is called
View solution
Q. The command used in SQL to specify new relation, its initial constraints and attributes is classified as
View solution
Q. In the TIMESTAMP data type, the relative value which is used to decrease or increase absolute value of time stamp is classified as
View solution
Q. The clause used in SQL for ensuring referential integrity is classified as
View solution
Q. In the CREATE TABLE command in standard query language, the referential integrity constraints is specified only after the
View solution
Q. The data type often used in SQL-99 to specify columns with large values is classified as
View solution
Q. The relations that are declared in SQL through CREATE TABLES statements are classified as
View solution
Q. The formatted numbers are declared in SQL by using statement such as
View solution
Q. In SQL, the type of character string value which is padded with blank characters to the right side of string is called
View solution
Q. The type of data in SQL which includes TIME and DATE fields plus six positions for other decimal fractions is classified as
View solution
Q. The data type DATE consists of ten positions where as the data type TIME consists of
View solution
Q. The module in the SQL which is used to identify elements in the schema is classified as
View solution
Q. In varying length character string CHAR(n), the 'n' represents
View solution
Q. The concatenation operator in SQL which can concatenate two strings is denoted as
View solution
Q. In the statement DECIMAL () to specify numeric data type, the number of decimal digits is called
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
