In case of ____ data, recursive CTE is used?
Round
Hierarchal
Linear
None of the above
Correct Answer :
B. Hierarchal
In case of Hierarchal data, recursive CTE is used.
Related Questions
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
In order to start the transaction, the command used is
Mysql > START COMMIT;
Mysql > START TRANSACTION;
Mysql > START ROLLBACK;
None of the above
In order to insert a row directly in the table, which command is used?
INSERT IN
INSERT INSIDE
INSERT UNDER
INSERT INTO
Using the SQL first() function, one can return the ____ value of the selected column.
First
Second
Third
Last
What is the difference between VARCHAR and VARCHAR2?
VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.
VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.
Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.
There is no similarity between VARCHAR and VARCHAR2.
With export, you can ____ SQL Scripts from the SQL repositories in your workspace.
Export
Import
Save
Exchange
In the script field, script is found by entering the
Script Name
Script Number
Script ID
Script Symbol
To add a Primary Key constraint after table is created, which clause is used?
UPDATE
ADD
ALTER
JOIN
What is the keyword of the Ascending and Descending?
ASCE, DESC
ASC, DES
ASCE, DES
ASC, DESC
Which of the following is not a SQL Logical Operator?
SQL Equal Operator
SQL ANY Operator
SQL BETWEEN Operator
SQL IN Operator
Number of operands used by Unary Operator is?
1
2
3
4
Full form of DDL is
Data Describe Language
Definition Data Language
Data Definition Language
Data Distinct Language
Which of the following statement is TRUE about DISTINCT Clause?
Returns only Distinct values.
Only on the single column, it operates.
It can be used with the aggregates such as COUNT, AVG, etc.
All of the above
What will be the output of the below SQL statement?
25
26
25.65
25.00
With which of the following statement(s) can the SQL sub queries be used?
SELECT
UPDATE
INSERT
All of the above
TINYTEXT can hold the maximum length of ___ characters?
254
255
256
257
What is the difference between UNION & UNION ALL operators?
Combining the results of two select statements will be done using UNION whereas combined records from both queries are returned by UNION ALL operator.
Combining the results of two select statements will be done using UNION ALL whereas combined records from both queries are returned by UNION operator.
After performing the UNION operation, duplicate rows will not be removed whereas after performing the UNION ALL operation, duplicate rows will be removed.
None of the above
Using the DELETE Query from the CRUD Operator, we can delete
Only one row
All the rows
Only two rows
None of the above
What is the work of CREATE command?
Using this command, you can remove or erase recorded information from a database table.
It enables you to create new databases, tables, table views, and other objects using this 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.
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
What is the clause to delete all rows from the table?
SQL DELETE ALL ROWS Table_Name;
SQL DELETE ROWS Table_Name;
DELETE FROM ALL ROWS Table_Name;
DELETE FROM Table_Name;
SQL BETWEEN operators include
Starting Value
In Between Value
Ending Value
All of the above
In SQL SELECT COUNT, one needs to specify the
Column Name
Row Name
Table Name
None of the above
Output returned by the Scalar functions is/are -
Single Value
Multiple Value
Two Values
None of the above
What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?
Both CLOB and NCLOB are used for multibyte national character set data.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.
Both CLOB and NCLOB can range upto 2^32-1 bytes or 8GB.
Both CLOB and NCLOB are used for singlebyte and multibyte national character set data.
What is the syntax of SQL CAST Function?
CAST (expression AS [data type])
CAST (expression IN [data type])
CAST (expression TO [data type])
CAST (expression FOR [data type])
Which of the following statement is correct?
Comparison Operator has higher precedence than Conjuction Operator.
Identity Operator has higher precedence than Multiplication Operator.
Both A and B
None of the above
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 single unit of work for all commands executed consecutively is known as-
Transaction
Commit
Rollback
Control
In case to prevent the endless loop in CTE, ____ is added.
MAXLINEAR
MAXROUND
MAXRECURSION
None of the above
Which of the following is SQL Server Numeric Data Type?
image
nchar
money
cursor