网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）
A
The backup performed on Sundays contains all the blocks that have ever been used in the database.
B
The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.
C
The backup performed on each working day contains all the blocks that have changed since the last level 0 backup.
D
The backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backup
参考答案
参考解析
解析：
暂无解析
更多 “多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the blocks that have ever been used in the database.BThe backup performed on Sundays contains all the blocks that have changed since the last level 1 backup.CThe backup performed on each working day contains all the blocks that have changed since the last level 0 backup.DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup， and every other working day contains all the blocks that have changed since the level 1 backup” 相关考题
考题
单选题You executed the following command to perform a backup of the USERS tablespace：SQL ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）A
The MTTR Advisor is disabled.B
The database is in NOARCHIVELOG mode.C
The tablespace is already in backup mode.D
The Flash Recovery Area is not configured
考题
多选题The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic
考题
单选题Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance. What would be your next step to improve performance？ （）A
Run the SQL Access Advisor.B
Run the Memory Advisor for the sga.C
Run the Memory Advisor for the pga.D
Run the Memory Advisor for the shared pool.E
Run the Memory Advisor for the buffer cache.
考题
多选题Which two statements are true regarding the Oracle Data Pump export and import operations（）AYou cannot export data from a remote database.BYou can rename tables during an import operation.CYou can overwrite existing dump files during an export operation.DYou can compress the data during export but not the metadata because it is not supported.
考题
单选题In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A
when the data file of the undo tablespace is autoextensibleB
when there are more than one undo tablespaces available in the databaseC
when the undo tablespace is of a fixed size and retention guarantee is not enabledD
when the undo tablespace is autoextensible and retention guarantee is not enabled
考题
多选题Which two statements are true regarding listeners（）AListeners use only the TCP/IP protocol.BMultiple listener processes can run simultaneously on a host.CMultiple database instances can be registered with a single listener.DThe listener-related errors can be traced only at the administrative level.EOnly one database instance can be registered with a single listener at any time.
考题
单选题You are installing Oracle Database 11g on a machine. When you run the installer， the Oracle Universal Installer（OUI） shows the message that says one of the product-specific prerequisite checks has failed：Checking available swap space requirements ...Expected result： 1512MBActual Result： 1018MB Check complete. The overall result of this check is： Failed Problem： The system does not have therequired swap space. What happens to the installation in this situation（）A
It can be continued.B
It resizes the swap space automatically when you proceed further.C
It can be continued， but the instance cannot be started without increasing the swap space.D
It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed
考题
单选题Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）A
Run the root.sh script.B
Create the oraInst.loc file.C
Create the tnsnames.ora file.D
Run the oraintRoot.sh script.
考题
单选题Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command： LSNRCTL STOP What happens to the sessions that are presently connected to the database instance（）A
The sessions are able to perform only queries.B
The sessions are not affected and continue to function normally.C
The sessions are terminated and the active transactions are rolled back.D
The sessions are not allowed to perform any operations till the listener is started.
考题
单选题The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this（）A
Create the procedure with definer’s right.B
Create the procedure with invoker’s right.C
Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.D
Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users
热门标签
最新试卷