出自:Oracle认证

A host named client12 is having difficulty communicating with a heavily used server named server14. The server14 server has the ce0， ce1， ce4， and qfe4 interfaces active. The client12， admin6， and appserv5 hosts are all on a private network and access the ce4 interface on server14 exclusively and cannot access other network interfaces on server14. The appserv5 and admin6 hosts are currently generating heavy traffic to server14 due to a running batch process.  Which two commands can you run on server14 to look at the network traffic generated between only client12 and server14 to assist in troubleshooting the communication issue？（）
A: snoop !admin6
B: snoop -d client12
C: snoop -d ce server14
D: snoop -d ce4 client12
E: snoop -d ce4 client12 server14
F: snoop -i ce4 server14 client12
You created a response file and want to check it before starting installations in silent mode. You started installation of Oracle software in interactive mode by providing the response file. In the middle of the installation， you realize that the behavior of the Oracle Universal Installer （OUI） is not consistent with the response file. What action would you take to detect the cause of this behavior？（）
A:Compare the contents of the install.log file with the response file.
B:Refer to the contents of the oraInst.loc file to verify the steps performed by OUI.
C:Compare the contents of the installActions.log file with that of the response file.
D:Refer to the alert log file for information regarding the actions performed by OUI during installation.
Which two statements are true about WHERE and HAVING clauses? （）
A:A WHERE clause can be used to restrict both rows and groups.
B:A WHERE clause can be used to restrict rows only.
C:A HAVING clause can be used to restrict both rows and groups.
D:A HAVING clause can be used to restrict groups only.
E:A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
F:A HAVING clause CANNOT be used in subqueries.
Given: Which two code fragments, inserted independently at line 13, will compile?（）
A:super(name, baseSalary);
B:this.commission = commission;
C:super();this.commission = commission;
D:this.commission = commission;super();
E: super(name, baseSalary);this.commission = commission;
F:this.commission = commission;super(name, baseSalary);
G:super(name, baseSalary, commission);
How many individual archive-log destination directories are supported by Oracle Database11g?（）
A:7 
B:1 
C:10 
D:11 
E:21
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
A:The instance aborts.
B:The database cannot be recovered.
C:The database can be recovered by restoring the control files from the backup.
D:The database remains opened and you have to shut it down with the ABORT option.
E:The database can be restored till the point of the last closed whole database backup.
View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）
A:The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.
B:The members of SYS_GROUP would get most of the CPU allocation at level 1.
C:The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels.
D:The members of LOW_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.
E:The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）
A: Start the database in OPEN mode， and create a new index tablespace.
B: Start the database in OPEN mode， and drop the lost index tablespace from the database.
C:Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
D: Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）  
A: The operating system local time zone will be set for a user session using the operating system environment variable.
B: The database local time zone will be set for a user session using the operating system environment variable.
C: The operating system local time zone will be set for the database using the operating system environment
D: The database local time zone will be set for the database using the operating system environment variable.
Given: What is the result?（）
A:Compilation fails.
B:Cannot add Toppings
C:The code runs with no output.
D:A NullPointerException is thrown in Line 4.
You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1：   DROP FLASHBACK ARCHIVE fla1；   What is the effect of this command？（）
A: The Flashback Archive FLA1 is dropped only if it is empty.
B: The tablespace having Flashback Archive is dropped.
C: The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D: The Flashback Data Archive and historical data are dropped.
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）
A:MERGE
B:INSERT
C:UPDATE
D:ADD
E:ENTER
F:You cannot enter the phone numbers for the existing employee records.
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）
A:The database user OPS$SKD will be able to administer the database.
B:The authentication detail for the database user OPS$SKD is recorded in the password file.
C:The local operating system user SKD will be able to access the database instance without specifying the username and password.
D:The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
简单介绍几种当前流行的关系数据库系统？
You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?（）
A:RMAN reads the block change tracking file only when it performs the incremental level 0 backup.
B:RMAN reads the block change tracking file when it performs both incremental backups.
C:RMAN reads the block change tracking file only when it performs the incremental level 1 backup.
D:RMAN does not read the block change tracking file when it performs either incremental backup.
（）是包含Oracle数据库中所有数据的数据库对象。
A:视图
B:索引
C:存储过程
D:表
Given: What is the result?（）
A:The code runs with no output.
B:An exception is thrown at runtime.
C:Compilation fails because of an error in line 20.
D:Compilation fails because of an error in line 21.
E:Compilation fails because of an error in line 23.
F:Compilation fails because of an error in line 25.
Which statement about the enabling of table compression in Oracle Database 11g is true？（）  
A: Compression can be enabled at the table， tablespace， or partition level for direct loads only.
B: Compression can be enabled only at the table level for both direct loads and conventional DML.
C: Compression can be enabled at the table， tablespace， or partition level for conventional DML only.
D: Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.
You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）
A: You need to mention it with every BACKUP command.
B: The block change tracking feature is used automatically by RMAN.
C: You need to configure it using the CONFIGURE command.
D: You need to set the necessary initialization parameters to direct RMAN to use the feature.
You work as a database administrator for Certkiller .com. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit.  Which three options of the CREATE USER command would you use to achieve this objective？（）
A:Profile
B:Account lock
C:Account unlock
D:Password expire
E:Quota 10MB on Certkiller TBS1
F:Password never expire
G:Defaulttablespace Certkiller TBS1
H:Quota unlimited on Certkiller TBS1
I:TemporarytablespaceTEMP
J:TemporarytablespaceSYSTEM
Which of the following is not a configurable attribute for an individual disk group？（）
A: AU_SIZE
B: COMPATIBLE·RDBMS
C: COMPATIBLE·ASM
D: DISK_REPAIR_TIME
E: DG_DROP_TIME
Oracle内置程序包由（）用户所有。
A:sys
B:system
C:scott
D:Pub lic
The RVPC user can do which of the following？（）
A: Register databases if granted the register database privilege
B: See all databases in the recovery-catalog schema
C: See all database-related metadata in the recovery catalog if they are granted access to that database
D: Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with  the grant command
E: Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
Which two tasks can be performed when WLST is in OFFLINE mode?（）
A:modifying the configuration of an online domain
B:modifying the configuration of an offline domain
C:viewing runtime performance data in ONLINE mode
D:viewing runtime performance data in OFFLINE mode
E:creating and extending domains
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
A: time-based recovery
B: log sequence recovery
C: cancel-based recovery
D: change-based recovery
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）
A:A template needs to be associated with the task.
B:A workload needs to be associated with the task.
C:The partial or complete workload scope needs to be associated with the task.
D:The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）
A:data file
B:password file
C:archivelog file
D:temporary file
E:online redo log file
F:the current control file
G:the tnsnames.ora file
H:current server parameter file
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）
A:The extents in the undo tablespace retain data until the next full database backup.
B:The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
C:The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
D:The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr； Which statement describes the outcome of the command（）
A:The command executes successfully.
B:The command produces an error because the EMP table is owned by SCOTT.
C:The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
D:The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table
Using the LIST command in Recovery Manager （RMAN）， which two pieces of information from the RMAN repository can be listed？ （）
A:backups that can be deleted
B:stored scripts in the recovery catalog
C:backup sets and image copies that are obsolete
D:only the most recent backup sets or image copies
E:backups that do not have the AVAILABLE status in RMAN repository
首页 <上一页 129 130 131 132 133 下一页> 尾页