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

Q. Considering the change in schema statement in SQL, the command which is used to delete records of table and leave the definition of table for later use is classified as

View solution

Q. In standard query language, the rows and columns are called respectively

View solution

Q. If the length of bit string is multiple of 4 then it can be specified with the notation called

View solution

Q. The referential triggered action clause in Standard Query Language is attached to constraint called

View solution

Q. The types of bit-string data type are

View solution