Join the discussion
Question 1/113
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
Correct Answer: D,E
Add Comments
- Other Question (113q)
- Q1. You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sale...
- Q2. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q3. Examine the description of the EMPLOYEES table: (Exhibit) Which query is valid?...
- Q4. Which two statements are true about the Oracle Data Dictionary?...
- Q5. Which three are types of segments in an Oracle Database? (Choose three.)...
- Q6. Which three statements are true about Oracle synonyms? (Choose three.)...
- Q7. Which two statements are true about the DUAL table? (Choose two.)...
- Q8. Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (C...
- Q9. You need to calculate the number of days from 1st January 2019 until today. Dates are stor...
- Q10. Which two statements are true about single row functions? (Choose two.)...
- Q11. Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOY...
- Q12. Which three statements are true about the Oracle join and ANSI join syntax? (Choose three....
- Q13. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q14. You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sale...
- Q15. Which statement is true about the INTERSECT operator used in compound queries?...
- Q16. The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different lo...
- Q17. Which two tasks can you perform using DBCA for databases? (Choose two.)...
- Q18. You want to apply the principle of Least Privilege in all your live databases. One of your...
- Q19. Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M...
- Q20. Which two statements are true about Enterprise Manager Database Express? (Choose two.)...
- Q21. Which three statements are true about connection strings and service names used to connect...
- Q22. In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CR...
- Q23. In which three situations does a new transaction always start? (Choose three.)...
- Q24. Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)...
- Q25. Examine the description of the EMPLOYEES table: (Exhibit) Which query is valid?...
- Q26. Which two statements are true about single row functions? (Choose two.)...
- Q27. Which three statements are true regarding single row subqueries?...
- Q28. Which two are true about instance recovery for a database that is open in read write mode?...
- Q29. Which three functions are performed by dispatchers in a shared server configuration? (Choo...
- Q30. You execute this command: (Exhibit) During the export operation, you detach from the job b...
- Q31. A database is configured to use automatic undo management with temporary undo enabled. An ...
- Q32. Examine these commands: (Exhibit) Which two statements are true about the sqlldr execution...
- Q33. Examine this command and some partial output: (Exhibit) Why does the DB01.abc.comservice s...
- Q34. Which three activities are recorded in the database alert log? (Choose three.)...
- Q35. Which two statements are true about the DUAL table? (Choose two.)...
- Q36. Which four statements are true regarding primary and foreign key constraints and the effec...
- Q37. Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level...
- Q38. The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type...
- Q39. You want to write a query that prompts for two column names and the WHERE condition each t...
- Q40. The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries ...
- Q41. Which three statements are true about sequences in a single instance Oracle database?...
- Q42. Which two statements are true about views used for viewing tablespace and datafile informa...
- Q43. Which three statements are true about table data storage in an Oracle Database? (Choose th...
- Q44. Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (C...
- Q45. Which two statements are true about trace files produced by the Oracle Database server? (C...
- Q46. Which two statements are true about Enterprise Manager Database Express? (Choose two.)...
- Q47. You want to use table compression suitable for OLTP that will: Compress rows for all DML s...
- Q48. You have been tasked to create a table for a banking application. One of the columns must ...
- Q49. You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sale...
- Q50. In which three situations does a new transaction always start? (Choose three.)...
- Q51. The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User...
- Q52. The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User...
- Q53. Which four account management capabilities can be configured using Oracle profiles? (Choos...
- Q54. Which three statements are true concerning logical and physical database structures? (Choo...
- Q55. Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)...
- Q56. Which two statements are true about single row functions? (Choose two.)...
- Q57. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q58. Which compression method is recommended for Direct-Path Insert operations?...
- Q59. Which three statements are true about data block storage in an Oracle Database?...
- Q60. In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces...
- Q61. Which three statements are true about table data storage in an Oracle Database? (Choose th...
- Q62. Which three statements are true about table data storage in an Oracle Database? (Choose th...
- Q63. Examine the description of the product_details table: (Exhibit) Which two statements are t...
- Q64. Examine these SQL statements which execute successfully: (Exhibit) Which two statements ar...
- Q65. Which is the default column or columns for sorting output from compound queries using SET ...
- Q66. An Oracle database session has an uncommitted transaction in progress which updated 5000 r...
- Q67. You execute this command: (Exhibit) During the export operation, you detach from the job b...
- Q68. Which two statements are true about the rules of precedence for operators? (Choose two.)...
- Q69. Which two statements are true about the rules of precedence for operators? (Choose two.)...
- Q70. You execute this command: (Exhibit) During the export operation, you detach from the job b...
- Q71. Examine this command: (Exhibit) Which two statements are true?...
- Q72. You execute this command: (Exhibit) Sufficient storage is available in filesystem /u01. Wh...
- Q73. A database is configured to use automatic undo management with temporary undo enabled. An ...
- Q74. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q75. Examine the description of the BOOKS_TRANSACTIONS table: (Exhibit)...
- Q76. Which three statements are true about advanced connection options supported by Oracle Net ...
- Q77. Which three statements are true about advanced connection options supported by Oracle Net ...
- Q78. In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces...
- Q79. Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements exe...
- Q80. Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements exe...
- Q81. The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary ...
- Q82. Which two tasks can you perform using DBCA for databases? (Choose two.)...
- Q83. Which two statements are true about Oracle synonyms?...
- Q84. You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sale...
- Q85. Which three are types of segments in an Oracle Database? (Choose three.)...
- Q86. Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two...
- Q87. Which two are true about shrinking a segment online? (Choose two.)...
- Q88. Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER....
- Q89. View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want t...
- Q90. You want to write a query that prompts for two column names and the WHERE condition each t...
- Q91. You want to apply the principle of Least Privilege in all your live databases. One of your...
- Q92. Which two statements are true regarding Oracle database space management within blocks man...
- Q93. Which three statements are true about inner and outer joins? (Choose three.)...
- Q94. Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level...
- Q95. Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)...
- Q96. The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary ...
- Q97. The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type...
- Q98. Examine the description of the employees table: (Exhibit) Which query requires explicit da...
- Q99. Examine the description of the CUSTOMERS table: (Exhibit) You want to display details of a...
- Q100. Which two tasks can you perform using DBCA for databases? (Choose two.)...
- Q101. Which two statements are true about the rules of precedence for operators? (Choose two.)...
- Q102. View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require ...
- Q103. Which two statements are true about Enterprise Manager Database Express? (Choose two.)...
- Q104. Which three statements are true about using SQL*Plus?...
- Q105. Which two statements are true about the PMON background process? (Choose two.)...
- Q106. Which two statements are true about substitution variables?...
- Q107. Which three activities are recorded in the database alert log? (Choose three.)...
- Q108. Examine the description of the CUSTOMERS table: (Exhibit) You want to display details of a...
- Q109. Which two statements are true about views used for viewing tablespace and datafile informa...
- Q110. Which three statements are true about time zones, date data types, and timestamp data type...
- Q111. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q112. View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want t...
- Q113. Which two are true about shrinking a segment online? (Choose two.)...
