Name of the control in SQL Script
Script
Owner
Opinion
All of the above
Correct Answer :
D. All of the above
Name of the controls in SQL Script are Script, Owner and Opinion.
Related Questions
Full form of DML is
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language
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.
What does COUNT() function returns?
Average value
Largest value
Smallest value
Number of rows
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
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?
REVOKE
COMMIT
ROLLBACK
SAVE
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
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
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 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.
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
SQL BETWEEN operators can be used to select the
Dates
Texts
Numbers
All of the above
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
Which of the following is TRUE about Pattern Matching in SQL?
In SQL, pattern matching is performed with LIKE clauses.
An SQL query usually begins with a LIKE clause before a WHERE clause
Using the LIKE clause in an SQL query, we compare the pattern in the query with the pattern present in a table.
All of the above
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
Which syntax is correct for RENAME DATABASE in MySQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
TINYTEXT can hold the maximum length of ___ characters?
254
255
256
257
In order to assign a random name to a column or table, which SQL SELECT Clause is used?
FROM
WHERE
HAVING
AS
What is TRUE about NOT IN clause?
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
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.
SQL became the standard of?
ASCII
ANSI
ISO
Both B and C
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above
To connect strings, which function is used
CONNECT
ADD
COMBINE
CONCAT
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
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.
Select the correct syntax for Multi-line Comments.
//*Line1
Line2*//
/*Line1
Line2/*
Which of the following is SQL Server String Data Type?
ntext
binary(n)
varbinary
All of the above
ROUND function consists of ___ parameters?
One
Two
Three
Four