Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
A. Referential Integrity
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;
Column Name
Row Name
Table Name
None of the above
Data Multiplication Language
Data Manipulation Language
Data Modify Language
Data Mapping Language
Number
Character
Date
All of the above
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
DELETE
SELECT
UPDATE
ALTER
More
Less
Equal
None of the above
REMOVE
DELETE
DROP
TRUNCATE
Arithmetic
Comparison
Set
All of the above
Business rules are hidden.
Users or professionals can't have the full control over the database.
Both A and B
None of the above
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.
RENAME
ALTER
UPDATE
ADD
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.
2021-10-06 00:00:00.000
2021-10-06
2021 OCT 06
06-10-2021
String Data types
Numeric Data types
Date and time Data types
All of the above
A Primary Key cannot be NULL
A Foreign Key cannot be NULL
A Primary Key cannot be Duplicate
A Foreign Key can be Duplicate
It cannot ignore the NULL values
It can ignore the NULL values
Its query can return multiple values
None of the above
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
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
Time
Date
Date & Time
Day
The result is purged of duplicates
Duplicate records are not removed
Performs column-by-column comparisons
None of the above
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
Operators
Data Types
Numbers
Syntax
Only one row
All the rows
Only two rows
None of the above
Addition
Subtraction
Unary
Modulus
Primary Key
Foreign Key
Composite Key
Alternate Key
HAVING
GROUP BY
ORDER BY
None of the above
It increments the unique number automatically.
It decrements the unique number automatically.
It keeps the unique number constant
None of the above
Web server logs
When something weird occurs
Both A) and B)
None of the above
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;