Q. When the schema is to be dropped in SQL which has no elements then the type of DROP Command used is called

View solution

Q. If the referential integrity constraint is violated then the specific action clause attached by the database designers other than by default action is classified as

View solution

Q. The data type DATE has three components where as its insertion considers

View solution

Q. In SQL, the type of character string value which is specified as being case sensitive and placed between apostrophes is called

View solution

Q. In Standard Query Language, the data types included are

View solution

Q. The data type in SQL which includes various size integers and floating point numbers are classified as

View solution

Q. In the statement DECIMAL (I, j) to specify numeric data type, the digits after the decimal point are called

View solution

Q. The command in SQL which is used when any of the schema is no longer needed in relation is classified as

View solution

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