网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

  • A、cannot be used in RMAN
  • B、by starting up the database again
  • C、by using the CATALOG command of RMAN
  • D、by using the RECOVER CATALOG command in RMAN
  • E、by re-creating the target control file to rebuild the RMAN repository

参考答案

更多 “It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository” 相关考题
考题 Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.A、1 and 3B、2， 3， and 5C、1， 2， and 3D、2， 3， 4， and 5
查看答案
考题 Identify three key features of ASM.（）A、 file stripingB、 allocation unit mirroringC、 automatic disk rebalancingD、 automatic file size incrementE、 automatic undo management
查看答案
考题 Given： 11.double input = 314159.26； 12.NumberFormat nf = NumberFormat.getInstance（Locale.ITALIAN）； 13.String b； 14.//insert code here Which code， inserted at line 14， sets the value of b to 314.159，26？（）A、b = nf.parse（ input ）；B、b = nf.format（ input ）；C、b = nf.equals（ input ）；D、b = nf.parseObject（ input ）；
查看答案
考题 You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A、MERGEB、SELECT …CROSS JOINC、INSERT ALL …SELECTD、CREATE VIEW …CONSTRAINT
查看答案
考题 Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）A、The DESCRIBE DEPT statement displays the structure of the DEPT table.B、The ROLLBACK statement frees the storage space occupied by the DEPT table.C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
查看答案
考题 Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?（）A、Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.B、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.C、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.D、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.E、Scott cannot create a synonym because synonyms can be created only for tables.F、Scott cannot create any synonym for Mary’s view. Mary should create a private ynonym for the view and grant SELECT privilege on that synonym to Scott.
查看答案
考题 Which command will result in a trace file being created with the create controlfile command contained in it？（）  A、 alter database backup controlfileB、 alter database backup controlfile to traceC、 alter database controlfile backupD、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E、 alter database begin controlfile backup
查看答案
考题 Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  A、 backup databaseB、 backup database and archivelogsC、 backup database plus archivelogsD、 backup database plus archivelog delete inputE、 backup database and archivelog delete input
查看答案
考题 How are messages displayed when you use the SRW.MESSAGE packaged procedure? （）A、Dialogue box that implicitly determines report execution. B、Message line that implicitly determines report execution. C、Message line that suppresses the default oracle message. D、Dialogue box that does not terminate report execution. E、Dialogue box that suppresses the default oracle message.
查看答案
考题 下列关于PL/SQL的说法正确的是（）A、PL/SQL是应用于各种数据库上的通用语言B、PL/SQL是过程化的SQL语言C、PL/SQL是只能在SQL*PLUS中运行D、在PL/SQL可以直接执行所有的SQL操作
查看答案
考题 注册Oracle目标数据库的命令是（）。A、REG DBB、REGISTER DATABASEC、DATABASE REGISTERD、REGST DATABASE
查看答案
热门标签
最新试卷