Join the discussion
Question 73/119
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
* Be stored in a format supporting date arithmetic without using conversion functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?
One of the columns must meet three requirements:
* Be stored in a format supporting date arithmetic without using conversion functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?
Correct Answer: E
Add Comments
- Other Question (119q)
- Q1. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q2. Which two statements are true about single row functions? (Choose two.)...
- Q3. In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties: 1. A s...
- Q4. You want to apply the principle of Least Privilege in all your live databases. One of your...
- Q5. Which two are true about conventional path SQL load? (Choose two.)...
- Q6. Which two are true about shrinking a segment online? (Choose two.)...
- Q7. Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)...
- Q8. Examine this description of the books table containing 100 rows: (Exhibit) Now examine thi...
- Q9. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q10. In one of your databases, the user HR has the password HRMGR. You want to connect to a dat...
- Q11. The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of ...
- Q12. Which three statements are true about the tools used to configure Oracle Net Services? (Ch...
- Q13. Which two statements are true about the rules of precedence for operators? (Choose two.)...
- Q14. Evaluate these commands which execute successfully: (Exhibit) Which two statements are tru...
- Q15. Examine this command and some partial output: (Exhibit) Why does the DB01.abc.comservice s...
- Q16. Which three statements are true about single-row functions? (Choose three.)...
- Q17. Examine the description of the BOOKS table: (Exhibit) The table has 100 rows. Examine this...
- Q18. Examine the description of the PROMOTIONS table: (Exhibit) You want to display the unique ...
- Q19. Which two are true about RETENTION GUARANTEE? (Choose two.)...
- Q20. Which three statements are true about external tables in Oracle 18c and later releases? (C...
- Q21. Which two statements are true about the Oracle Data Dictionary?...
- Q22. Which two are true about shrinking a segment online? (Choose two.)...
- Q23. The stores table has a column START_DATE of data type DATE, containing the date the row wa...
- Q24. Which two statements are true about Enterprise Manager Database Express? (Choose two.)...
- Q25. Which statement is true about aggregate functions?...
- Q26. Which three statements are true about single-row functions? (Choose three.)...
- Q27. In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CR...
- Q28. Examine this command and some partial output: (Exhibit) Why does the DB01.abc.com service ...
- Q29. Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (C...
- Q30. In one of your databases, the user HR has the password HRMGR. You want to connect to a dat...
- Q31. Which two statements are true about the results of using the INTERSECT operator in compoun...
- Q32. Which three statements are true about advanced connection options supported by Oracle Net ...
- Q33. Evaluate these commands which execute successfully: (Exhibit) Which two statements are tru...
- Q34. Which statement is true about database links?
- Q35. You want to use table compression suitable for OLTP that will: 1. Compress rows for all DM...
- Q36. The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type...
- Q37. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q38. Examine this command and some partial output: (Exhibit) Why does the DB01.abc.com service ...
- Q39. Which two types of files are opened by a database instance in the NOMOUNT state?...
- Q40. The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different lo...
- Q41. Which two statements are true about views used for viewing tablespace and datafile informa...
- Q42. Which three statements are true about undo segments and the use of undo by transactions in...
- Q43. A user complains about poor database performance. You suspect that the user's session is w...
- Q44. You want to use table compression suitable for OLTP that will: 1. Compress rows for all DM...
- Q45. Which two are true about complete recovery? (Choose two.)...
- Q46. The sales table has columns prod_id and quantity_sold of data type number In two queries e...
- Q47. Which two are true about shrinking a segment online? (Choose two.)...
- Q48. Which three statements are true regarding indexes? (Choose three.)...
- Q49. Which statement is true about smallfile tablespaces?...
- Q50. Evaluate these commands which execute successfully: (Exhibit) Which two statements are tru...
- Q51. Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements exe...
- Q52. Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)...
- Q53. Which three statements are true about the tools used to configure Oracle Net Services? (Ch...
- Q54. What is true about non-equijoin statement performance? (Choose two.)...
- Q55. You execute this command: (Exhibit) During the export operation, you detach from the job b...
- Q56. Which three functions are performed by dispatchers in a shared server configuration? (Choo...
- Q57. Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT...
- Q58. Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two...
- Q59. Which two statements are true about the DUAL table? (Choose two.)...
- Q60. Which three statements are true concerning logical and physical database structures? (Choo...
- Q61. You want to write a query that prompts for two column names and the WHERE condition each t...
- Q62. Which three statements are true about Oracle synonyms? (Choose three.)...
- Q63. Which two statements are true? (Exhibit)
- Q64. You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sale...
- Q65. The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different lo...
- Q66. Which two statements are true about single row functions? (Choose two.)...
- Q67. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q68. The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different lo...
- Q69. Which three statements are true about inner and outer joins? (Choose three.)...
- Q70. Examine this command: (Exhibit) Which two statements are true? (Choose two.)...
- Q71. Which three statements are true about data block storage in an Oracle Database?...
- Q72. Which two statements are true about the PMON background process? (Choose two.)...
- Q73. You have been tasked to create a table for a banking application. One of the columns must ...
- Q74. Which two statements are true?
- Q75. The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type...
- Q76. In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSN...
- Q77. In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces...
- Q78. Which two tasks can be performed in the NOMOUNT state? (Choose two.)...
- Q79. Which two statements are true about the ORDER BY clause when used with a SQL statement con...
- Q80. Which four statements are true regarding primary and foreign key constraints and the effec...
- Q81. Which two tasks can you perform using DBCA for databases? (Choose two.)...
- Q82. Which three statements are true about table data storage in an Oracle Database? (Choose th...
- Q83. View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require ...
- Q84. Which three Oracle database space management features will work with both Dictionary and L...
- Q85. Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. E...
- Q86. Which three statements are true concerning logical and physical database structures? (Choo...
- Q87. View the Exhibit and examine the description of the tables. You execute this SQL statement...
- Q88. Which three statements are true regarding indexes? (Choose three.)...
- Q89. Which three failures do not require intervention for recovery? (Choose three.)...
- Q90. Which two statements are true about the DUAL table? (Choose two.)...
- Q91. Which two statements are true about the rules of precedence for operators? (Choose two.)...
- Q92. Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (C...
- Q93. View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want t...
- Q94. Examine these commands: (Exhibit) Which two statements are true about the sqlldrexecution?...
- Q95. Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You wa...
- Q96. Which statement is true about the INTERSECT operator used in compound queries?...
- Q97. A script abc.sql must be executed to perform a job. A database user HR, who is defined in ...
- Q98. Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements exe...
- Q99. The orders table has a column ORDER_DATE of data type date. The default display format for...
- Q100. The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary ...
- Q101. Examine the description of the employees table: (Exhibit) Which query requires explicit da...
- Q102. Which two statements are true about the results of using the INTERSECT operator in compoun...
- Q103. Which two statements are true regarding Oracle database space management within blocks man...
- Q104. Which three statements are true about roles?
- Q105. The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries ...
- Q106. Which three statements are true about single-row functions? (Choose three.)...
- Q107. What two are benefits of Data Pump? (Choose two.)...
- Q108. In one of your databases, user KING is: 1. Not a DBA user 2. An operating system (OS) user...
- Q109. Examine this SQL statement: SELECT cust_id, cust_last_name "Last Name" FROM customers WHER...
- Q110. You execute this command: (Exhibit) During the export operation, you detach from the job b...
- Q111. Which two statements are true about trace files produced by the Oracle Database server? (C...
- Q112. Examine the description of the members table: (Exhibit) Examine the partial query: SELECT ...
- Q113. You have been tasked to create a table for a banking application. One of the columns must ...
- Q114. You want to write a query that prompts for two column names and the WHERE condition each t...
- Q115. In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CR...
- Q116. Which three activities are recorded in the database alert log? (Choose three.)...
- Q117. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q118. Examine the description of the members table: (Exhibit) Examine the partial query: SELECT ...
- Q119. Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)...
