Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
Correct Answer :
C. Both A. and B.
Commands that comes under DCL are GRAND & REVOKE.
Related Questions
What is meant by 'SQL is an interactive language'?
Learning and understanding SQL is easy
It can also be used for communicating with the database.
In a few seconds, complex queries can also be answered using this language.
All of the above
Which of the following are the types of the temp tables?
Local Temp
Global Temp
Both A) and B)
None of the above
In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.
Physical Data
Logical Data
Integrity
Distribution
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?
If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
Choose the correct syntax of NOW function?
SELECT ()NOW;
NOW() SELECT;
SELECT NOW();
SELECT OWN();
Which of the following is supported in Comprehensive Data SubLanguage Rule in the 12 Codd's Rules?
Data Definition
View Definition
Data Manipulation
All of the above
MINUS Operator displays the rows which are
Detected in the second query, absent in the first query, and there are no duplications.
Detected in the first query, absent in the second query, and there are no duplications.
Detected in the first query, absent in the second query, and there are duplications.
Detected in the second query, absent in the first query, and there are duplications.
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
Which of the following is TRUE about Savepoint command?
A transaction is marked in a table by this TCL command.
Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
In order to rollback part of a table rather than the entire table, a savepoint is useful.
All of the above
To rename the Index, we need to use which command?
RENAME
ALTER
UPDATE
ADD
Which statement is TRUE about the GROUP BY Clause?
In order to retrieve rows, GROUP BY Clause is used.
In order to group the rows that share the same property, GROUP BY Clause is used.
In order to select the defined groups, GROUP BY Clause is used.
In order to return the rows, GROUP BY Clause is used.
By default, TIME data type stores time in which format?
MM:HH:SS;
SS:HH:MM;
HH:SS:MM;
HH:MM:SS;
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?
Both CLOB and NCLOB are used for multibyte national character set data.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 8GB.
Both CLOB and NCLOB are used for singlebyte and multibyte national character set data.
Which of the following statement is TRUE about Primary Key?
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
BETWEEN operator is used with which SQL Statements
SELECT
DELETE
INSERT
All of the above
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
What does the DELETE Statement do?
A new table in SQL is created using this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.
Network-based IDS can be used to monitor
Web server logs
When something weird occurs
All connections to the database server
None of the above
What is the symbol of Concatenation Operator?
|
||
//
\
For one table, there can be ____unique key constraint(s).
1
NULL
Many
None of the above
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
The table records can be retrieved using which command?
RETRIEVE
SELECT
CREATE
ALTER
What is TRUE about NOT NULL Constraint?
In columns that are subject to the NOT NULL constraint, duplicate values are not allowed.
When a table's column is declared as NOT NULL, no record in the table can have an empty value for that column.
By applying the NOT NULL constraint, we will always ensure that the column contains a unique value and won't allow nulls.
The value will first be checked for certain conditions before inserting it into the column when a NOT NULL constraint applies to a column in the table.
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above