当前分类: Oracle认证考试
问题:he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()A、SYS.SOURCE$ B、SYS.AUD$ C、DBA_SOURCE D、DBA_AUDIT_TRAIL...
查看答案
问题:When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file....
问题:在Oracle中,数据库中的触发器是一个对关联表发出insert、update或()语句时触发的存储过程。A、deleteB、dropC、createD、truncate...
问题:Which of the f...
问题:Which statements...
问题:Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?()A、 NLS_LANGB、 NLS_COMPC、 NLS_SORTD、 None of the above...
问题:用于删除表中所有数据行的命令是()。A、DELETE TABLEB、TRUNCATE TABLEC、DROP TABLED、ALTER TABLE...
问题:Which is an iSQL*Plus command?()...
问题:Which two statements are true ab...
问题:Which two statements...
问题:Which two statements about subqueries are true?()A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FRO...
问题:The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?()A、SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;B、SELECT (gpa) FR...
问题:Observe the information in the columns: 1: The SGA a. Text and parsed forms of all SQL statements 2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved 3: User-session data c. Security and resource usage in...
问题:Which three tasks...
问题:What are four capabilities of th...
问题:Which two are attributes of /SQL...
问题:Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?()A、The import operation must be performed by a user on the target data...
问题:You need to give the MANAGER ro...
问题:说明触发器的种类和对应的作用对象、触发事件。...