网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you 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
参考答案
参考解析
解析：
暂无解析
更多 “单选题You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this（）A the XML scriptB the PL/SQL scriptC the DBMS_SCHEDULER packageD Enterprise Manager to schedule the backup” 相关考题
考题
单选题You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage，which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables. Which action would you take to delay the referential integrity checking until the end of thetransaction（）A
Set the constraint to deferred before starting the transaction.B
Alter the constraint to NOVALIDATE state before starting the transaction.C
Enable the resumable mode for the session before starting the transaction.D
Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction
考题
单选题Examine the command： SQL DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）A
Automatic statistics collection is stopped for the CUSTOMERS table.B
Statistics for the CUSTOMERS table are locked and cannot be overwritten.C
Existing statistics for the CUSTOMERS table become unusable for the query optimizer.D
Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.
考题
单选题You executed this command to create a temporary table： SQL CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）A
The rows stay in the table only until session termination.B
The rows stay in the table only until the next transaction starts on the table.C
The rows are visible to all current sessions after the transaction is committed.D
The rows stay available for subsequent sessions after the transaction is committed
考题
单选题You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）A
ClusterB
Database linkC
Mapping tableD
Materialized view
考题
多选题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
考题
多选题Which two statements are true about alerts（）AClearing an alert sends the alert to the alert history.BResponse actions cannot be specified with server-generated alerts.CThe nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view.DServer-generated alerts notify the problems that cannot be resolved automatically and requireadministrators to be notified.
考题
多选题Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance
考题
多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
考题
多选题You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）ANo flashback is possible to bring back the ITEM table.BThe ORDERS table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDERS table are disabled.DThe dependent referential integrity constraints in the ORDERS table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin
考题
单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）A
The commands execute successfully.B
Command 6 produces an error because of circular role grant.C
Command 5 produces an error because a role cannot be granted to another role.D
Command 3 produces an error because the MGRROLE role already contains system privileges.E
The table created by HR remains and HR still has the CREATE TABLE system privilege.F
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
热门标签
最新试卷