Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
Correct Answer :
A. Data Control Language
Full form of DCL is Data Control Language.
Related Questions
In order to convert the expression from one to another data type, which SQL Function is used?
CONVERT
CHANGE
CAST
TRANSIT
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
Select the correct statement.
DDL consist of 4 commands
DCL consist of 2 commands
TCL consist of 5 commands
DML consist of 3 commands
SELECT INTO statement -
Select the content from a table.
Rename the content in a table.
Copy the content from one table into another existing table.
None of the above
SQL BETWEEN operators can be used to select the
Dates
Texts
Numbers
All of the above
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
Which of the following clause is optional in SQL SELECT Statement?
SELECT
FROM
HAVING
None of the above
Bit is an integer that can be
0
1
Null
All of the above
What is TRUE about SQL EXCEPT clause?
The result is purged of duplicates
Duplicate records are not removed
Only one column can be compared by a clause
None of the above
What will be the output of the below SQL statement?
2021-10-06 00:00:00.000
2021-10-06
2021 OCT 06
06-10-2021
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
____ function extract characters from the text field.
LEN()
NOW()
MID()
FORMAT()
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
None of the above
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
Using SQL SELECT RANDOM() function, one can return the random
Table
Database
Row
Column
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
Which of the following is/are TRUE about DDL command?
Our data is stored in a table that is described by the schema, thus DDL commands deal with the schema.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
Both A. and B.
None of the above
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
In order to prevent multiple records from being returned by the sub query, ____ must be used before the sub query.
Many Value Operators
Multiple Value Operators
Single Value Operator
Unique Value Operator
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
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
What is the difference between nchar and nvarchar?
nchar is fixed and nvarchar is variable.
nchar is variable and nvarchar is fixed.
nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.
Which of the following statement is FALSE?
A Primary Key cannot be NULL
A Foreign Key cannot be NULL
A Primary Key cannot be Duplicate
A Foreign Key can be Duplicate
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE