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
Correct Answer :
A. 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 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.
Related Questions
Which of the following is not a SQL Logical Operator?
SQL Equal Operator
SQL ANY Operator
SQL BETWEEN Operator
SQL IN Operator
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above
By constraining a SQL statement, we limit the ____ according to certain conditions or restrictions.
Row
Column
Table
Database
Select the correct constraint in SQL?
NOT NULL
CHECK
DEFAULT
All of the above
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
C in CRUD Operator means
To add or insert data
To retrieve or fetch data
To update the data
To delete the data
In how many parts are the SQL functions are divided into?
1
2
3
4
Commands that come under TCL is/are -
COMMIT
ROLLBACK
SAVEPOINT
All of the above
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
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.
____ Clause is used in Parent-child relationship in order to join two or more tables.
FROM
TO
WHERE
IN
_____ variables are not supported by SQL Script.
Bind
Dynamic
Both A) and B)
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
Full form of DML is
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language
Which one of the syntaxes given below is of Binary Operator?
Operator SQL _Operand
Operand2 SQL _Operator Operand1
Operand1 SQL _Operator Operand1
Operand1 SQL _Operator Operand2
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
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
Which one if these is used to put the same value in all the rows?
Group by unique column
Group by single column
Group by one column
Group by same value
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
SQL has the disadvantage of?
SQL is cheap.
SQL interface is simple.
Both A and B.
None of the above.
Which function is used to obtain the month from the entire data stored in a table's column?
DATE
TIME
MONTH
DATE & TIME
A Primary Key is basically a
Row
Column
Table
Database
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
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
Which of the following are the types of the temp tables?
Local Temp
Global Temp
Both A) and B)
None of the above
What is the difference between HAVING and WHERE clause?
HAVING clause is used in column operation whereas WHERE clause is used in row operation.
HAVING clause is post-filter whereas WHERE clause is pre-filter.
HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
All of the above
TRUNCATE TABLE requires:
WHERE clause
HAVING clause
Both a and b
None of the above
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
In the database table, data types describe the kind of ___ that it can contain.
Table
Data
Number
None of the above