USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.USER1 executes these commands:SQL> UPDATE dept SET loc='UK' where dno=1;1 row updated.SQL>...
Which three are true about UNDO data?A)It is used to rewind a database by using FLASHBACK DATABASE.B)It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFOREDROP.C)It is used to ...
58、(16-1) choose the best answer:Examine the structure of the BOORSTRANSACTIONS table:Examine the SQL statement:SQL> SELECT FROM books_transactions WHERE borrowed_dateMEMBER_ID IN ('A101', 'A102')...
Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第4题4、Choose two.User fwuser@localhost is registered with the MySQL Enterprise Firewall and has been granted privileges for the SAKILA database....
Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第1题1、Choose the best answer.Examine these statements and output:mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ;mysql> SELECT USER(), ...
Which three are true about auditing?A)Auditing is active only when the database is OPEN.B)Audit records are always stored in the database.C)Audit of the use of system privileges can be enabled for ind...
Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第6题Choose the best answer.You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.Using ...
Mysql 8.0 OCP认证考试原题题库整理(CUUG内部资料)-第1题1、Choose the best answer.Examine these statements and output:mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ;mysql> SELECT USER(), ...
74、View the exhibit and examine the structure of ORDERS and CUSTOMERS tables. ORDERS Name Null? Type ORDER_ID NOT NULL NUMBER(4) ...
Choose four.A newly deployed replication master database has a 10/90 read to write ratio.The complete dataset is currently 28G but will never fluctuate beyond +-10%.The database storage system consist...
Which two statements are true about the Automatic Diagnostic Repository (ADR) ? A)It only exists if DIAGNOSTIC_DEST is configured in the SPFILE. B)It includes diagnostic data for critical error...
Choose four.A newly deployed replication master database has a 10/90 read to write ratio.The complete dataset is currently 28G but will never fluctuate beyond +-10%.The database storage system consist...
Examine these facts about objects in the SYSTEM schema: 1.EMP is a table. 2.EMP_PK is a primary key constraint on EMP.ENO. 3.EMP_IDX is an index on EMP.MGR_NO. 4.EMP_SEQ is a sequence used to...
Which is true about external tables? A)Segments are allocated for external tables. B)They may have indexes. C)They do not support partitioning. D)The ORACLE_DATAPUMP access driver can be used...
When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing. C)when the ALTER SYSTEM CHECKPOINT state...