Question
a.
DECIMAL (I, j)
b.
DEC ()
c.
NUMERIC ()
d.
all of above
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 formatted numbers are declared in SQL by using statement such as
Similar Questions
Discover Related MCQs
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
Q. If the concatenation operator is applied to two strings such as [ 'ABCD' || 'wxyz' ] then the resultant string will be
View solution
Q. In SQL, the constraints, constructs, views, domains and tables are classified as its
View solution
Q. The clause used in CREATE TABLE statement in SQL to specify secondary keys is called
View solution
Q. The possible actions of altering the tables in Standard Query Language includes
View solution
Q. The type of bit strings which is preceded by 'B' and is placed between single quotes is classified as
View solution
Q. In CREATE TABLE SQL command, each table must have atleast column/s
View solution
Q. Which of the following information does an SQL DDL not specify?
View solution
Q. Which of the following data types does the SQL standard not support?
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!
.png)
