出自:Oracle认证

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?（）
A:Stored scripts in the recovery catalog
B:Backups that can be deleted from disk
C:Backup sets and images copies that are obsolete
D:Backups that do not have the AVAILABLE status in the RMAN repository
Consider the following table: Which method should used to add a new g201305 partition to the table?（）
A:A
B:B
C:C
D:D
E:E
Which  statements are true regarding a tablespace（）
A:It can span multiple databases.
B:It can consist of multiple data files.
C:It can contain blocks of different sizes.
D:It can contain segments of different sizes.
E:It can contain a part of a nonpartitioned segment
Which three statements are true about Flashback Database?（）
A:Flashback logs are written sequentially, and are archived.
B:Flashback Database uses a restored control file to recover a database.
C:The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
D:Flashback Database can recover a database to the state that it was in before a reset logs operation.
E:Flashback Database can recover a data file that was dropped during the span of time of the flashback.
F:Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
You need to display the last names of those employees who have the letter “A” as the second character in their names.Which SQL statement displays the required results?（）
A:SELECT last_name   FROM EMP   WHERE last_name LIKE ‘_A%’;
B:SELECT last_name   FROM EMP   WHERE last name =’*A%’
C:SELECT last_name   FROM EMP   WHERE last name =’_A%’;
D:SELECT last_name   FROM EMP   WHERE last name LIKE ‘*A%’
An employee cannot access the company database. You check the connection variables: What is a valid explanation for why one of the users is unable to connect to the database?（）
A:Bob has max_user_connections set to zero, which blocks all his connections
B:Joe has exceeded the max_user_connections global limit
C:All users are blocked because max_user_connections is accumulated over the host account information
D:Kay is already connected elsewhere and attempting to log in again
E:Connect_timeout is too small to allow a connection to occur
Given： Which method will complete this class？（）
A:public int compareTo（Object o）{}
B:public int compareTo（Score other）{}
C:public int compare（Score s1，Score s2）{}
D:public int compare（Object o1，Object o2）{}
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） 
A:the DBNEWID utility
B:the ANALYZE command
C:the RMAN LIST command
D:the RMAN REPORT command
E:the RMAN CROSSCHECK command
F:the RMAN BLOCKRECOVER command
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12? （）
A:SELECT ename, salary*12 'Annual Salary' FROM employees;
B:SELECT ename, salary*12 "Annual Salary" FROM employees;
C:SELECT ename, salary*12 AS Annual Salary FROM employees;
D:SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives：  Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4. Consumer group MARKET with CPU_P1 as 20.  Consumer group DEV with CPU_P1 as 20.  Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100.  Which two statements are correct in this scenario？ （）
A:The maximum degree of parallelism for the members of the consumer groups is 4.
B:The CPU allocation will always be equal for the consumer groups MARKET and DEV.
C:The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
D:The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
E:The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
Given： Under which three circumstances will the code on line 37 be executed？（）
A:The instance gets garbage collected.
B:The code on line 33 throws an exception.
C:The code on line 35 throws an exception.
D:The code on line 31 throws an exception.
E:The code on line 33 executes successfully.
What privileges must be granted to allow an account to create the recovery catalog？（）
A: RECOVERY_CATALOG_OWNER
B: DBA
C: RESOURCE
D: SELECT ANY DICTIONARY
E: CONNECT
Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query：   SQL> SELECT * FROM sales；   Which process would retrieve the result from the database and return it to the client program？（）
A: User process
B: Server process
C: System Monitor （SMON）
D: Process Monitor （PMON）
E: Checkpoint process （CKPT）
Which two statements accurately describe a role?（）
A:A role can be given to a maximum of 1000 users.
B:A user can have access to a maximum of 10 roles.
C:A role can have a maximum of 100 privileges contained in it.
D:Privileges are given to a role by using the CREATE ROLE statement.
E:A role is a named group of related privileges that can be granted to the user.
F:A user can have access to several roles, and several users can be assigned the same role.
Given： What is the result？（）
A:13
B:134
C:1234
D:2134
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
A:The Oracle kernel will be placed in this location.
B:The Oracle software will be placed in this location.
C:The server parameter file （SPFILE） will be placed in this location.
D:The database files will be placed in this location， if not specified explicitly.
E:The location will be considered for the base of Oracle Managed Files （OMF）.
F:The location will be considered for the base of Optimal Flexible Architecture （OFA）.
Development of real-time event-driven applications using Coherence is supported b（）
A: the Partitioned Cache
B: the Local Cache
C: the Map Listener running within a Partitioned Cache
D: the Map Listener running within an application 
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 user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）
A:The tablespace TBS1 is full.
B:The user is not the owner of the SYSTEM tablespace.
C:The user does not have quota on the TBS1 tablespace.
D:The user does not have sufficient system privileges to create table in the TBS1 tablespace.
E:The user does not have sufficient privileges to create table on the default permanent tablespace.
下列函数不属于集函数的是（）。
A:max
B:avg
C:count
D:substring
For real time event processing, which three clients can you use?（）
A:Java
B:C++
C:.NET
D:REST
Which two are correct steps in taking a binary backup of MyISAM tables?（）
A:Always stop the server prior to the backup
B:Stop the server or lock the tables prior to the backup
C:Stop the server or lock the databases prior to the backup
D:Make a copy of the .frm, .myd, and the .myi files
E:Make a copy of the binary log and tablespace files
Your database is in NOARCHIVELOG mode. The database has three online redo log groups， and each group contains three online redo log members. The online redo log members are stored across three hard disks， E， F， and G， respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database？（）
A: The database will operate normally without generating any redo.
B: The database will hang， and you must shut down and restart the instance.
C: The database will crash， and you must recover the database from the point of failure.
D: The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.
Which of the following objects can be directly referenced by a window object？（）
A: Schedule object
B: Program object
C: Job object
D: Resource plan
E: Resource consumer group
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）
A:Corrupted blocks, if any, are repaired.
B:Checks are performed for physical corruptions.
C:Checks are performed for logical corruptions.
D:Checks are performed to confirm whether all database files exist in correct locations
E:Backup sets containing both data files and archive logs are created.
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）
A:An object type is a user-defined composite data type. 
B:The attributes of an object type can be those of other object types. 
C:A PL/SQL table of records is an example of a nested object type. 
D:An object type must be declared as a type before the actual object itself can be declared.
Which statement is true regarding virtual private catalogs? （）
A:A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. 
B:The virtual private catalog owner cannot create and modify the stored scripts. 
C:The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. 
D:To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database. 
You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? （）
A:CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
B:CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
C:CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
D:CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
E:CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started？（）
A:Creating the parse tree of the statement
B:Writing the modified data blocks to the data files
C:Writing the modified data to the archived redo log files
D:Updating the control file to indicate the most recent checkpoint
E:Updating the data file header to indicate the most recent checkpoint
F:Reading the blocks to database buffer cache if they are not already there
What are two types of distributed destinations that Oracle WebLogic Sever supports ？（）
A: Shared Distributed Destinations （SDD）
B: Uniform Distributed Destinations （UDD）
C: Weighted Distributed Destinations （WDD）
D: Bounced Distributed Destinations （BDD）
如果想要配置Oracle以使用校验和来验证数据块，将初始化参数（）设置为TRUE。
A:DB_BLOCK
B:DB_EXTENT_CHECKSUM
C:DB_BLOCK_CHECKSUM
D:DB_SEQENT_CHECKSUM
首页 <上一页 137 138 139 140 141 下一页> 尾页