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
Correct Answer :
D. All of the above
Comprehensive Data SubLanguage Rule in the 12 Codd's Rules supports the comprehensive, Data Definition, Data Manipulation, View Definition, Limit Transaction Management Operations, and Integrity Constraints.
Related Questions
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
Which of the following is not MySQL String Data Type?
TEXT(Size)
TINYTEXT
MEDIUMTEXT
LARGETEXT
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
At which of the following stage does SQL Injection occurs?
When the user is asked to logout
When the user is asked to input password
When the user is asked to input captcha
When the user is asked to input username
In SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?
REVOKE
COMMIT
ROLLBACK
SAVE
What does the CREATE TABLE Statement do?
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
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.
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 or
Finds any value that contains only four characters and second, third characters are 'o', 'r'
Finds any values that have or in any position
None of the above
Global Temp Variable is used with which sign?
###
####
#
##
Which of the following is a SQL Logical Operator?
SQL ALL Operator
SQL OR Operator
SQL LIKE Operator
All of the above
A Primary Key is basically a
Row
Column
Table
Database
How many temp tables are there?
1
2
3
4
Which of the following is TRUE about TCL?
Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.
Which statement is TRUE about the ORDER BY Clause?
In order to return the rows in a specific order, ORDER BY Clause is used.
In order to group the rows, ORDER BY Clause is used.
In order to select the defined groups, ORDER BY Clause is used.
None of the above
The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
None of the above
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
What is the difference between DELETE and TRUNCATE statements?
DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.
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
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
SET Operators are used to
Compile the results from two queries
Compile the results from three queries
Compile the results from four queries
Compile the results from five queries
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.
Concatenate
Virtual
View
None of the above
In the database table, data types describe the kind of ___ that it can contain.
Table
Data
Number
None of the above
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
What does the COMMIT Statement do?
The data specified in this table or view is reported in this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
Specify the columns of the table in this SQL statement to return distinct values.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
Which of the statement is true?
The precedence-low operators are evaluated last in SQL.
The precedence-high operators are evaluated first in SQL.
Both A and B
None of the above
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