多项选择题

You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）

A.You can perform consistent backups only.
B.You can perform a complete database backup without shutting down the database instance.
C.You can back up data files only when all data files have the same SCN recorded in the control file.
D.You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands

<上一题目录下一题>

热门试题

多项选择题Whichstatementsarecorrectabouttemporarytables（）

A.Indexes and views can be created on temporary tables.
B.Both the data and the structure of temporary tables can be exported.
C.Temporary tables are always created in a user’s temporary tablespace.
D.The data inserted into a temporary table in a session is available to other sessions.
E.Data manipulation language （DML） locks are never acquired on the data of temporary tables

单项选择题You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）

A.The XML script
B.The PL/SQL script
C.The DBMS_SCHEDULER package
D.Enterprise Manager to schedule the backup

多项选择题Identifythe situationsinwhichyouusethealertlogfileinyourdatabasetocheckthedetail.（）

A.Running a query on a table returns "ORA-600： Internal Error."
B.Inserting a value in a table returns "ORA-01722： invalid number."
C.Creating a table returns "ORA-00955： name is already used by an existing object."
D.Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E.Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."

多项选择题You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）

A.The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
B.The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
C.The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D.The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively

多项选择题You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

A.The tablespace would require recovery to go back online.
B.A checkpoint is taken on all data files that are associated with the SALES tablespace.
C.The sessions that subsequently try to access the objects in the SALES tablespace receive an error
D.The new status of the SALES tablespace is recorded in the control file when the database instance isclosed