SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
Correct Answer :
D. ALTER
SQL LIKE is used with DELETE, SELECT and UPDATE statements and not with ALTER statements.
Related Questions
In case of ____Rule, 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.
Systematic Treatment of Null Values
Guaranteed Access
View Updating
Physical Data Independence
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
Select the correct statement.
DDL consist of 4 commands
DCL consist of 2 commands
TCL consist of 5 commands
DML consist of 3 commands
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.
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
Comments whose starting and ending lines are different are known as
Inline Comments
Multi-line Comments
Single Line Comments
Varied line Comments
For one table, there can be ____unique key constraint(s).
1
NULL
Many
None 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
Local Temp Variable is used with which sign?
?
@
#
&
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.
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
Choose the correct syntax of NOW function?
SELECT ()NOW;
NOW() SELECT;
SELECT NOW();
SELECT OWN();
Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
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
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;
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.
ORDER BY clause comes ____ the EXCEPT clause in SQL statement?
Before
After
Flexible to before or after
None of the above
_____ variables are not supported by SQL Script.
Bind
Dynamic
Both A) and B)
None of the above
To add a Primary Key constraint after table is created, which clause is used?
UPDATE
ADD
ALTER
JOIN
What is the meaning of Null Values in Systematic Treatment of Null Values in the 12 Codd's Rules?
No value in cell
Inappropriate Information
Unknown data
All of the above
Which of the following is TRUE about SQL Concatenate?
It is also possible to combine more than two strings into one string.
Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
All of the above
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
SQL BETWEEN operators include
Starting Value
In Between Value
Ending Value
All of the above
What does the SELECT Statement do?
Data is read from the SQL database by this statement and displayed to the database user.
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.
In order to remove a primary key constraint, which clause is used?
DELETE
DROP
ALTER
REMOVE
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
Which of the following is not MySQL Numeric Data Type?
BIT(Size)
CHAR(Size)
INTEGER(Size)
INT(Size)
Which of the following statement is correct?
Comparison Operator has higher precedence than Conjuction Operator.
Identity Operator has higher precedence than Multiplication Operator.
Both A and B
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