Join the discussion
Question 1/127
Which two are true about shrinking a segment online? (Choose two.)
Correct Answer: C,E
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
Add Comments
- Other Question (127q)
- Q1. Which two are true about shrinking a segment online? (Choose two.)...
- Q2. Examine this command: (Exhibit) Which two statements are true? (Choose two.)...
- Q3. Which two statements are true about space-saving features in an Oracle Database? (Choose t...
- Q4. The sales table has columns prod_id and quantity_sold of data type number In two queries e...
- Q5. Which two statements are true about the PMON background process? (Choose two.)...
- Q6. Which two statements are true about trace files produced by the Oracle Database server? (C...
- Q7. Which two statements are true about Enterprise Manager (EM) Express?...
- Q8. Which three statements are true about advanced connection options supported by Oracle Net ...
- Q9. Which two statements are true about Database Instances and Real Application Clusters (RAC)...
- Q10. In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces...
- Q11. You need to calculate the number of days from 1st January 2019 until today. Dates are stor...
- Q12. Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. E...
- Q13. Which two statements are true about the PMON background process? (Choose two.)...
- Q14. Which three statements are true about dropping and unused columns in an Oracle database? (...
- Q15. Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M...
- Q16. Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOY...
- Q17. You want to use table compression suitable for OLTP that will: 1. Compress rows for all DM...
- Q18. Which two statements are true about trace files produced by the Oracle Database server? (C...
- Q19. Which two are true about instance recovery for a database that is open in read write mode?...
- Q20. Examine the description of the BOOKS table: (Exhibit) The table has 100 rows. Examine this...
- Q21. Examine the description of the SALES1 table: (Exhibit) SALES2 is a table with the same des...
- Q22. In one of your databases, the user HR has the password HRMGR. You want to connect to a dat...
- Q23. Which three statements are true concerning logical and physical database structures? (Choo...
- Q24. Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level...
- Q25. You want to use table compression suitable for OLTP that will: Compress rows for all DML s...
- Q26. Which three functions are performed by dispatchers in a shared server configuration? (Choo...
- Q27. The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different lo...
- Q28. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q29. Examine these SQL statements which execute successfully: (Exhibit) Which two statements ar...
- Q30. Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level...
- Q31. You need to calculate the number of days from 1st January 2019 until today. Dates are stor...
- Q32. Which three statements are true regarding single row subqueries?...
- Q33. Examine the description of the customers table: (Exhibit) You need to display last names a...
- Q34. The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries ...
- Q35. In one of your databases, user KING is: 1. Not a DBA user 2. An operating system (OS) user...
- Q36. Which four account management capabilities can be configured using Oracle profiles? (Choos...
- Q37. The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User...
- Q38. Which compression method is recommended for Direct-Path Insert operations?...
- Q39. Which two actions can you perform using DBCA for an existing database?...
- Q40. What is true about non-equijoin statement performance? (Choose two.)...
- Q41. Which two statements are true about Enterprise Manager Database Express? (Choose two.)...
- Q42. The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different lo...
- Q43. View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require ...
- Q44. Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level...
- Q45. Which three statements are true about single-row functions? (Choose three.)...
- Q46. Which three Oracle database space management features will work with both Dictionary and L...
- Q47. Which two statements are true regarding Oracle database space management within blocks man...
- Q48. Which three statements are true about Oracle synonyms? (Choose three.)...
- Q49. Which three are types of segments in an Oracle Database? (Choose three.)...
- Q50. Examine the description of the BOOKS_TRANSACTIONS table: (Exhibit)...
- Q51. Which two statements are true about the DUAL table? (Choose two.)...
- Q52. Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)...
- Q53. Which three failures do not require intervention for recovery? (Choose three.)...
- Q54. Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You wa...
- Q55. The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary ...
- Q56. Which is true about security rules on a compute node?...
- Q57. Which three statements are true about Deferred Segment Creation in Oracle databases?...
- Q58. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q59. Which three statements are true about views in an Oracle database? (Choose three.)...
- Q60. Which three statements are true concerning logical and physical database structures? (Choo...
- Q61. Which three statements are true about dropping and unused columns in an Oracle database? (...
- Q62. While one of your databases was in mount state, the datafiles were renamed because they ha...
- Q63. Which two statements are true about the DUAL table? (Choose two.)...
- Q64. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q65. Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOY...
- Q66. Which three statements are true about the Oracle join and ANSI join syntax? (Choose three....
- Q67. Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (C...
- Q68. Which two statements are true about trace files produced by the Oracle Database server? (C...
- Q69. Which three object types support deferred segment creation? (Choose three.)...
- Q70. Which three are types of segments in an Oracle Database? (Choose three.)...
- Q71. Which four statements are true regarding primary and foreign key constraints and the effec...
- Q72. You want to apply the principle of Least Privilege in all your live databases. One of your...
- Q73. Examine the description of the PRODUCT_STATUS table: (Exhibit) The status column contains ...
- Q74. You want to apply the principle of Least Privilege in all your live databases. One of your...
- Q75. Which three are true about the Oracle Optimizer? (Choose three.)...
- Q76. Which three statements are true about the Automatic Diagnostic Repository (ADR)?...
- Q77. Examine these commands: (Exhibit) Which two statements are true about the sqlldr execution...
- Q78. Which three statements are true about sequences in a single instance Oracle database?...
- Q79. The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User...
- Q80. You want to apply the principle of Least Privilege in all your live databases. One of your...
- Q81. Which three statements are true about inner and outer joins? (Choose three.)...
- Q82. A database is configured to use automatic undo management with temporary undo enabled. An ...
- Q83. Which three statements are true about the Oracle Data Dictionary? (Choose three.)...
- Q84. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q85. Which two statements are true regarding a SAVEPOINT? (Choose two.)...
- Q86. Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHER...
- Q87. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q88. A script abc.sql must be executed to perform a job. A database user HR, who is defined in ...
- Q89. Which three statements are true about data block storage in an Oracle Database?...
- Q90. The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User...
- Q91. Which two are true about shrinking a segment online? (Choose two.)...
- Q92. Which three statements are true about the tools used to configure Oracle Net Services? (Ch...
- Q93. You have been tasked to create a table for a banking application. One of the columns must ...
- Q94. A database is configured to use automatic undo management with temporary undo enabled. An ...
- Q95. You execute this command: (Exhibit) During the export operation, you detach from the job b...
- Q96. Which two statements are true about the results of using the INTERSECT operator in compoun...
- Q97. An Oracle database session has an uncommitted transaction in progress which updated 5000 r...
- Q98. Evaluate these commands which execute successfully: (Exhibit) Which two statements are tru...
- Q99. Which two are true about shrinking a segment online? (Choose two.)...
- Q100. Examine the description of the EMPLOYEES table: (Exhibit) Which query is valid?...
- Q101. Which three activities are recorded in the database alert log? (Choose three.)...
- Q102. What two are benefits of Data Pump? (Choose two.)...
- Q103. Which three statements are true about views in an Oracle database? (Choose three.)...
- Q104. Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE `undotbs_01.dbf' SIZE 100M...
- Q105. Which two tasks can you perform using DBCA for databases? (Choose two.)...
- Q106. Examine the description of the BOOKS table: (Exhibit) The table has 100 rows. Examine this...
- Q107. The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary ...
- Q108. A user complains about poor database performance. You suspect that the user's session is w...
- Q109. Which two statements are true about segment types in an Oracle Database?...
- Q110. Which two tasks can you perform using DBCA for databases? (Choose two.)...
- Q111. Which two statements are true about Enterprise Manager Database Express? (Choose two.)...
- Q112. View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require ...
- Q113. Which two statements are true about Enterprise Manager Database Express? (Choose two.)...
- Q114. Which two statements are true about the results of using the INTERSECT operator in compoun...
- Q115. Which three are types of segments in an Oracle Database? (Choose three.)...
- Q116. Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You wa...
- Q117. In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A s...
- Q118. In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CR...
- Q119. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q120. You want to write a query that prompts for two column names and the WHERE condition each t...
- Q121. Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOY...
- Q122. Which two are true about the roles? (Choose two.)...
- Q123. Which three statements are true about inner and outer joins? (Choose three.)...
- Q124. Which three statements are true about table data storage in an Oracle Database? (Choose th...
- Q125. Your database instance is started with an SPFILE. A PFILE is also available. You execute t...
- Q126. Which statement is true about database links?
- Q127. Which three statements are true about the tools used to configure Oracle Net Services? (Ch...
