Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
Correct Answer :
D. All of the above
Commonly used SQL commands are CREATE, UPDATE, and DELETE, etc.
Related Questions
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
Bit is an integer that can be
0
1
Null
All of the above
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
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
What is the difference between DELETE and TRUNCATE statements?
DELETE statement free up the space kept in check by the table whereas TRUNCATE statement does not free up the space kept in check by the table.
DELETE statement does not free up the space kept in check by the table whereas TRUNCATE statement free up the space kept in check by the table.
DELETE statement only deletes rows from the table whereas TRUNCATE statement can only delete columns from the table.
DELETE statement only deletes columns from the table whereas TRUNCATE statement can only delete rows from the table.
Using TIME_FORMAT() function, time can be retrieved in
12-hour format
24-hour format
Both A. and B.
None of the above
If multiple columns are used as Primary Key, it is known as
Unique
Composite
Foreign
None of the above
Which of the following statement is correct for SQL Multiplication Operator?
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
SELECT Operand1
In the case of ____ Independence Rule, if using the SQL queries language to insert data into table's cells, the database must maintain integrity independence.
Interdependent
Intradependent
Integration
Integrity
What does the DELETE Statement do?
A new table in SQL is created using this SQL statement.
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.
By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.
In which clause does the BETWEEN operator is used?
IF
AS
WHERE
EXCEPT
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All 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;
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
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
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
Which of the following is/are type of SQL Constraint?
Column Level
Table Level
Both A and B
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 SQL, which statement can help in changing the name of the table?
RENAME
ALTER
Both A) and B)
None of the above
Which one is not the OPTIONAL Clause in SELECT statement?
WHERE
ORDER BY
HAVE
HAVING
What is TRUE about NOT NULL Constraint?
In columns that are subject to the NOT NULL constraint, duplicate values are not allowed.
When a table's column is declared as NOT NULL, no record in the table can have an empty value for that column.
By applying the NOT NULL constraint, we will always ensure that the column contains a unique value and won't allow nulls.
The value will first be checked for certain conditions before inserting it into the column when a NOT NULL constraint applies to a column in the table.
In order to create the Index, we need to use which command?
ALTER
UPDATE
CREATE
ADD
Which of the following states the correct situation in which Indexes should not be used in SQL?
When the table is small, it is possible to avoid using SQL indexes.
Updates need to be made frequently to the table.
When there are a lot of NULL values in a column, indexed should not be used.
All 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.
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 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.
Full form of DML is
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language