alice9313

摘要： 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 da 阅读全文

摘要： 5.A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO 阅读全文

摘要： 4.Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURREN 阅读全文

摘要： 3.Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three 阅读全文

摘要： Oracle OCP 19c 认证1Z0-082考试题库(第2题) 2.Which statement is true about the INTERSECT operator used in compound queries? A. Multiple INTERSECT operators are 阅读全文

摘要： 1. You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in fil 阅读全文

摘要： 78、Which four database objects never have any segments? A) A partitioned index B) A view selecting from a populated table C) An empty index D) An Orac 阅读全文

摘要： 77、Which structure can span multiple data files? A) a bigfile tablespace B) a permanent tablespace C) a segment D) a temporary tablespace E) an extent 阅读全文

摘要： 76、Which three structures can span multiple data files? A) migrated rows B) table extents C) temporary segment extents D) index extents E) chained row 阅读全文

摘要： 75、Your database is using Automatic Memory Management. Which two SGA components must be managed manually? A. redo log buffer B. keep buffer pool C. la 阅读全文