It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
Correct Answer :
C. Both A. and B.
It is possible to use LIKE clauses with strings and numbers.
Related Questions
For one table, there can be ____unique key constraint(s).
1
NULL
Many
None of the above
What is TRUE about UPDATE in SQL VIEW?
Views that depend on a single table can be updated.
An update of a view created from more than one table will not be allowed by SQL.
There should be no NULL values in the fields of view.
All of the above
Full form of LCASE is -
Low case
Letter case
Light case
Lower case
What does task list consist of in SQL Script?
Import
Show Quotas
Manage Results
All 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
Select the correct constraint in SQL?
NOT NULL
CHECK
DEFAULT
All of the above
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
What is the syntax of SQL CAST Function?
CAST (expression AS [data type])
CAST (expression IN [data type])
CAST (expression TO [data type])
CAST (expression FOR [data type])
What is meant by Partial Database Control?
Business rules are hidden.
Users or professionals can't have the full control over the database.
Both A and B
None of the above
LIKE clause can be used with
% operator
_ operator
NOT operator
All of the above
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 Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
Network-based IDS can be used to monitor
Web server logs
When something weird occurs
All connections to the database server
None 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.
Which of the following is TRUE about Intrusion Detection System?
Intrusion Detection System is Network-based
Intrusion Detection System is Host-based
Both A) and B)
None of the above
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Which function is used to extract substrings from the column of the table
ROUND()
MID()
FORMAT()
NOW()
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
Through which system, we can detect SQL Injection attacks?
Injection Detection System
Attack Detection System
Intrusion Detection System
None 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
We can create View in SQL using
CREATE statement
CREATE VIEW statement
VIEW CREATE statement
SQL VIEW statement
Numbers of operand used by Binary Operators are?
1
2
3
4
Choose the correct syntax of NOW function?
SELECT ()NOW;
NOW() SELECT;
SELECT NOW();
SELECT OWN();
Which one of the syntaxes given below is of Binary Operator?
Operator SQL _Operand
Operand2 SQL _Operator Operand1
Operand1 SQL _Operator Operand1
Operand1 SQL _Operator Operand2
Read in CRUD Operator means
To retrieve data
To fetch data
Both A. and B.
None of the above
SQL CREATE DATABASE is used to,
Create a table
Create a database
Create a column
Create a row
SQL Indexes slows the execution time of which statement(s)?
UPDATE
INSERT
SELECT
Both A and B
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All of the above
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above