-
编辑 删除
042-169
169: You are connecting to an Oracle database server from a client by using the following connect string:SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb Which naming method is being used in this...
-
编辑 删除
042-168
168: You are using three database, Certkiller DB01, Certkiller DB02, and Certkiller DB03, on different host machines in your development environment. The database server configuration, such as IP addr...
-
编辑 删除
042-167
167: Which three statements correctly describe the functions and use of constraints? (Choose three.) A. Constraints provide data independence. B. Constraints make complex queries easy. C. Constraints ...
-
编辑 删除
042-166
166. A user complains about getting this error after issuing a certain SQL statement:ORA-02393: exceeded call limit on CPU usageBecause of the error, the SQL statement gets aborted. What action would ...
-
编辑 删除
042-165
165. You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task?A) FULLB) SCHE...
-
编辑 删除
042-163
163. When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed:TZ set to America/New_yorkOC4J Configuration issue./u01/app/oracle/product/1...
-
编辑 删除
042-158
158. You want to create a tablespace with the following specifications:1. The tablespace extends automatically.2. Used and free extents should be managed by bitmaps.3. Default PCTUSED attribute is set...
-
编辑 删除
042-149
149. You execute the following set of commands to create a database user and to grant the system privileges in your production environment.SQL> CREATE USER user01IDENTIFIED BY oracleDEFAULT TABLESPACE...
-
编辑 删除
042-152
152. The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE col...
-
编辑 删除
042-148
148. The HR user creates a view with this command:SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp;Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is tru...
-
编辑 删除
042-146
146. In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?A) The optimizer statistics are collected automatically.B) Only the timed o...
-
编辑 删除
042-145
145. You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achiev...
-
编辑 删除
042-144
144. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct? (Choose two.)A) This clause is not valid for a temporary or undo tablespace.B) If the tablespa...
-
编辑 删除
042-142
142. Which two statements are true about a bitmap index? (Choose two.)A) It is recommended for the columns that have unique values.B) It can be converted to a B-tree index by using the ALTER INDEX com...
-
编辑 删除
042-139
139. Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?A) The operation would fail if tbs_...
-
编辑 删除
042-138
138. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?A) host naming methodB) local nam...
-
编辑 删除
042-136
136. View the Exhibit to observe the privileges granted to the MGR_ROLE role.The SCOTT user has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to th...
-
编辑 删除
042-132
132. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two st...
-
编辑 删除
042-128
128. Your database is started with SPFILE. You want the database instance to be dynamically registered with alistener L2 with the following details:Protocol: TCPHost: indl151ePort: 1525Which is the co...
-
编辑 删除
042-124
124. User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to? (Choose t...
