04 2019 档案
摘要：choose two Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this sce
阅读全文
摘要：choose three Which three statements are true about Oracle checkpoint processing? A) Incremental checkpoints write some dirty buffers to the datafiles
阅读全文
摘要：choose three Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file au
阅读全文
摘要：choose three Which three statements are true about Oracle Data Pump? A) Oracle Data Pump export and import operations can be performed only by users w
阅读全文
摘要：choose two Examine this command executed on a client that is remote from the database server. SQL> CONNECT hr/hr@orcl Which two are required for this
阅读全文
摘要：choose one What is a pre-requisite to alter a role? A) You should set the OS_ROLES parameter to true. B) You should be granted the DBA role. C) You sh
阅读全文
摘要：choose one Which users are created and can be used for database and host management of your DBaaS database servers? A) cloud and oracle users B) root,
阅读全文
摘要：choose one In your Oracle 12c database, you plan to execute the command: SQL> CREATE TABLESPACE tbsl DATAFILE '/u02/oracle/data/tbs0l.dbf' SIZE 50M; T
阅读全文
摘要：choose two You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? A) Perform a direct upgrade by manually
阅读全文
摘要：12. Your database is configured in archivelog mode. Examine the RMAN configuration parameters: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default C
阅读全文
摘要：11.Your database is in archivelog mode. You want to disable archiving for the database. Examine these steps: 1. Execute the alter database noarchivelo
阅读全文
摘要：10.Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? A) It can load data in parallel. B) No data file needs to be
阅读全文
摘要：9.You ran this command on a source database: $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=empl.dmp VIEWS_AS_TABLES=emp_dept On the target database, you r
阅读全文
摘要：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
阅读全文
