Oracle Database: Managing Multitenant Architecture Ed 1 Quiz Questions and Answers

To decide on a backup strategy for your organization, which of the following should you consider?

Answer :
  • Both RPO & RTO

Which option is correct regarding the multitenant database?

Answer :
  • Multitenant database must be created with CDB

What does CDB stand for?

Answer :
  • Container datbase

The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Answer :
  • True

The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

Answer :
  • True

The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Answer :
  • True

The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

Answer :
  • True

ORDER BY can be combined with the SELECT statements.

Answer :
  • True

SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.

Answer :
  • True

Which of the following are the five built-in functions provided by SQL?

Answer :
  • COUNT, SUM, AVG, MAX, MIN