A.Thedatafilesthatmakeupaself-containedgroupoftablespacesrequiredforcopy
B.Thesystemtablespace
C.Anexportofthetablespacemetadata
D.Thespfile
E.Alloftheabove
第1题
A. Schedule objects
B. Program arguments
C. Job classes
D. Job arguments
E. All of the above
第2题
A.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,job_name=>’JOB1’);
B.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,job_name=>’JOB_LOG’);
C.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,which_log=>’JOB1’);
D.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,which_log=>’JOB_LOG’);
第3题
A. java.lang.RuntimeException: Problem
B. run.java.lang.RuntimeException: Problem
C. End of method.java.lang.RuntimeException: Problem
D. End of method.run.java.lang.RuntimeException: Problem
E. run.java.lang.RuntimeException: Problem End of method.
第4题
N_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; ()
A. You obtain the results retrieved from the public synonym HR created by the database administrator.
B. You obtain the results retrieved from the HR table that belongs to your schema.
C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
第5题
A.DBA_SCHEDULER_JOB_RUN_DETAILS
B.DBA_SCHEDULER_RUNNING_JOBS
C.DBA_SCHEDULER_JOBS
D.DBA_SCHEDULER_JOB_LOG
第6题
A.Onlineredologfilescanbebackedup.
B.Archivedredologfilesarebackedup.
C.Onlyuseddatablockscanbebackedupasbackupsets.
D.Onlyconsistentdatabasebackupscanbeperformed.
E.RMANbackupcanbetakenonlyifthedatabaseisconfiguredinARCHIVELOGmode.
第7题
A.LOGGING_OFF
B.LOGGING_RUNS
C.LOGGING_FULL
D.LOGGING_NULL
第8题
A. The job will need to be reenabled before it will execute again.
B. The job may hold locks on objects referenced within it.
C.All jobs within the job group will also be stopped.
D. The job may leave data in an inconsistent state.
E. There is no danger in using the STOP_JOB procedure.
第9题
A. A view can be created as read only.
B. A view can be created as a join on two or more tables.
C. A view cannot have an ORDER BY clause in the SELECT statement.
D. A view cannot be created with a GROUP BY clause in the SELECT statement.
E. A view must have aliases defined for the column names in the SELECT statement.
第10题
nsfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands:Shell> mysqldump –u root –h server –no-data apps userdata | mysql –u root –p appsShell> mysql –u root –p –h server –e ‘ALTER TABLE ‘apps‘,‘userdata‘ ENGINE=InnoDB;‘Shell> mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p appsWhat effect does the – order-by-primary argument have on the mysqldump command?()
A.It exports tables with the most indexes first to assist with import speeds
B.It ensures that unique indexes have no conflicts when the data is dumped
C.It orders by primary key to assist in speeding up importing to InnoDB tables
D.It must be specified so index data is dumped correctly when –on-create-info is used
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!