최신Oracle Database 11g: Administration I - 1Z1-052무료샘플문제
문제1
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:
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제2
You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
정답: D
설명: (KoreaDumps 회원만 볼 수 있음)
문제3
You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. You also plan to transfer these values to another table for analysis. How would you achieve this?
You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. You also plan to transfer these values to another table for analysis. How would you achieve this?
정답: A
문제4
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)
정답: C,E
문제5
Which two statements are true about checkpointing? (Choose two.)
Which two statements are true about checkpointing? (Choose two.)
정답: B,D
설명: (KoreaDumps 회원만 볼 수 있음)
문제6
Note the functionalities of various background processes:
1 : Perform recovery at instance startup.
2 : Free the resources used by a user process when it fails.
3 : Cleanup the database buffer cache when a process fails.
4 : Dynamically register database services with listeners.
5 : Monitor sessions for idle session timeout.
6 : Cleanup unused temporary segments.
7 : Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?
Note the functionalities of various background processes:
1 : Perform recovery at instance startup.
2 : Free the resources used by a user process when it fails.
3 : Cleanup the database buffer cache when a process fails.
4 : Dynamically register database services with listeners.
5 : Monitor sessions for idle session timeout.
6 : Cleanup unused temporary segments.
7 : Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?
정답: B
문제7
You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?
You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?
정답: D
문제8
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):
정답: D,E
문제9
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
정답: B
문제10
The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION
enabled.
TBS1 and TBS2 are the only user-defined tablespaces in ORCL.
USER1.EMP is a table in TBS1.
Examine these commands:
From which files are modified blocks backed up?
The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION
enabled.
TBS1 and TBS2 are the only user-defined tablespaces in ORCL.
USER1.EMP is a table in TBS1.
Examine these commands:
From which files are modified blocks backed up?
정답: D
문제11
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.
Which statement is true in this case?
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.
Which statement is true in this case?
정답: A
문제12
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,D,E