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
Correct Answer :
D. All of the above
About DCL Commands -
a) The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
b) There will be certain privileges that each user has; consequently, the data can be accessed by them.
c) 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.
Related Questions
Which of the following constraints are TRUE to be put in Password system?
One uppercase character must be included in the password.
An eight-character minimum password is required.
At least one symbol must appear in the password.
All of the above
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
SQL EXCEPT clause is supported in
MySQL
PostgreSQL
Both A and B
None of the above
NULL means
ZERO
-1
1
Empty
SQL ___ can be used to delete or drop existing databases in a SQL schema.
CREATE DATABASE
RENAME DATABASE
DROP DATABASE
SELECT DATABASE
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
Which statement is TRUE about the WHERE Clause?
In order to retrieve rows, WHERE Clause is used.
In order to group the rows, WHERE Clause is used.
In order to select the defined groups, WHERE Clause is used.
In order to return the rows, WHERE Clause is used.
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
What is TRUE about the Active/Dynamic Online Catalog based on the relational model in the 12 Codd's Rules?
The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
Null values are treated in database records according to this rule.
Database dictionaries represent the complete logic of all descriptive data, which must be stored online.
None of the above
Which of the following statement is TRUE?
Web API is the part of HTML5
Web API is not the part of HTML5
Web API is the part of HTML
Web API is the part of XHTML
Which statement is not true?
SQL is rational whereas No-SQL is non-rational.
SQL follows BASE Model whereas No-SQL follows ACID Model.
SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
No-SQL databases are preferable to store hierarchical data in comparison SQL databases.
When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Which of the following is TRUE about Pattern Matching in SQL?
In SQL, pattern matching is performed with LIKE clauses.
An SQL query usually begins with a LIKE clause before a WHERE clause
Using the LIKE clause in an SQL query, we compare the pattern in the query with the pattern present in a table.
All of the above
In more readable form, you can retrieve the date values, using ______ function?
DATE
DATE_FORM
DATE_FORMAT
DATE_VALUE
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.
What is the keyword of the Ascending and Descending?
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
What does the following statement do?
Finds any values that start with a and ends with o
Finds any values whose first character is a and third character is o
Both A. and B.
None of the above
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
What does the DROP TABLE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
A new table in SQL is created using this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
A new database will be created through this SQL statement.
Name of the control in SQL Script
Script
Owner
Opinion
All of the above
Which syntax is correct for RENAME DATABASE in SQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
Select the statement which is TRUE?
In case a transaction is rolled back, the data allied with table variable also get rolled back.
In case a transaction is rolled back, the data allied with table variable does not roll back.
In case a transaction is not rolled back, the data allied with table variable get rolled back.
None of the above.
What does the DROP INDEX Statement do?
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.
An index is created in a SQL database table with this SQL statement.
An existing SQL database is selected with this SQL statement. A database must be selected from several existing databases before you can perform operations on the table.
What is TRUE about DEFAULT constraint?
The value will first be checked for certain conditions before inserting it into the column when a DEFAULT constraint applies to a column in the table.
In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column.
An index can be created on the table using the DEFAULT constraint.
None of the above
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
What is the work of SELECT command?
Database objects such as tables, table views, and other objects can be deleted using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
It enables you to create new databases, tables, table views, and other objects using this command.