Types of SQL Commands are
DDL
DML
DCL
All of the above
Correct Answer :
D. All of the above
Types of SQL Commands are DDL, DML, DCL & TCL.
Related Questions
Which of the following is TRUE about the type of SQL Injection attack?
Install malicious program
Export valuable data
Get user login detail
All of the above
Select the statement which is TRUE?
In case a transaction is rolled back, the data allied with table variable also get rolled back.
In case a transaction is rolled back, the data allied with table variable does not roll back.
In case a transaction is not rolled back, the data allied with table variable get rolled back.
None of the above.
SQL DELETE can be used to delete,
Rows
Database
View
All of the above
SQL EXCEPT returns the record from -
First SELECT Query
Second SELECT Query
Third SELECT Query
None of the above
What does the CREATE TABLE Statement do?
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
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
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
SQL has the advantage of?
SQL require a lot of programming.
SQL provides High-Speed Query Processing.
SQL follows the standard languages of ANSI and ISO.
SQL is easily portable.
Select the correct statement.
TRUNCATE TABLE is faster than DELETE TABLE statement.
TRUNCATE TABLE uses fewer resources than DELETE TABLE statement.
Both A) and B)
None of the above
Which of the following statement is true?
SQL statements are used for most operations in a database.
Relational algebra and tuple relationship calculus are needed for SQL syntax.
All of the above
None of the above
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All of the above
What is the default length of any data type in the CAST function?
10
20
30
40
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
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 does SQL stand for?
SQL stands for Sample Query Language
SQL stands for Structured Query List
SQL stands for Structured Query Language
SQL stands for Sample Query List
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
What does the DISTINCT Clause do?
Specify the columns of the table in this SQL clause to return distinct values.
By executing this SQL statement, all records in the SQL database will be deleted.
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.
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
In the relational database, in order to modify index, we need to use which command?
ALTER
MODIFY
UPDATE
ADD
Which of the following clause is optional in SQL SELECT Statement?
SELECT
FROM
HAVING
None of the above
What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?
Both CLOB and NCLOB are used for multibyte national character set data.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 8GB.
Both CLOB and NCLOB are used for singlebyte and multibyte national character set data.
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All of the above
Which function returns the largest value of the column?
MIN()
MAX()
LARGE()
AVG()
In order to create the Index, we need to use which command?
ALTER
UPDATE
CREATE
ADD
Which keyword is used in SQL Server to implement the auto increment?
UNIQUE
IDENTITY
INCREMENT
ADD
What does COUNT() function returns?
Average value
Largest value
Smallest value
Number of rows
The ____ size of the result is shown by Script Quota.
Minimum
Maximum
Average
None of the above
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
Which function is used to obtain the month from the entire data stored in a table's column?
DATE
TIME
MONTH
DATE & TIME