In order to remove an index, we need to use which command?
REMOVE
DELETE
DROP
DEL
Correct Answer :
C. DROP
In order to remove an index, we need to use DROP command.
Related Questions
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
What does COUNT() function returns?
Average value
Largest value
Smallest value
Number of rows
Read in CRUD Operator means
To retrieve data
To fetch data
Both A. and B.
None of the above
Select the correct rule of SQL EXCEPT.
There must be the same number of columns in each table and the same order in every select statement.
It is desirable that the columns have similar or compatible data types.
Both SELECT statements must have the same fields in their respective columns.
All of the above
Which of the following is TRUE about Information Rule 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 systems must update all views tables on a regular basis.
Databases contain a wide variety of information, and each row and column of each table must hold this information.
_____ variables are not supported by SQL Script.
Bind
Dynamic
Both A) and B)
None of the above
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
NOW function is used to return the current
Time
Date
Date & Time
Day
Which of the following is the feature(s) of SQL Auto Increment?
In some cases you may not have any unique identifying characteristics in data; therefore, it makes sense to create a Primary Key.
Explicitly initializing and modifying the auto-increment value is possible at any time.
Record identifiers can easily be created that are unique to each record.
All of the above
What is the work of INSERT command?
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
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.
In order to update one table using another table and join condition, which statement is used.
SQL UPDATE INTO
SQL UPDATE JOIN
SQL JOIN
SQL JOIN UPDATE
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
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
What does the following statement do?
Finds any values that end with a
Finds any values whose second character is a
Find any values that contains only two characters ending with a
Mysql > Savepoint ini;
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
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
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above
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.
How can we prevent SQL Injection attack?
We should pre-define the input type, input field and length of the user data to validate the input for the user authentication.
Access privileges should be restricted for the users
Administrator accounts should not be used.
All of the above
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
Select the correct statement.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
What is the clause to delete all rows from the table?
SQL DELETE ALL ROWS Table_Name;
SQL DELETE ROWS Table_Name;
DELETE FROM ALL ROWS Table_Name;
DELETE FROM Table_Name;
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.
SQL BETWEEN operators can be used to select the
Dates
Texts
Numbers
All 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
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All of the above
Which of the following statement is TRUE about SQL Injection?
SQL Injection is an Object Penetration Technique
SQL Injection is a Function Penetration Technique
SQL Injection is a Code Penetration Technique
SQL Injection is a Database Penetration Technique
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()