Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
Correct Answer :
D. Line2/*
The multi-line comment starts with /* and ends with */
Related Questions
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
The table records can be retrieved using which command?
RETRIEVE
SELECT
CREATE
ALTER
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
In LIKE clause, to represent a zero, a character, or a number of characters ___ is used.
/
_
*
%
A database does not need to be created in ____. A direct table creation option is provided in ____.
MySQL
Oracle
Both A and B
None of the above
In order to assign a random name to a column or table, which SQL SELECT Clause is used?
FROM
WHERE
HAVING
AS
Global Temp Variable is used with which sign?
###
####
#
##
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
When an expression includes ___ SQL operator(s), the sequence in which they are evaluated is known as the SQL operator's precedence.
0
1
Multiple
NULL
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
SQL has the advantage of?
SQL require a lot of programming.
SQL provides High-Speed Query Processing.
SQL follows the standard languages of ANSI and ISO.
SQL is easily portable.
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
What does UCASE() function do?
Converts database field to uppercase
Converts database field to lowercase
Returns the length of the text field
Returns the current date and time
Which of the following statement is TRUE about DISTINCT Clause?
Returns only Distinct values.
Only on the single column, it operates.
It can be used with the aggregates such as COUNT, AVG, etc.
All of the above
Which of the following is/are transaction control commands in SQL?
Commit
Rollback
Both A. and B.
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
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
If multiple columns are used as Primary Key, it is known as
Unique
Composite
Foreign
None of the above
Which of the following is/are Scalar function(s)?
UCASE()
MID()
ROUND()
All of the above
Which syntax is correct for RENAME DATABASE in MySQL?
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;
What does the ROLLBACK Statement do?
Specify the columns of the table in this SQL statement to return distinct values.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
An index is created in a SQL database table with this SQL statement.
SQL CREATE DATABASE is used to,
Create a table
Create a database
Create a column
Create a row
Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above
What is the functionality of UCASE function?
To change the case of the string to lowercase characters.
To change the case of the string to uppercase characters.
To change the case of the string to numeric characters.
To change the case of the string to symbolic characters.
To add a Primary Key constraint after table is created, which clause is used?
UPDATE
ADD
ALTER
JOIN
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