When the table is dropped:
Table structure is dropped
Integrity constraints are dropped
Relationship is dropped
All of the above
Correct Answer :
D. All of the above
When the table is dropped, the table structure, integrity constraints, relationship and access privileges are dropped.
Related Questions
Which function returns the correct date and time?
DATE()
NOW()
TIME()
DATETIME()
Read in CRUD Operator means
To retrieve data
To fetch data
Both A. and B.
None of the above
When SELECT statements used to create Views contain ____ clauses, the views cannot be updated.
JOIN
HAVING
GROUP BY
All of the above
What is the syntax of SQL CAST Function?
CAST (expression AS [data type])
CAST (expression IN [data type])
CAST (expression TO [data type])
CAST (expression FOR [data type])
What is TRUE about NOT IN clause?
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
In order to format, how the column should be displayed, which function is used?
FORM()
DISPLAY()
COL()
FORMAT()
To rename the Index, we need to use which command?
RENAME
ALTER
UPDATE
ADD
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
What does the TRUNCATE TABLE Statement do?
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
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.
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.
Whenever a sub query appears in SQL, it is enclosed within ____ and placed to the ____ of the SQL operators.
Brackets, Left
Brackets, Right
Parenthesis, Left
Parenthesis, Right
Transaction is able to control the following
Transaction
Commit
Rollback
All of the above
Which of the following is/are transaction control commands in SQL?
Commit
Rollback
Both A. and B.
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
In order to remove an index, we need to use which command?
REMOVE
DELETE
DROP
DEL
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 order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
Which function is used to extract substrings from the column of the table
ROUND()
MID()
FORMAT()
NOW()
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None of the above
What is the symbol of Concatenation Operator?
|
||
//
\
Which one if these is used to put the same value in all the rows?
Group by unique column
Group by single column
Group by one column
Group by same value
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
To get a record from one table, which is not present in another table, we can use the clause
CONCAT
COPY
EXCEPT
ALTER
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
C in CRUD Operator means
To add or insert data
To retrieve or fetch data
To update the data
To delete the data
____ value is returned by the SQL Aggregate functions?
Single
Twice
NULL
Infinite
Command that comes under DML is/are
ROLLBACK
GRANT
UPDATE
All of the above