In the case of ____ Independence Rule, if using the SQL queries language to insert data into table's cells, the database must maintain integrity independence.
Interdependent
Intradependent
Integration
Integrity
Correct Answer :
D. Integrity
In the case of the Integrity Independence Rule, if using the SQL queries language to insert data into table's cells, the database must maintain integrity independence.
Related Questions
Commands that comes under DDL is/are
CREATE
DROP
TRUNCATE
All of the above
Which of the following clause cannot be used in SQL sub queries?
GROUP BY
ORDER BY
DELETE
FROM
In order to manage or store the data in the database, WEB SQL Database is used which is a
Web site
Web page
Web browser
None of the above
What is the difference between nvarchar and ntext?
nvarchar is fixed and ntext is variable.
nvarchar is variable and ntext is fixed.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 1GB of the text data.
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
Which of the following constraints are TRUE to be put in Password system?
One uppercase character must be included in the password.
An eight-character minimum password is required.
At least one symbol must appear in the password.
All of the above
Combining the results of ___ select statements will be done using UNION.
One
Two
Three
Four
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
Which of the following are not MySQL Date and Time Data Type?
DATE
TIME(fsp)
YEAR
None of the above
A Sub query is an SQL expression that is placed ____ another SQL statement.
Before
After
Inside
Outside
Which statement is not true?
SQL is rational whereas No-SQL is non-rational.
SQL follows BASE Model whereas No-SQL follows ACID Model.
SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
No-SQL databases are preferable to store hierarchical data in comparison SQL databases.
Network-based IDS can be used to monitor
Web server logs
When something weird occurs
All connections to the database server
None of the above
Which of the following is TRUE about TCL?
Transactions can be saved to the database and rolled back with the help of TCL commands in SQL.
There will be certain privileges that each user has; consequently, the data can be accessed by them using TCL.
Our data is stored in a table that is described by the schema, thus TCL commands deal with the schema.
SQL TCL commands can be used to perform any kind of retrieval or manipulation of the data present in SQL tables.
To get the table's previous permanent status, use the ____ command.
Commit
Transaction
Rollback
None of the above
What is the work of DROP command?
Using this command, you can remove or erase recorded information from a database table.
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.
What is Export Script by default?
Workspace_name_size/sql
Workspace_number_script/sql
Workspace_name_script/sql
Workspace_name_script/spl
In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
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
Which command will remove the records from the table, but not affect the structure of the table?
REMOVE
DELETE
DROP
TRUNCATE
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;
Which of the following is not an SQL Statement?
SELECT Statement
UPDATE Statement
TRUNCATE TABLE Statement
FROM Statement
Select the correct statement.
TRUNCATE TABLE is faster than DELETE TABLE statement.
TRUNCATE TABLE uses fewer resources than DELETE TABLE statement.
Both A) and B)
None of the above
Comments whose starting and ending lines are different are known as
Inline Comments
Multi-line Comments
Single Line Comments
Varied line Comments
Select the correct statement.
DDL consist of 4 commands
DCL consist of 2 commands
TCL consist of 5 commands
DML consist of 3 commands
In order to delete duplicate rows from the table, which keyword is used?
DELETE
DISTINCT
FROM
WHERE
What does UCASE() function do?
Converts database field to uppercase
Converts database field to lowercase
Returns the length of the text field
Returns the current date and time
____ integrity is achieved by using a foreign key.
Referential Integrity
Domain Integrity
User-defined Integrity
Entity Integrity
Temporary variables use ____ resources than table variables.
More
Less
Equal
None of the above
In order to delete the database, which keyword is used?
DROP
DELETE
ALTER
None of the above