Oracle 1Z0-071 Quiz 31 Topic 8 Questions 151-155

Question: 1

Which two statements are true regarding constraints? (Choose two.)

AA table can have only one primary key and one foreign key.

BA table can have only one primary key but multiple foreign keys.

COnly the primary key can be defined at the column and table levels.

DThe foreign key and parent table primary key must have the same name.

EBoth primary key and foreign key constraints can be defined at both column and table levels.

Show Answer

Question: 2

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:

$> sqlldr hr/hr@pdb table=employees

Which two statements are true regarding the command? (Choose two.)

AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

BIt fails because no SQL *Loader data file location is specified.

CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

DIt fails because no SQL *Loader control file location is specified.

Show Answer

Question: 3

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

ABy default, EM express is available for a database after database creation.

BYou can use EM express to manage multiple databases running on the same server.

CYou can perform basic administrative tasks for pluggable databases by using the EM express interface.

DYou cannot start up or shut down a database Instance by using EM express.

EYou can create and configure pluggable databases by using EM express.

Show Answer

Question: 4

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)

AALTER TABLE SPLIT PARTITION

BALTER TABLE MERGE PARTITION

CALTER TABLE TRUNCATE PARTITION

DALTER TABLE ADD PARTITION

EALTER TABLE DROP PARTITION

FALTER TABLE MOVE PARTITION

Show Answer

Question: 5

View the Exhibits and examine PRODUCTS and SALES tables.

Exhibit 1

q5_1Z0-071

Exhibit 2

q5_1Z0-071

You issue the following query to display product name the number of times the product has been sold:

q5_1Z0-071

What happens when the above statement is executed?

AThe statement executes successfully and produces the required output.

BThe statement produces an error because a subquery in the FROM clause and outer-joins cannot be used together.

CThe statement produces an error because the GROUP BY clause cannot be used in a subquery in the FROM clause.

DThe statement produces an error because ITEM_CNT cannot be displayed in the outer query.

Show Answer

Oracle 1Z0-071 Quiz:31 Topic:8 Questions:151-155