In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None of the above
Correct Answer :
A. DROP
DROP keyword is used to delete the database.
Related Questions
Select the correct syntax for Savepoint.
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
Select the correct rule of SQL EXCEPT.
There must be the same number of columns in each table and the same order in every select statement.
It is desirable that the columns have similar or compatible data types.
Both SELECT statements must have the same fields in their respective columns.
All of the above
What can be the maximum size of char(n) in SQL Server String Data Type?
7000
8000
9000
10000
What is the work of DELETE 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.
Database data can be updated or changed using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
Using this command, you can remove or erase recorded information from a database table.
It is possible to use LIKE clauses with
Strings
Numbers
Both A. and B.
None of the above
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.
ORDER BY clause comes ____ the EXCEPT clause in SQL statement?
Before
After
Flexible to before or after
None of the above
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
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 syntax is used to show all the databases?
USE DATABASES;
SELECT DATABASES;
SHOW DATABASES;
None of the above
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
What is TRUE about SAVEPOINT?
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction.
A transaction can be rolled back to its last saved state.
A specific part of a transaction can be given a name
None of the above
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
Which of the following is not MySQL String Data Type?
TEXT(Size)
TINYTEXT
MEDIUMTEXT
LARGETEXT
Which of the following is SQL Server Numeric Data Type?
image
nchar
money
cursor
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
What is the functionality of SQL COUNT?
It returns the no of record of table
It returns the no of record of database
It returns the no of record of row
It returns the no of record of column
A Sub query is an SQL expression that is placed ____ another SQL statement.
Before
After
Inside
Outside
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.
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.
Concatenate
Virtual
View
None of the above
Bit is an integer that can be
0
1
Null
All of the above
Which of the following is TRUE about Intrusion Detection System?
Intrusion Detection System is Network-based
Intrusion Detection System is Host-based
Both A) and B)
None of the above
In the case of the ____ Independence Rule, It shouldn't make a difference what the user sees (application) if the logical structure changes.
Physical Data
Logical Data
Integrity
Distribution
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.
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above
Select the function which is not the Scalar Function(s)?
UCASE()
LEN()
SUM()
NOW()
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All of the above
What does the SELECT Statement do?
Data is read from the SQL database by this statement and displayed to the database user.
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.
Read in CRUD Operator means
To retrieve data
To fetch data
Both A. and B.
None of the above