問題1
Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.
What would be your next step to improve performance?
Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.
What would be your next step to improve performance?
正確答案: A
說明：（僅 NewDumps 成員可見）
問題2
Examine the following command that is used to create a table:
Which two statements are true about the effect of the above command? (Choose two.)
Examine the following command that is used to create a table:
Which two statements are true about the effect of the above command? (Choose two.)
正確答案: B,D
問題3
Examine the commands executed in the following sequence:
Which statement is true about the above commands?
Examine the commands executed in the following sequence:
Which statement is true about the above commands?
正確答案: C
問題4
Which four are true about the tools used to administer Oracle databases? (Choose four.)
Which four are true about the tools used to administer Oracle databases? (Choose four.)
正確答案: A,C,D,F
問題5
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for crossverification.
Which schema object enables the user to access the information from the remote database?
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employee information and the database in the SACCT server maintains the accounts payable information. The employees submit the expense reports to the accounts payable department. A user of the accounts payable database wants to extract the employee information from the database in the SEMP server for crossverification.
Which schema object enables the user to access the information from the remote database?
正確答案: B
問題6
View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?
Exhibit:
View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?
Exhibit:
正確答案: D
問題7
Examine these components:
* Execution plan for a non-embedded SQL statement
* Local, global, and package variables for a session
* Execution plan for a SQL statement contained in a PL/SQL program unit
* Results of executed queries and query fragments
* PL/SQL function result sets
Which of these are stored in the shared SQL area?
Examine these components:
* Execution plan for a non-embedded SQL statement
* Local, global, and package variables for a session
* Execution plan for a SQL statement contained in a PL/SQL program unit
* Results of executed queries and query fragments
* PL/SQL function result sets
Which of these are stored in the shared SQL area?
正確答案: A
說明：（僅 NewDumps 成員可見）
問題8
You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction?
Exhibit:
You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction?
Exhibit:
正確答案: D
說明：（僅 NewDumps 成員可見）
問題9
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:
Which file is used to start the instance in this case?
Exhibit:
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:
Which file is used to start the instance in this case?
Exhibit:
正確答案: B
問題10
You are using flat files as the data source for one of your data warehousing applications.
To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?
You are using flat files as the data source for one of your data warehousing applications.
To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?
正確答案: A
問題11
View the Exhibit1, which shows the options that are selected to create the user SL_REP.
View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.
Which two statements are true regarding this user? (Choose two.)
Exhibit1 (exhibit):
Exhibit2 (exhibit):
View the Exhibit1, which shows the options that are selected to create the user SL_REP.
View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.
Which two statements are true regarding this user? (Choose two.)
Exhibit1 (exhibit):
Exhibit2 (exhibit):
正確答案: A,E
問題12
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
正確答案: A,B
問題13
USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:
What will be the outcome and why?
USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.
USER1 executes these commands:
What will be the outcome and why?
正確答案: E
問題14
You have to create a table, STUDENTS, with the columns: STUDENT_ID,
STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
1 ) Each student must be uniquely identifiable by the STUDENT_ID.
2 ) STUDENT_ID column should not be left blank.
3 ) The student should not be less than 15 years of age.
4 ) The student can only take a course that is specified in the COURSE table in the database.
Which three constrains must be explicitly enforced on this table? (Choose three.)
You have to create a table, STUDENTS, with the columns: STUDENT_ID,
STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
1 ) Each student must be uniquely identifiable by the STUDENT_ID.
2 ) STUDENT_ID column should not be left blank.
3 ) The student should not be less than 15 years of age.
4 ) The student can only take a course that is specified in the COURSE table in the database.
Which three constrains must be explicitly enforced on this table? (Choose three.)
正確答案: A,C,D