摘要:
8. Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? A) Static registration in the listener.ora file us 阅读全文
摘要:
7.daily_ords_lst is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management. CREATE TABLE daily_ords_list (ordn 阅读全文
摘要:
6.Which four statements are true about database instance behavior? A) Redo log files can be renamed in mount state. B) Datafiles can be renamed in mou 阅读全文
摘要:
5.One of your databases supports an OLTP workload. The default undo tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. undo_retention is 12 mi 阅读全文
摘要:
4.Which four are true about creating and running a remote database scheduler jobs? A) A credential is optional for a remote database job. B) A databas 阅读全文
摘要:
3.A database is open read write and the instance has multiple sessions some of which have active transactions. You execute this command: SQL> ALTER SY 阅读全文
摘要:
2.Which three statements are true about pfiles, spfiles or both? A) All spfile parameters can be modified successfully with the scope=both clause. B) 阅读全文
摘要:
1.One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the users tablespace is corrupt 阅读全文
摘要:
80、View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables. You need to create a view that displays the ORDER_ID, ORDER_DATE, and 阅读全文
摘要:
79、Which statement is true about transactions? A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT 阅读全文