____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
Correct Answer :
A. Referential Integrity
Referential integrity is achieved by using a foreign key.
Related Questions
Which syntax is correct for RENAME DATABASE in SQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
Full form of DML is
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All of the above
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
SQL Like is NOT used with which of the following statement(s)?
DELETE
SELECT
UPDATE
ALTER
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
Which command will remove the records from the table, but not affect the structure of the table?
REMOVE
DELETE
DROP
TRUNCATE
Which of these are the types of operators?
Arithmetic
Comparison
Set
All of the above
What is meant by Partial Database Control?
Business rules are hidden.
Users or professionals can't have the full control over the database.
Both A and B
None of the above
What does the COMMIT Statement do?
The data specified in this table or view is reported in this SQL statement.
Changes made in the SQL database transaction are permanently saved using this SQL statement.
Specify the columns of the table in this SQL statement to return distinct values.
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
To rename the Index, we need to use which command?
RENAME
ALTER
UPDATE
ADD
What does the DROP INDEX Statement do?
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
The SQL database table's index is deleted using this SQL statement.
An index is created in a SQL database table with this SQL statement.
An existing SQL database is selected with this SQL statement. A database must be selected from several existing databases before you can perform operations on the table.
What will be the output of the below SQL statement?
2021-10-06 00:00:00.000
2021-10-06
2021 OCT 06
06-10-2021
Name of the data type categories are,
String Data types
Numeric Data types
Date and time Data types
All of the above
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
Which of the following statement is TRUE about DISTINCT Clause?
It cannot ignore the NULL values
It can ignore the NULL values
Its query can return multiple values
None of the above
What is the keyword of the Ascending and Descending?
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
What is TRUE about the Active/Dynamic Online Catalog based on the relational model in the 12 Codd's Rules?
The primary key value, table name, and column name are characteristics that allow us to access the precise data (atomic value) logically from a relational database.
Null values are treated in database records according to this rule.
Database dictionaries represent the complete logic of all descriptive data, which must be stored online.
None of the above
NOW function is used to return the current
Time
Date
Date & Time
Day
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
Select the correct statement about SQL Scripts?
At the run time, the SQL*Plus commands are ignored.
SQL Scripts and SQL Commands in the SQL Scripts have no interaction.
Through the SQL Script editor, SQL Commands are cut and pasted.
All of the above
Using a WHERE clause in a SQL query is used to specify SQL reserved words and characters, known as ____?
Operators
Data Types
Numbers
Syntax
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
Which of the following is NOT the SQL Arithmetic Operator?
Addition
Subtraction
Unary
Modulus
Unique Index is similar to
Primary Key
Foreign Key
Composite Key
Alternate Key
In order to sort the records according to the columns, which clause is used?
HAVING
GROUP BY
ORDER BY
None of the above
Which of the following is TRUE about SQL Auto Increment?
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
Host-based IDS can be used to monitor
Web server logs
When something weird occurs
Both A) and B)
None of the above
Which syntax is correct for RENAME DATABASE in MySQL?
RENAME old_database_name TO new_database_name;
RENAME DATABASE old_database_name TO new_database_name;
ALTER old_database_name MODIFY NAME = new_database_name;
ALTER DATABASE old_database_name MODIFY NAME = new_database_name;