A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
Correct Answer :
A. Primary Key
A Key which uniquely identifies each row in the table is known as Primary Key.
Related Questions
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
What is the full form of GUID?
Guided Unique Identifier
Guided Unique Interpreter
Globally Unique Identifier
Globally Unique Interpreter
What is the functionality of UCASE function?
To change the case of the string to lowercase characters.
To change the case of the string to uppercase characters.
To change the case of the string to numeric characters.
To change the case of the string to symbolic characters.
Number of operands used by Unary Operator is?
1
2
3
4
Rules that are needed to be followed in SET Operators in SQL are
All columns must be identical in number and order.
There must be compatibility between data types.
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
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
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None 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.
Select the correct statement.
DDL consist of 4 commands
DCL consist of 2 commands
TCL consist of 5 commands
DML consist of 3 commands
What is the meaning of Null Values in Systematic Treatment of Null Values in the 12 Codd's Rules?
No value in cell
Inappropriate Information
Unknown data
All of the above
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
Using the ___ statement, a database can be renamed.
SQL CREATE DATABASE
SQL RENAME DATABASE
SQL DROP DATABASE
SQL SELECT DATABASE
Determine the correct SQL command?
CREATE
UPDATE
DELETE
All of the above
What is TRUE about SQL EXCEPT clause?
The result is purged of duplicates
Duplicate records are not removed
Only one column can be compared by a clause
None of the above
Which of the following is TRUE about Savepoint command?
A transaction is marked in a table by this TCL command.
Imagine that you are making a long table, and you want to roll back only to a specific point in the table. You can do this with the savepoint.
In order to rollback part of a table rather than the entire table, a savepoint is useful.
All of the above
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
BETWEEN Operator returns the TRUE value if the column value is
<=Value1 & >=Value2
<=Value1 & <=Value2
>=Value1 & >=Value2
>=Value1 & <=Value2
MINUS Operator displays the rows which are
Detected in the second query, absent in the first query, and there are no duplications.
Detected in the first query, absent in the second query, and there are no duplications.
Detected in the first query, absent in the second query, and there are duplications.
Detected in the second query, absent in the first query, and there are duplications.
What is the difference between HAVING and WHERE clause?
HAVING clause is used in column operation whereas WHERE clause is used in row operation.
HAVING clause is post-filter whereas WHERE clause is pre-filter.
HAVING clause filters the groups whereas WHERE clauses filter the single record of the table.
All of the above
The numerical values of two ___ of the ___ table can be easily subtracted using SQL Subtraction Operator.
Rows, same
Columns, same
Rows, different
Columns, different
Comments whose starting and ending lines are different are known as
Inline Comments
Multi-line Comments
Single Line Comments
Varied line Comments
In order to build a link between two tables, which key is used?
Primary
Foreign
Composite
Unique
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above
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
You can also ____ the existing tables by using the UNIQUE constraint.
Change
Delete
Modify
Drop
Name of the operators in SET Operators is
UNION
INTERSECT
MINUS
All of the above
Which of the following is TRUE about the type of SQL Injection attack?
Install malicious program
Export valuable data
Get user login detail
All of the above
SQL has the advantage of?
SQL require a lot of programming.
SQL provides High-Speed Query Processing.
SQL follows the standard languages of ANSI and ISO.
SQL is easily portable.
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key