To add a Primary Key constraint after table is created, which clause is used?
UPDATE
ADD
ALTER
JOIN
Correct Answer :
C. ALTER
To add a Primary key constraint after table is created, ALTER clause is used.
Related Questions
Which command will remove the records from the table, but not affect the structure of the table?
REMOVE
DELETE
DROP
TRUNCATE
Numbers of operand used by Binary Operators are?
1
2
3
4
Which statement is used to select the database in Oracle?
USE
SELECT
RENAME
None of the above
Which of the following is the type of SQL Injection attack?
It inserts the data
It updates the data
It deletes the data
All of the above
In order to create the Index, we need to use which command?
ALTER
UPDATE
CREATE
ADD
____ value is returned by the SQL Aggregate functions?
Single
Twice
NULL
Infinite
In which clause does the BETWEEN operator is used?
IF
AS
WHERE
EXCEPT
What does the INSERT INTO Statement do?
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.
A new database will be created through this SQL statement.
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
By executing this SQL statement, all records in the SQL database will be deleted.
What is the symbol of Concatenation Operator?
|
||
//
\
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
What is the work of SELECT command?
Database objects such as tables, table views, and other objects can be deleted using this command.
Database objects such as tables, table views, and other objects can be deleted using this command.
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
It enables you to create new databases, tables, table views, and other objects using this command.
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
What does the following statement do?
Finds any values that start with a
Finds any values that start with a%
Finds any values that contains only two characters starting with a
All of the above
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
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
Which of the following statement is TRUE for SQL Additional Operator?
SELECT operand1-operand2;
SELECT operand1*operand2;
SELECT operand1+operand2;
SELECT operand1>operand2;
Which of the following statement(s) is/are TRUE about DCL?
The DCL commands in SQL allow us to control which users have access to the data stored in SQL tables.
There will be certain privileges that each user has; consequently, the data can be accessed by them.
The DCL commands in SQL allow us to grant privileges to a user on the SQL database and its table(s), or revoke privileges that have already been granted.
All of the above
Which statement is not true about SQL?
Using SQL in relational databases is all about inserting, updating, and deleting data.
Sample data can also be described with the aid of this tool.
It helps develop relational database functions, events, and views.
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
NOW function is used to return the current
Time
Date
Date & Time
Day
Select the Aggregate function(s) among the following.
AVG()
FIRST()
LAST()
All of the above
What does the UPDATE Statement do?
By deleting the stored data, this SQL statement deletes the database.
A new table in SQL is created using this SQL statement.
The stored data in the SQL database is changed or modified by this SQL statement.
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
In the case of ____ Independence Rule, Physical independence of data to access the database is a requirement for a database or an application.
Physical Data
Logical Data
Integrity
Distribution
Which function combines the two different columns?
ADD
MERGE
CONCAT
None of the above
The records and structure of a table may be removed or deleted from the database using which command?
REMOVE
DELETE
DROP
TRUNCATE
In more readable form, you can retrieve the date values, using ______ function?
DATE
DATE_FORM
DATE_FORMAT
DATE_VALUE
SQL EXCEPT statement behaves similar to _____operator in mathematics.
Sum
Multiply
Minus
Divide
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
What is the full form of CTE in SQL?
Character Table Expressions
Character Table Evaluator
Common Table Evaluator
Common Table Expressions
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