当前分类： Oracle认证考试
问题：You are currently...
查看答案
问题：Which statement explicitly names...
问题：Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid?（）A、UPDATE employees SET first_name = 'John' SET last_name = 'Smith' WHERE employe...
问题：Which of the f...
问题：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...
问题：You need to give the MANAGER ro...
问题：What are four capabilities of th...
问题：You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?（）A、Enable supplemental logging for the database.B、Specify undo retentio...
问题：Your database is&ensp...
问题：Which two are attributes of /SQL...
问题：Which two statements...
问题：Which mode of database shutdown requires an instance recovery at the time of the next database startup?（）A、ABORTB、NORMALC、IMMEDIATED、TRANSACTIONAL...
问题：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...
问题：You plan to cont...
问题：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...
问题：You create an Or...
问题：说明触发器的种类和对应的作用对象、触发事件。...
问题：用于删除表中所有数据行的命令是（）。...
