Comments whose starting and ending lines are different are known as
Inline Comments
Multi-line Comments
Single Line Comments
Varied line Comments
Correct Answer :
B. Multi-line Comments
Comments whose starting and ending lines are different are known as Multi-line Comments.
Related Questions
What does the DROP INDEX Statement do?
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.
An index is created in a SQL database table with this SQL statement.
An existing SQL database is selected with this SQL statement. A database must be selected from several existing databases before you can perform operations on the table.
Which of the following is/are transaction control commands in SQL?
Commit
Rollback
Both A. and B.
None of the above
What does the DISTINCT Clause do?
Specify the columns of the table in this SQL clause to return distinct values.
By executing this SQL statement, all records in the SQL database will be deleted.
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.
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that start with a and are at least 2 characters in length
All of the above
BETWEEN Operator returns the TRUE value if the column value is
<=Value1 & >=Value2
<=Value1 & <=Value2
>=Value1 & >=Value2
>=Value1 & <=Value2
Full form of DCL is -
Data Control Language
Data Commit Language
Data Common Language
Data Concatenate Language
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
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 TRUNCATE TABLE Statement do?
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
By executing this SQL statement, all records in the SQL database will be deleted.
The data specified in this table or view is reported in this SQL statement.
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above
____ Clause is used in Parent-child relationship in order to join two or more tables.
FROM
TO
WHERE
IN
Local Temp Variable is used with which sign?
?
@
#
&
Which of the following clause cannot be optional in SQL SELECT Statement?
WHERE
GROUP BY
ORDER BY
None of the above
Which clause is used to retrieve a unique element from the table?
SELECT UNIQUE
SELECT DISTINCT
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
What does the DROP TABLE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
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.
A new database will be created through this SQL statement.
NULL means
ZERO
-1
1
Empty
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
The ____ operator cannot be used with the sub query, but within it.
IN
INTO
BETWEEN
JOIN
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None of the above
What does the DROP DATABASE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
A new database will be created through this SQL statement.
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
What does BOOL mean in MySQL Numeric Data Types?
A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is considered true.
A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is considered false.
A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is also considered true.
A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is also considered false.
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
LIKE clause can be used with
% operator
_ operator
NOT operator
All 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