1Z0-071 practice questions 181–190

1. Question 181 · 238 in bank

   Select 2

   Which two statements are true about an Oracle database? (Choose two.)

   • AA table can have multiple primary keys.
   • BA column definition can specify multiple data types.
   • CA table can have multiple foreign keys.
   • DA VARCHAR2 column without data has a NULL value.
   • EA NUMBER column without data has a zero value.

   Show answer

   Answer: CD

   Next question

2. Question 182 · 238 in bank

   Examine the data in the EMP table:

   

   You execute this query:

   

   Why does an error occur?

   • AAn alias name must not contain space characters.
   • BAn alias name must always be specified in quotes.
   • CAn alias name must not be used in an ORDER BY clause.
   • DAn alias name must not be used in a GROUP BY clause.

   Show answer

   Answer: D

   Next question

3. Question 183 · 238 in bank

   Select 2

   Which two actions can you perform with object privileges? (Choose two.)

   • ACreate roles.
   • BCreate FOREIGN KEY constraints that reference tables in other schemas.
   • CDelete rows from tables in any schema except SYS.
   • DSet default and temporary tablespaces for a user.
   • EExecute a procedure or function in another schema.

   Show answer

   Answer: BE

   Explanation

   BE A : False. Creating role is system privilege. B : True. Use REFERENCE privilege. C : False. Use DELETE ANY TABLE system privilege. D : False? E : True. Use EXECUTE privilege.

   Source: Adapted from community discussion — heoj10272

   References

   • Oracle documentation

   Next question

4. Question 184 · 238 in bank

   Select 2

   Which two are true? (Choose two.)

   • AADD_MONTHS adds a number of calendar months to a date.
   • BCEIL requires an argument which is a numeric data type.
   • CCEIL returns the largest integer less than or equal to a specified number.
   • DLAST_DAY returns the date of the last day of the current month only.
   • ELAST_DAY returns the date of the last day of the month for the date argument passed to the function.
   • FLAST_DAY returns the date of the last day of the previous month only.

   Show answer

   Answer: AE

   Explanation

   maby AE is Right... C. CEIL returns the largest integer less than or equal to a specified number. Can change : CEIL returns the minmum integer more than or equal to a specified number

   Source: Adapted from community discussion — Peter_Chen

   References

   • Oracle documentation
   • Oracle documentation
   • Oracle documentation
   • Oracle documentation

   Next question

5. Question 185 · 238 in bank

   Select 3

   No user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)? (Choose three.)

   • AROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks, and erases all its savepoints.
   • BROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
   • CROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
   • DROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint and then ends the transaction.
   • ECOMMIT ends the transaction and makes all its changes permanent.
   • FCOMMIT erases all the transaction's savepoints and releases its locks.

   Show answer

   Answer: AEF

   Next question

6. Question 186 · 238 in bank

   Select 2

   Which three are true about dropping columns from a table? (Choose three.)

   • AA column must be set as unused before it is dropped from a table.
   • BA primary key column cannot be dropped.
   • CMultiple columns can be dropped simultaneously using the ALTER TABLE command.
   • DA column can be removed only if it contains no data.
   • EA column that is referenced by another column in any other table cannot be dropped.
   • FA column drop is implicitly committed.

   Show answer

   Answer: CF

   Explanation

   You can drop a column that is referenced by another column with CASCADE CONSTRAINTS clause (E), so I only find here 2 correct answers (CF)

   Source: Adapted from community discussion — alelejaja

   Next question

7. Question 187 · 238 in bank

   Select 3

   Which three statements are true about views in an Oracle Database? (Choose three.)

   • AA SELECT statement cannot contain a WHERE clause when querying a view containing a WHERE clause in its defining query.
   • BViews have no segment.
   • CViews have no object number.
   • DViews can join tables only if they belong to the same schema.
   • EA view can be created that refers to a non-existent table in its defining query.
   • FRows inserted into a table using a view are retained in the table if the view is dropped.

   Show answer

   Answer: BEF

   Explanation

   select object_id, object_name from user_objects In this table you will also find views so they do have an object number. Views have no segment since they don't take up physical space

   Source: Adapted from community discussion — TheOracleWasTaken

   Next question

8. Question 188 · 238 in bank

   Select 2

   You start a session and execute these commands successfully:

   

   Which two are true? (Choose two.)

   • ATo drop the table in this session, you must first truncate it.
   • BOther sessions can view the committed row.
   • CYou can add a column to the table in this session.
   • DYou can add a foreign key to the table.
   • EWhen you terminate your session, the row will be deleted.

   Show answer

   Answer: AE

   Explanation

   1. CREATE GLOBAL TEMPORARY TABLE my_temp_table ( id NUMBER, description VARCHAR2(20) ) ON COMMIT PRESERVE ROWS 2. INSERT INTO my_temp_table VALUES (1, 'ONE'); 3. Commit; 4. ALTER TABLE my_temp_table ADD ID_1 VARCHAR(20); --> ORA-14450: attempt to access a transactional temp table already in use 5. drop table my_temp_table; --> ORA-14452: attempt to create, alter or drop an index on temporary table already in use 6. truncate table my_temp_table; 7. drop table my_temp_table;

   Source: Adapted from community discussion — Kashka

   Next question

9. Question 189 · 238 in bank

   Select 2

   Examine this statement:

   

   Which two statements are true? (Choose two.)

   • AThe names of employees earning the maximum salary will appear first in an unspecified order.
   • BAll remaining employee names will appear in descending order.
   • CAll remaining employee names will appear in an unspecified order.
   • DAll remaining employee names will appear in ascending order.
   • EThe names of employees earning the maximum salary will appear first in ascending order.
   • FThe names of employees earning the maximum salary will appear first in descending order.

   Show answer

   Answer: DF

   Explanation

   I tested it and these answers are correct. Employees which have not a highest salary appear in ascending order and it's true because ELSE starts working and it sorts by last_name ASC(as default for sorting without giving any postfix). But the second answer, F one is interesting because where it appear, depends from a character after THEN. We have 'A' now and employees with highest salary comes first but when I replace it by 'B' employees appear from 5th row, by 'C' from 14th row. It sorts by last_name DESC, take it from end of query'.

   Source: Adapted from community discussion — karols32

   Next question

10. Question 190 · 238 in bank

    Select 2

    Which two are true about external tables that use the ORACLE_DATAPUMP access driver? (Choose two.)

    • AWhen creating an external table, data can be selected only from a table whose rows are stored in database blocks.
    • BCreating an external table creates a directory object.
    • CWhen creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.
    • DCreating an external table creates a dump file that can be used by an external table in the same or a different database.
    • ECreating an external table creates a dump file that can be used only by an external table in the same database.

    Show answer

    Answer: CD

    References

    • Oracle documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

1Z0-071 practice, question 181. 238 questions available.