Examen_bd_part2
Oracle Database Authentication and SQL Concepts Quiz
Test your knowledge on Oracle database authentication mechanisms and SQL concepts with this engaging quiz. Designed for database enthusiasts, this quiz challenges your understanding of key SQL operations and their implications.
- Multiple choice questions
- Covers topics from authentication to SQL aggregation
- Ideal for students and professionals alike
Which of the following does not represent a authentication mechanism supported by Oracle?
KERBEROS
RADIUS
PKI
DIAMETER
Multiple criteria in the parameter list are interpreted in a hierarchical manner in:
Both GROUP BY and ORDER BY.
ORDER BY, but not in the GROUP BY.
GROUP BY, but not in the ORDER BY.
Not in GROUP BY or ORDER BY.
The projection list of a SELECT query can contains a table attribute and a SQL aggregation function only if:
The attribute is included in the HAVING clause.
The attribute is included in the GROUP by clause.
The attribute is the primary key.
The attribute is a candidate key.
An SQl aggregation function cannot be used directly in:
A Subquery
A WHERE clause
A projection list
A HAVING clause
Is it a valid SQL query
The queries are correlated
The queries are uncorrelated
The query implements the intersection operation
10
Empty result
0
NULL
For a table containing a single row with all attributes excepting PK containing NULL values, the "SELECT COUNT (*) FROM Table" will return:
0
NULL
1
Nothing
To be union compatible two relations must have:
The same name for the primary key.
The same attributes, with the same names and types, in the same order.
The same set of indexes.
The same number of attributes with corresponding types in the same order
A tree index on the key <x1, x2, x3, x4> cannot be used to match the selection:
X3 = 7
X1= 6 and x2 = 9 and ×3 = 2 and ×4 = 25
x1 = 5 and ×2 > 5
X1 = 3
The projection list of the main query
The WHERE clause of the main query
The WHERE clause of the subquery
Neither clause,it is a valid query
A subquery used as operand of the IN operator must return:
A single scalar value
A tuple
A set of scalar values
A set of tuples
The full join operation can be implemented using the following operator:
DIFFERENCE
EXCEPT
UNION
INTERSECTION
The DISTINCT parameter will not have any effect for just one of the following SQL aggregation functions:
VARIANCE
SUM
MAX
AVG
A hash index on the key x1, x2, x3, ×4> can be used to match the selection;
x3 = 7
X1 = 5 and x2 > 5
X1= 6 and x2 = 9 and x3 = 2 and x4 = 25
x1 = 3
Rusty,Zorba
All sailors names
Empty result
Brutus
The cost of the query execution plan is not depending on:
The tuple sizes of the input relations.
The number of attributes of the input relations.
The cardinality of the input relations.
The sizes of the relations representing intermediary results
0
10
NULL
Empty result
Which of the following statements is not true about subqueries?
A subquery can be included in a FROM clause
A subquery can be included in a orolection list
A subquery can be included in a ORDER BY clause.
A subquery can be included in a WHERE clause
{"name":"Examen_bd_part2", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge on Oracle database authentication mechanisms and SQL concepts with this engaging quiz. Designed for database enthusiasts, this quiz challenges your understanding of key SQL operations and their implications.Multiple choice questionsCovers topics from authentication to SQL aggregationIdeal for students and professionals alike","img":"https:/images/course1.png"}