Question
a.
BIT(n)
b.
BIT VARYING(n)
c.
BIT FIX(n)
d.
both a and b
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 types of bit-string data type are
Similar Questions
Discover Related MCQs
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
Q. Which command is used to create a new relation in SQL
View solution
Q. If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?
View solution
Q. What is the syntax to load data into the database? (Consider D as the database and a, b, c as data)
View solution
Q. Which of the following commands do we use to delete a relation (R) from a database?
View solution
Q. Which of the following commands do we use to delete all the tuples from a relation (R)?
View solution
Q. Choose the correct command to delete an attribute A from a relation R
View solution
Q. create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID));
Choose the correct option regarding the above statement
View solution
Q. What does the notnull integrity constraint do?
View solution
Q. Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?
View solution
Q. Which of the following logical connectives is not included in SQL?
View solution
Q. The where clause is a predicate involving attributes of the relation in the ______ clause.
View solution
Q. select distinct dept_name
from institute;
What does the above query do?
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!