Which of the following statement is TRUE about Primary Key?
Table integrity is not enforced by the primary key.
The data in a primary key is always multiple.
900 bytes is the maximum length of a primary key.
Null values are allowed in primary keys.
Correct Answer :
C. 900 bytes is the maximum length of a primary key.
we can have up to 16 columns as primary key column and the total size of the key columns should be less than or equal to 900 bytes.
Related Questions
Select the statement which is TRUE?
In case a transaction is rolled back, the data allied with table variable also get rolled back.
In case a transaction is rolled back, the data allied with table variable does not roll back.
In case a transaction is not rolled back, the data allied with table variable get rolled back.
None of the above.
____ function extract characters from the text field.
LEN()
NOW()
MID()
FORMAT()
What does the following statement do?
Finds any values that start with or
Finds any value that contains only four characters and second, third characters are 'o', 'r'
Finds any values that have or in any position
None of the above
Which statement is TRUE about the ORDER BY Clause?
In order to return the rows in a specific order, ORDER BY Clause is used.
In order to group the rows, ORDER BY Clause is used.
In order to select the defined groups, ORDER BY Clause is used.
None of the above
The SQL Modulus Operator returns the,
Quotient
Percentage
Sum
Reminder
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
What does the CREATE TABLE Statement do?
The stored data in the SQL database is changed or modified by this SQL statement.
By deleting the stored data, this SQL statement deletes the database.
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.
In order to assign a random name to a column or table, which SQL SELECT Clause is used?
FROM
WHERE
HAVING
AS
In DBMS, table is known as _____ and row is known as _____.
Relation, Tuple
Tuple, Tuple
Tuple, Relation
Relation, Relation
BETWEEN operator is used with which SQL Statements
SELECT
DELETE
INSERT
All of the above
Transaction is able to control the following
Transaction
Commit
Rollback
All of the above
SQL Division operator divides the operand on the ____ side by the operand on the ____ side.
Left, Left
Right, Left
Left, Right
Right, Right
Name of the control in SQL Script
Script
Owner
Opinion
All of the above
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.
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.
What is the difference between nchar and nvarchar?
nchar is fixed and nvarchar is variable.
nchar is variable and nvarchar is fixed.
nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.
nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.
If multiple columns are used as Primary Key, it is known as
Unique
Composite
Foreign
None of the above
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 work of INSERT command?
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
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.
Which of the following statement is correct for SQL Multiplication Operator?
SELECT Operand1+Operand2;
SELECT Operand1*Operand2;
SELECT Operand1**Operand2;
SELECT Operand1
Select the correct constraint in SQL?
NOT NULL
CHECK
DEFAULT
All of the above
SET Operators are used to
Compile the results from two queries
Compile the results from three queries
Compile the results from four queries
Compile the results from five queries
Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?
REVOKE
COMMIT
ROLLBACK
SAVE
A Key which uniquely identifies each row in the table is known as?
Primary Key
Unique Key
Composite Key
Foreign Key
Scripts ____ from various workspaces can be imported through import.
Exported
Imported
Changed
Saved
Which of the following statement is true?
SQL statements are used for most operations in a database.
Relational algebra and tuple relationship calculus are needed for SQL syntax.
All of the above
None of the above
Which of the following is TRUE about SQL Concatenate?
It is also possible to combine more than two strings into one string.
Two columns of the table may be used to store the strings that are to be combined, or they may just be stored individually without being stored into the table.
When the concatenated strings are stored in separate columns of a table, they are stored in the column in which they were initially stored.
All of the above
In how many categories data types has been classified?
2
3
4
5
The ____ operator cannot be used with the sub query, but within it.
IN
INTO
BETWEEN
JOIN
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above