The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
None of the above
Correct Answer :
C. Both A. and B.
The characters which are used independently or in conjunction with SQL Like Operator are '%' & '_'.
Related Questions
Which of the following is not the SQL Comparison Operator?
SQL Equal Operator (=)
SQL Less Than Operator (<)
SQL Greater Than Operator (>)
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
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
Which of the following is TRUE about the type of SQL Injection attack?
Install malicious program
Export valuable data
Get user login detail
All of the above
Which function combines the two different columns?
ADD
MERGE
CONCAT
None of the above
In order to manage or store the data in the database, WEB SQL Database is used which is a
Web site
Web page
Web browser
None of the above
In order to merge two or more strings, which string function is used?
CHAR
ALTER
CONCAT
MERGE
All other columns other than the column which is termed as Primary Key, are known as
Unique Keys
Alternate Keys
Composite Keys
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
Local Temp Variable is used with which sign?
?
@
#
&
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.
What is the work of UPDATE command?
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Using this command, you can remove or erase recorded information from a database table.
Database data can be updated or changed using this command.
It enables you to create new databases, tables, table views, and other objects using this command.
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
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
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
Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
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
What is the work of SELECT command?
Database objects such as tables, table views, and other objects can be deleted using this command.
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.
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
In SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
What does this SQL database language design to?
Maintain the data in hierarchal database management systems.
Maintain the data in relational database management systems.
Maintain the data in network database management systems.
Maintain the data in object-oriented database management systems.
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Command that comes under DCL is/are -
GRANT
REVOKE
Both A. and B.
None of the above
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All 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
Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.