Examen_bd_part2

A visually appealing illustration of a database with locks, SQL syntax, and a questioning figure, reflecting the themes of database security and SQL knowledge.

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

18 Questions4 MinutesCreated by QueryMaster527

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

For a table containing a single row with all attributes excepting PK containing NULL values, the "SELECT COUNT (*) FROM Table" will return:

NULL

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

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

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

Examen_bd_part2

Oracle Database Authentication and SQL Concepts Quiz

More Quizzes