DROP
DELETE
ALTER
None of the above
A. DROP
Mysql > Transaction ini;
Mysql > &Savepoint;
Mysql > START Transaction;
Mysql > Savepoint ini;
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
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
7000
8000
9000
10000
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.
Strings
Numbers
Both A. and B.
None of the above
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.
Before
After
Flexible to before or after
None of the above
Quotient
Percentage
Sum
Reminder
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
USE DATABASES;
SELECT DATABASES;
SHOW DATABASES;
None of the above
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
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
Unique Keys
Alternate Keys
Composite Keys
None of the above
TEXT(Size)
TINYTEXT
MEDIUMTEXT
LARGETEXT
image
nchar
money
cursor
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
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
Before
After
Inside
Outside
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.
Concatenate
Virtual
View
None of the above
0
1
Null
All of the above
Intrusion Detection System is Network-based
Intrusion Detection System is Host-based
Both A) and B)
None of the above
Physical Data
Logical Data
Integrity
Distribution
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.
SELECT
UPDATE
INSERT
All of the above
UCASE()
LEN()
SUM()
NOW()
Number
Character
Date
All of the above
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.
To retrieve data
To fetch data
Both A. and B.
None of the above