1z1-071 무료 덤프문제 온라인 액세스

Which two statements are true about Data Manipulation Language (DML) statements?

• A.A DELETE FROM ..... statement can remove rows based on only a single condition on a table.
• B.AH INSERT INTO. . .VALUES. . statement can add multiple rows per execution to a table.
• C.An UPDATE...SET.... statement can modify multiple rows based on only a single condition on a table.
• D.An INSERT INTO...VALUES..... statement can add a single row based on multiple conditions on a table.
• E.An UPDATE...SET... statement can modify multiple rows based on multiple conditions on a table.
• F.A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

BOOK_SEQis an existing sequence in your schema.
Which two CREATE TABLEcommands are valid? (Choose two.)

• A.
• B.
• C.
• D.
• E.

Which three are true about privileges and roles? (Choose three.)

• A.A role can contain a combination of several privileges and roles.
• B.PUBLIC can be revoked from a user.
• C.A role is owned by the user who created it.
• D.System privileges always set privileges for an entire database.
• E.PUBLIC acts as a default role granted to every user in a database.
• F.All roles are owned by the SYS schema.
• G.A user has all object privileges for every object in their schema by default.

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)

• A.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into and no explicit value is given for ORD_NO.
  ORD_ITEMS
• B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.
• C.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.
• D.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.
• E.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

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?

• A.It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
• B.It fails because no SQL *Loader control file location is specified.
• C.It fails because no SQL *Loader data file location is specified.
• D.It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.