当前分类: Oracle认证考试
问题:Which two statements...
查看答案
问题:What are four capabilities of th...
问题:In your database,...
问题:You create two ...
问题:You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?()A、It records the usernames and passwo...
问题:You plan to move...
问题: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...
问题: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 need to give the MANAGER ro...
问题:用于删除表中所有数据行的命令是()。...
问题:You are working ...
问题:You disabled the&ensp...
问题:Which type of backup must be performed first with an incremental backup?()A、 Level 1B、 Level 0C、 Level 2D、 Level 3...
问题:Which two are attributes of /SQL...
问题:说明触发器的种类和对应的作用对象、触发事件。...
问题: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...
问题:What is true about joining table...
问题:Which of the f...
问题:Which three functions are performed by the SQL Tuning Advisor?() A、 Building the SQL profileB、 Recommending optimization of materialized viewsC、 Checking query objects for missing and stale statisticsD、 Recommending bitmap, function-based, and B-tree inde...
问题:You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2, with one device each. In the parameter file of the production database, the following parameters have bee...