Which statement is true about the No-SQL?
No-SQL follows ACID Model.
No-SQL does require object-relational mapping.
Dynamic schemas for unstructured data are used in No-SQL databases.
No-SQL databases are not preferable for storage of hierarchal data.
Correct Answer :
C. Dynamic schemas for unstructured data are used in No-SQL databases.
Dynamic schemas for unstructured data are used in No-SQL databases. No-SQL follows BASE Model. No-SQL does not require object-relational mapping. No-SQL databases are preferable for the storage of hierarchal data.
Related Questions
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
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.
Using which SQL Comparison Operator can we find the data that matches our query?
SQL Not Equal Operator (!=)
SQL Equal Operator (=)
SQL Greater Than Operator (>)
SQL Less Than Operator (<)
Which statement is not true about SQL?
Using SQL in relational databases is all about inserting, updating, and deleting data.
Sample data can also be described with the aid of this tool.
It helps develop relational database functions, events, and views.
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
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.
What does task list consist of in SQL Script?
Import
Show Quotas
Manage Results
All of the above
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
Select the correct statement.
With the DDL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DML commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the DCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
With the TCL commands, any structural changes can be made to the table, including creation, deletion, and alteration.
Which of the following statement is TRUE?
A DATABASE name can be renamed.
A TABLE name can be renamed.
Both A and B
None of the above
We can use literal in the CONCAT function. What does literal refer to?
Number
Character
Date
All of the above
In how many parts are the SQL functions are divided into?
1
2
3
4
The character(s) which are used independently or in conjunction with SQL Like Operator:
%
_
Both A. and B.
None of the above
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.
Which of the following keyword is used to delete the Join?
DELETE
ON
WHERE
All of the above
Transaction is able to control the following
Transaction
Commit
Rollback
All 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;
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
When an expression includes ___ SQL operator(s), the sequence in which they are evaluated is known as the SQL operator's precedence.
0
1
Multiple
NULL
Which of the following is supported in Comprehensive Data SubLanguage Rule in the 12 Codd's Rules?
Data Definition
View Definition
Data Manipulation
All 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
For integer value, which data type is supported in Oracle?
INT
Number
Digit
None of the above
A Primary Key is basically a
Row
Column
Table
Database
How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?
If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().
If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().
If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().
If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().
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 INTO statement -
Select the content from a table.
Rename the content in a table.
Copy the content from one table into another existing table.
None of the above
Which function combines the two different columns?
ADD
MERGE
CONCAT
None 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.
Select the correct syntax of SELECT TOP clause?
SELECT TOP name
SELECT TOP column
SELECT TOP FROM
SELECT TOP Number
Select the correct method of Web SQL?
Execute SQL
Transaction
Open Database
All of the above
Which of the following states the correct situation in which Indexes should not be used in SQL?
When the table is small, it is possible to avoid using SQL indexes.
Updates need to be made frequently to the table.
When there are a lot of NULL values in a column, indexed should not be used.
All of the above