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
Correct Answer :
A. Finds any values that start with a and ends with o
The above statement finds any values that start with a and ends with o
Related Questions
SQL Operator can be,
Unary
Binary
Both A and B
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 the COMMIT Statement do?
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.
Specify the columns of the table in this SQL statement to return distinct values.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
Using which SQL Comparison Operator can we find the data that matches our query?
SQL Not Equal Operator (!=)
SQL Equal Operator (=)
SQL Greater Than Operator (>)
SQL Less Than Operator (<)
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above
What is TRUE about DEFAULT constraint?
The value will first be checked for certain conditions before inserting it into the column when a DEFAULT constraint applies to a column in the table.
In the event of a DEFAULT constraint being applied to a table's column without a user specifying the value to be inserted when that constraint was applied, the default value that was specified when the constraint was applied will be put into that column.
An index can be created on the table using the DEFAULT constraint.
None of the above
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
Which of the following is TRUE about Information Rule in the 12 Codd's Rules?
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.
Null values are treated in database records according to this rule.
Database systems must update all views tables on a regular basis.
Databases contain a wide variety of information, and each row and column of each table must hold this information.
SQL DELETE can be used to delete,
Rows
Database
View
All of the above
Select the correct statement about SQL Scripts?
At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.
All of the above
What will be the output of the below SQL statement?
25
26
24
20
Through which system, we can detect SQL Injection attacks?
Injection Detection System
Attack Detection System
Intrusion Detection System
None of the above
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
Select the statement which is TRUE?
In a table, there could be any number of rows and any number of columns.
In a table, there could be any number of rows and specified number of columns.
In a table, there could be any number of columns and specified number of rows.
In a table, there could be specified number of rows and specified number of columns.
In order to insert a row directly in the table, which command is used?
INSERT IN
INSERT INSIDE
INSERT UNDER
INSERT INTO
Foreign key is a field in a table that is _______ key in another table?
Primary
Unique
Composite
None of the above
A Primary Key is basically a
Row
Column
Table
Database
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
Using SQL SELECT RANDOM() function, one can return the random
Table
Database
Row
Column
In SQL, Like is a ____ operator.
Relational
Logical
Additional
Unique
Which of the following statement is FALSE?
A Primary Key cannot be NULL
A Foreign Key cannot be NULL
A Primary Key cannot be Duplicate
A Foreign Key can be Duplicate
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
When two or more columns are combined to be used to uniquely identify each row in the table, it is known as -
Primary Key
Unique Key
Composite Key
Foreign Key
The description in SQL Script, displays script in
One Line
Two Line
Three Line
Many Lines
Which of the following is TRUE about The Foundation Rule in the 12 Codd's Rules?
Relational databases are required.
Databases contain a wide variety of information, and each row and column of each table must hold this information.
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.
Null values are treated in database records according to this rule.
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All of the above
NOW function is used to return the current
Time
Date
Date & Time
Day
What does the CREATE INDEX Statement do?
An index is created in a SQL database table with this SQL statement.
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.
The SQL database table's index is deleted using this SQL statement.
What does the ALTER TABLE Statement do?
By deleting the stored data, this SQL statement deletes the database.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
A new table in SQL is created using this SQL statement.
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
What is meant by 'SQL is an interactive language'?
Learning and understanding SQL is easy
It can also be used for communicating with the database.
In a few seconds, complex queries can also be answered using this language.
All of the above