Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD
Correct Answer :
B. IDENTITY
IDENTITY keyword is used in SQL Server to implement the auto-increment.
Related Questions
Using SQL SELECT RANDOM() function, one can return the random
Table
Database
Row
Column
Difference between GRAND & REVOKE command is/are?
The GRANT command can be used to grant a user access to databases and tables whereas The REVOKE command can be used to revoke all access privileges already assigned to the user.
The REVOKE command can be used to grant a user access to databases and tables whereas The GRANT command can be used to revoke all access privileges already assigned to the user.
A transaction can be rolled back to its last saved state.
None of the above
Rules that are needed to be followed in SET Operators in SQL are
All columns must be identical in number and order.
There must be compatibility between data types.
Both A and B
None of the above
Which of the following statement is TRUE?
At run time, temporary tables can be created.
Temporary table can do similar operations to normal table.
Both A) and B)
None of the above
In case the CTE is wrong, it goes into
Infinite Loop
Null State
False State
True State
Select the syntax of Single Line Comment.
.
!
--
#
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
What is the functionality of SQL COUNT?
It returns the no of record of table
It returns the no of record of database
It returns the no of record of row
It returns the no of record of column
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
What is the work of UPDATE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Using this command, you can remove or erase recorded information from a database table.
Database data can be updated or changed using this command.
It enables you to create new databases, tables, table views, and other objects using this command.
From the set of results, in order to remove the duplicate columns, ____ Clause is used.
DUPLICATE
DISTINCT
REMOVE
DROP
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
In order to merge two or more strings, which string function is used?
CHAR
ALTER
CONCAT
MERGE
What is TRUE about UPDATE in SQL VIEW?
Views that depend on a single table can be updated.
An update of a view created from more than one table will not be allowed by SQL.
There should be no NULL values in the fields of view.
All of the above
Which of the following is a SQL Logical Operator?
SQL ALL Operator
SQL OR Operator
SQL LIKE Operator
All of the above
Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
Full form of DML is
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language
Which of the following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
Number of operands used by Unary Operator is?
1
2
3
4
What is the work of DELETE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Database data can be updated or changed using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
Using this command, you can remove or erase recorded information from a database table.
In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
Bit is an integer that can be
0
1
Null
All of the above
What does the TRUNCATE TABLE Statement do?
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
By executing this SQL statement, all records in the SQL database will be deleted.
The data specified in this table or view is reported in this SQL statement.
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
In order to convert the expression from one to another data type, which SQL Function is used?
CONVERT
CHANGE
CAST
TRANSIT
Transaction is able to control the following
Transaction
Commit
Rollback
All of the above
What is the difference between VARCHAR and VARCHAR2?
VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
There is no similarity between VARCHAR and VARCHAR2.
What does this SQL database language design to?
Maintain the data in hierarchal database management systems.
Maintain the data in relational database management systems.
Maintain the data in network database management systems.
Maintain the data in object-oriented database management systems.