当前位置: fljsyy-> 083题库
165
164

新闻中心

  • Oracle OCP 19c 认证1Z0-083考试题库(第17题)2021-06-22
  • Oracle OCP 19c 认证1Z0-083考试题库(第17题)-CUUG内部学员版083题库解析17、Which two are true about server-generated alerts? (Choose two.)A. Stateful alerts must be created by a DBA after resolving the problem.B. Stateless alerts can be purged manually from the alert history.C. Stateless alerts can be cleared manually.D. Stateless alerts are automatically cleared.E. Stateful alerts are purged automa........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第18题)2021-06-22
  • Oracle OCP 19c 认证1Z0-083考试题库(第18题)-CUUG内部学员版083题库解析18、Which three are located by using environment variables? (Choose three.)A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.B. the location of Oracle Net Services configuration filesC. the list of a disk group names to be mounted by an Oracle Automatic Storage Manage........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第19题)2021-06-22
  • Oracle OCP 19c 认证1Z0-083考试题库(第19题)-CUUG内部学员版083题库解析19、Which three are true about opatchauto? (Choose three.)A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.B. It must be invoked by a user with root user privileges.C. Patches are applied via opatchauto.D. Users must always inpu........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第20题)2021-06-22
  • Oracle OCP 19c 认证1Z0-083考试题库(第20题)-CUUG内部学员版083题库解析20、Which two are true about the character sets used in an Oracle database? (Choose two.)A. Single-byte character sets provide better performance than multibyte character sets.B. Unicode enables information from any language to be stored using a single character set.C. Unicode is the only supported character set for Oracle ........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第16题)2021-06-22
  • Oracle OCP 19c 认证1Z0-083考试题库(第16题)-CUUG内部学员版083题库解析16、choose fourWhich four are true about performance-related Oracle tools?A) The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two consecutive periods.B) SQL Performance Analyzer can suggest schema changes.C) SQL Performance Analyzer can identify regressed SQL statements.D) Database Replay alway........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第11题)2021-05-21
  • Oracle OCP 19c 认证1Z0-083考试题库(第11题)-CUUG内部学员版083题库解析11、Choose two.Which two are true about common objects?A. They can be created only in CDB$ROOT.B. They can be only metadata-linked in an application container.C. They can exist in user-defined schemas only in application containers.D. They can exist in CDB$ROOT and an application root.E. They can be extended data-linked in CDB$RO........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第12题)2021-05-21
  • Oracle OCP 19c 认证1Z0-083考试题库(第12题)-CUUG内部学员版083题库解析12、Which two are true about the Automatic Database Diasnostic Monitor (ADDM)?(Choose two.)A. It analyzes a period of time corresponding to the 12 hours of activity.B. It runs automatically after each AWR snapshot.C. A DBA can run it manually.D. Results are written to the alert log.E. It analyzes a period of time correspondin........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第13题)2021-05-21
  • Oracle OCP 19c 认证1Z0-083考试题库(第13题)-CUUG内部学员版083题库解析13、choose the best answerYou notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?A. Database ReplayB. Automatic Database Diagnostic Monitor (ADDM) Compare Period reportC. Active Session History (ASH) reportD. S........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第14题)2021-05-21
  • Oracle OCP 19c 认证1Z0-083考试题库(第14题)-CUUG内部学员版083题库解析14、choose oneYou notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?A. Enable Memory Access Mode........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第15题)2021-05-21
  • Oracle OCP 19c 认证1Z0-083考试题库(第15题)-CUUG内部学员版083题库解析15、choose oneYou notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.How can you detect the cause of the degraded performance?A. by performing emergency monitoring using Real-Time Automatic Databas........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第6题)2021-03-29
  • Oracle OCP 19c 认证1Z0-083考试题库(第6题)-CUUG内部学员版083题库解析6、Which two are prerequisites for performing Flashback Transaction?A) Fast Recovery Area must be enabled for the database.B) The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.C) Undo retention guarantee must be configured for the database.D) A supplemental log must be enabled for the primary key.E) R........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第7题)2021-03-29
  • Oracle OCP 19c 认证1Z0-083考试题库(第7题)-CUUG内部学员版083题库解析7、choose oneYou enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.You execute the following command to change the requirement:SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENT........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第8题)2021-03-29
  • Oracle OCP 19c 认证1Z0-083考试题库(第8题)-CUUG内部学员版083题库解析8、Examine the statements that use flashback technologies:1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');2. SELECT * FROM customers AS OF SCN 123456;3. FLASHBACK TABLE customers TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-D........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第9题)2021-03-29
  • Oracle OCP 19c 认证1Z0-083考试题库(第9题)-CUUG内部学员版083题库解析9、choose twoYou accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.Which two statements are true about the dependent objects of the CUSTOMERS table?A) All the triggers associated with the table are flashed back but are disabled.B) Materialized views that use the CUSTOMERS table a........详情
  • Oracle OCP 19c 认证1Z0-083考试题库(第10题)2021-03-29
  • Oracle OCP 19c 认证1Z0-083考试题库(第10题)-CUUG内部学员版083题库解析10、Choose three.Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release?A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are metB. creating the or........详情
  • 19c ocp认证1Z0-083考试内部题库(第5题)2020-09-25
  • 19c ocp认证1Z0-083考试内部题库(第5题)-CUUG内部学员版083题库解析5、Which three are true about requirements for various FLASHBACK operations? (Choose three.)A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.C. FLASHBACK version query requires that the RECYCLEB........详情
  • 19c ocp认证1Z0-083考试内部题库(第4题)2020-09-25
  • 19c ocp认证1Z0-083考试内部题库(第4题)-CUUG内部学员版083题库解析4、For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDBC. to include specific user tablespaces ........详情
  • 19c ocp认证1Z0-083考试内部题库(第3题)2020-09-25
  • 19c ocp认证1Z0-083考试内部题库(第3题)-CUUG内部学员版083题库解析3、While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.FORCE LOGGING is enabled for the database.Which two could improve read performance? (Choose two.)A. Increase the size of tape I/O buffers.B. Disable FORCE LOGGING for the data........详情
  • 19c ocp认证1Z0-083考试内部题库(第2题)2020-09-25
  • 19c ocp认证1Z0-083考试内部题库(第2题)-CUUG内部学员版083题库解析2、Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?A) when free space in a dictionary managed tablespace falls below a specified percentageB) when free space in a locally managed tablespace falls below a specified percentageC) when the total number of locked use........详情
  • 19c ocp认证1Z0-083考试内部题库(第1题)2020-09-25
  • 19c ocp认证1Z0-083考试内部题库(第1题)-CUUG内部学员版083题库解析1.Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)A. All metrics are instance related.B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.C. A space usage management alert is automatically cleared after the underlying problem is resolved.D. They are generated by SMON whe........详情