What does the DROP TABLE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
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.
A new database will be created through this SQL statement.
Correct Answer :
A. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
The table, its structure, views, permissions, and triggers will also be deleted or removed with DROP TABLE SQL statement.
Related Questions
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
Which of the following is SQL Server Date and Time Data Type?
timestamp
sql_variant
real
text
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All 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.
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above
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 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.
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
Select the correct type(s) of SQL Comments.
Inline Comments
Single Line Comments
Multi-line Comments
All of the above
Network-based IDS can be used to monitor
Web server logs
When something weird occurs
All connections to the database server
None of the above
In case the CTE is wrong, it goes into
Infinite Loop
Null State
False State
True State
What does the following statement do?
Finds any values that end with a
Finds any values whose second character is a
Find any values that contains only two characters ending with a
Mysql > Savepoint ini;
Full form of TCL is -
Transaction Common Language
Transaction Commit Language
Transaction Concatenate Language
Transaction Control Language
The scalar functions operate on each record ____ in SQL.
Dependently
Independently
Interdependently
Intradependently
What does the DROP DATABASE Statement do?
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
A new database will be created through this SQL statement.
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
Select the correct method of Web SQL?
Execute SQL
Transaction
Open Database
All of the above
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
The Web SQL API is supported by
Opera
Google Chrome
Android Browsers
All 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
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None 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
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.
Concatenate
Virtual
View
None of the above
Which of the following statement is TRUE?
A DATABASE name can be renamed.
A TABLE name can be renamed.
Both A and B
None of the above
____ and ____constraints form the core of the PRIMARY KEY constraint.
NOT NULL , CHECK
NOT NULL , DEFAULT
NOT NULL , FOREIGN KEY
NOT NULL , UNIQUE
____ function extract characters from the text field.
LEN()
NOW()
MID()
FORMAT()
Which statement is true about the SQL?
SQL databases are vertically scalable.
SQL follows BASE Model.
SQL database cannot handle complex queries.
SQL database does not require object-relational mapping.
What is the difference between VARCHAR and VARCHAR2?
VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
There is no similarity between VARCHAR and VARCHAR2.
How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?
If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
Which function combines the two different columns?
ADD
MERGE
CONCAT
None of the above