Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Correct Answer :
C. Both A) and B)
Host-based IDS can be used to monitor the web server logs and when something weird occurs.
Related Questions
From the set of results, in order to remove the duplicate columns, ____ Clause is used.
DUPLICATE
DISTINCT
REMOVE
DROP
What is the default length of any data type in the CAST function?
10
20
30
40
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Using which clause, can SQL EXCEPT be used in single table?
TO
AS
WHERE
IN
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
SELECT INTO statement -
Select the content from a table.
Rename the content in a table.
Copy the content from one table into another existing table.
None of the above
What is the symbol of Concatenation Operator?
|
||
//
\
In how many parts are the SQL functions are divided into?
1
2
3
4
Whenever a sub query appears in SQL, it is enclosed within ____ and placed to the ____ of the SQL operators.
Brackets, Left
Brackets, Right
Parenthesis, Left
Parenthesis, Right
NULL means
ZERO
-1
1
Empty
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
For one table, there can be ____unique key constraint(s).
1
NULL
Many
None of the above
What will be the output of the below SQL statement?
2021-10-06 00:00:00.000
2021-10-06
2021 OCT 06
06-10-2021
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
Which of the following is TRUE about UNIQUE constraint?
In columns that are subject to the UNIQUE constraint, duplicate values are not allowed.
Unique values will always be present in the column containing the unique constraint.
A single table can have more than one unique constraint, since it can be applied to more than one column.
All of the above
Which statement is true about the SQL?
SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.
Scripts ____ from various workspaces can be imported through import.
Exported
Imported
Changed
Saved
Which of the following is among the 12 Codd's Rules?
View Updating Rule
Relational Level Operation Rule
Distribution Independence Rule
None of the above
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
What does the CREATE DATABASE Statement do?
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
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.
Choose the correct syntax of NOW function?
SELECT ()NOW;
NOW() SELECT;
SELECT NOW();
SELECT OWN();
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
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
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
In order to join N tables, minimum number of join statements required is
N
N-1
N-2
N+1
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique