You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
Correct Answer :
C. Modify
You can also modify the existing tables by using the UNIQUE constraint.
Related Questions
Which statement is TRUE about the HAVING Clause?
In order to group the rows, HAVING Clause is used.
In order to return the rows, HAVING Clause is used.
In order to select the defined groups by the GROUP BY Clause, HAVING Clause is used.
None of the above
Which of the following is supported in Comprehensive Data SubLanguage Rule in the 12 Codd's Rules?
Data Definition
View Definition
Data Manipulation
All of the above
What is the difference between MIN and MAX function?
MIN function is used to show the minimum data and MAX function is used to show the maximum data.
MIN function is used to show the maximum data and MAX function is used to show the minimum data.
Both of the above
None of the above
To delete table definition and all data from the table, which statement is used?
DELETE
DROP
ALTER
None of the above
What is the shortcut key to open SQL Script?
Ctrl+Shift+S
Ctrl+Shift+Q
Ctrl+Shift+N
Ctrl+Shift+O
The scalar functions operate on each record ____ in SQL.
Dependently
Independently
Interdependently
Intradependently
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
The SELECT TOP statement shows the limited number of:
Rows
Columns
Tables
None of the above
Which of the following is among the 12 Codd's Rules?
View Updating Rule
Relational Level Operation Rule
Distribution Independence Rule
None of the above
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
____ are the columns for the retrieval purpose.
Tables
WHERE Conditions
Expressions
None of the above
A single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
How many temp tables are there?
1
2
3
4
What is TRUE about UNION ALL Operator?
The results of both queries are combined with this operator.
After performing the UNION ALL operation, duplicate rows will not be removed.
Both A and B
None of the above
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.
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
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
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
Savepoint command is used with _____ command.
Commit
Transaction
Rollback
None of the above
What is the clause to delete all rows from the table?
SQL DELETE ALL ROWS Table_Name;
SQL DELETE ROWS Table_Name;
DELETE FROM ALL ROWS Table_Name;
DELETE FROM Table_Name;
Select the correct order of precedence among the following?
OR > NOT > + > **
NOT > OR > ** > +
** > + > OR > NOT
** > + > NOT > OR
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
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
Read in CRUD Operator means
To retrieve data
To fetch data
Both A. and B.
None of the above
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
SQL Indexes slows the execution time of which statement(s)?
UPDATE
INSERT
SELECT
Both A and B
Transaction is able to control the following
Transaction
Commit
Rollback
All of the above
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All of the above