出自:Oracle认证

You have written a custom menu for a Forms application. You saved the menu module to the file custmenu.mmb. In the Property Palette for the form, you set the Menu Module property to custmenu. When you run the form, the custom menu does not appear. What can you do to fix this problem?（）
A:Generate the menu module executable. 
B:Save the menu module as custmenu.mmx. 
C:In the Property Sheet for the form, set the Starting Menu property to custmenu. 
D:In the Property Sheet for the form, set the Menu Module property to custmenu.mmb.
What command would you issue to enable automated backups of control files? （）
A:alter database controlfile autobacku on
B:alter system controlfile autobackup on 
C:configure controlfile autobackup on 
D:enable controlfile autobackup
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import. You executed the following commands to achieve this: What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?（）
A:The scripts in the RCO11 catalog are overwritten.
B:RMAN renames the local stored scripts in the RCO11 catalog.
C:The RMAN session in which the command is executed aborts.
D:RMAN renames the global scripts that are imported from the RCAT10 catalog.
The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）
A:In the template used. 
B:In the data model. 
C:In the life previewer. 
D:In the field property palette.
Online index rebuild functionality has been extended to include which four index structures？（）
A:Bitmap indexes.
B:Reverse key indexes.
C:Function-based indexes.
D:Key-compressed indexes on regular tables.
E:Key-compressed indexes on IOT （including secondary indexes）
You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
A:Database Control
B:Management Server
C:Management Repository
D:Application Server Control
E:Oracle Management Agent
You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）
A:OPTIMAL 
B:INITIAL 
C:PCTINCREASE 
D:NEXT
Which three are true?（）
A:A MERGE statement is used to merge the data of one table with data from another.
B:A MERGE statement replaces the data of one table with that of another.
C:A MERGE statement can be used to insert new rows into a table.
D:A MERGE statement can be used to update existing rows in a table.
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）
A:It would attempt to start the default listener
B:It would start the most recently created listener.
C:It would display an error with a message asking for the listener name to be specified.
D:It would show you a list of listeners and prompts for the listener name that you want to start.
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）
A:Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
B:Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
C:Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
D:Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. 
E:Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
F:Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
当Select Into语句的返回多于一行时，将引发下列哪个异常？（）
A:No_Data_Found
B:To_Many_Row
C:To_Many_Rows
D:Invalid_Number
You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）
A:It will create the tablespace TEMP1 in group G1.
B:It will create the tablespace TEMP1 in group G3.
C:It will not add the tablespace TEMP1 to any group.
D:It will create the tablespace TEMP1 in the default group.
Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）
A: Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.
B: Tell them that their request cannot be met with the current backup strategy.
C: Restore the 19ths backup， apply the online redo logs，and open the database.
D: Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo  logs，and recover the database to the 20th.
E: Use the recover database command to roll back the database from today to the 19th of the month.
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）
A:V$VALID_NLS_VALUES
B:NLS_VALID_VALUES
C:NLS_VALUE_OPTIONS
D:V$NLS_VALUE_OPTIONS
E:V$NLS_VALID_VALUES
Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.   On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.   When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）
A: The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
B: The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
C: The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
D: The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）
A:The instance would normally abort.
B:The instance would not be affected.
C:The instance would be invalid， so would have to be aborted.
D:The instance would remain open， but the LGWR process would fail.
E:The instance would remain open and would automatically create the missing file
Which two SQL*Loader instructions are used to assemble logical records？（）
A:WHEN
B:INFILE
C:CONTINUEIF
D:CONCATENATE
E:TRAILING NULLCOLS
Which two statements are true regarding the SQL Repair Advisor？（） 
A: The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B: The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C: The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D: The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
第一步执行了DELETE命令，删除了某表中的一条记录.第二步执行了COMMIT命令。最后又执行了ROLLBACK命令。请问以下叙述正确的是（）
A:被删除的记录又被恢复回来，仍然存放在数据库的表中
B:被删除的记录彻底从数据库中被删除掉了
C:被删除的记录只是当前用户看不到了，而其它用户还能看到
D:被删除的记录当前用户可以看到，而其它用户却看不到了
E:以上所述都不正确
In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；
A: when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
B: when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C: when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
D: when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E: never， because FLASHBACK TABLE is not a valid command in Oracle 10g.
Which three statements about subqueries are true? （）
A:Asinglerowsubquerycanretrieveonlyonecolumnandonerow.
B:Asinglerowsubquerycanretrieveonlyonerowbutmanycolumns.
C:Amultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.
D:Amultiplerowsubquerycanbecomparedusingthe"；>；"；operator.
E:AsinglerowsubquerycanusetheINoperator.
F:Amultiplerowsubquerycanusethe"；="；operator.
You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?（）
A:SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC
B:SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit
C:SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST
D:SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
Given Which three are valid on line？（）
A:final
B:static
C:native
D:public
E:private
F:abstract
G:protected
You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status What would you do to overcome the error（）
A:Add the user， SYSTEM， to the schemas option.
B:Add the network_link = devdb.us.oracle.com option.
C:Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D:Replace the schemas option with the network_link = devdb.us.oracle.com
E:Replace the dumpfile option with the network_link = devdb.us.oracle.com
You have enabled the Slow Query Log for a short period. When you process the Slow Query Log, you receive the following snip of output: Count: 100 Time=0 .22a (22s) Lock=0.00s (0s) Rows=0.0 (0), root[root] @localhost CREATE TABLE 't1' (id serial,id0 varchar(N) unique key,intcaoll INT (N) ,intco12 INT(N) ,intco13 INT(N) ,intco14 INT(N) ,intco15 INT(N) ,charcol1 VARVHAR(N) ,charcol2 VARCHAR(N) charcol3 VARCHAR (N) ,charcol4 VARVHAR(N) ,charcol5 VARCHAR(N) charcol6 VARCHAR (N) ,charcol7 VARVHAR(N) ,charcol8 VARCHAR(N) charcol9 VARCHAR (N) .charcol 10 VACHAR (N) ) Count: 64000 Time-0.02s (1213s) Lock=0.00s (6s) Rows=1.0 (64000), root [root]@ localhost SELECT intocl1, intco12, intco13, intco14, intco15, intco16,intco17, intco18 ,intcol9, intcol10, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6 ,charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' Count: 1 Time=0.02s (0s) Lock=0.00s (0s) Rows=1.0 (1) agent [agent] @localhost SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user, 's', host) = CURRENT_USER （　） Count: 48000 Time=0.02s (778s) Lock=0.00 (3s) Rows=1.0 (48000), root[root]@localhost SELECT intocl1,intcol2,intcol3, intcol4, intcol5, charcol1, charcol2, charcol3 ,charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's' You want to tune the query such that it provides the greatest overall time savings. Which query will accomplish this?（）
A:CHEATE TABLE 't1' (id serial, id0 varchar (N) unique key, intcol1 INT (N) ,intcol2 INT (N), intcol3 INT(N) ,intcol4 INT(N), intcol5 INT(N), charool1 VARCHAR (N) ,charcol2 VARCHAR (N), charcol3 VARCHAR(N), charcol4 VARCHAR(N), charcol5 VARCHAR (N) ,charcol6 VARCHAR (N), charcol7 VARCHAR(N), charcol8 VARCHAR(N), charcol9 VARCHAR (N) ,charcol10 VARCHAR (N)
B:SELECT intcol1, intcol2, intcol3, intcol4, intcol5, intcol6, intcol7, intcol8, intcol9, Intcol10, intcol11, intcol12, intcol13, intcol14, intcol15, intcol16, intcol17, intcol18, intcol19, charcol10 FROM t1 WHERE id = 's'
C:SELECT Select_priv, Repl_client_priv, Show_db_priv, Super_priv, Process_priv FROM mysql.user WHERE CONCAT (user,'s', host) = CURRENT_USER()
D:SELECT intcol1, intcol2, intcol3, intcol4, intcol5, charcol1, charcol2, charcol3, charcol4, charcol5, charcol6, charcol7, charcol8, charcol9, charcol10 FROM t1 WHERE id = 's'
The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（）
A:Column definitions cannot be altered to add DEFAULT values.
B:A change to the DEFAULT value affects only subsequent insertions to the table.
C:Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
D:All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN> run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows：  RMAN/x7f03009： failure of allocate command on c1 channel  ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name：  What could explain why the statement failed？（）
A:sbt is not a valid device type.
B:Media Management Library was not loaded.
C:The sbt device cannot be used for data file backups.
D:No path was defined in the ALLOCATE CHANNEL command.
E:The channel is currently being used by another RMAN session.
Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）
A:The database remains open.
B:The database gets dismounted.
C:The database becomes read only.
D:The database instance gets aborted.
E:The database gets shut down automatically.
F:The status of the database depends on the status of the USERS tablespace.
The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below：   SELECT * FROM employees WHERE department_id=50；  SELECT * FROM employees WHERE department_id=70； There is an index on the DEPARTMENT ID column of the 1，000，000 row EMPLOYEES table. Ninety percent of the employees are part of the DEPARTMENT_ID 50. In which two scenarios will Oracle9i share the corresponding cursors for the two statements？（）
A:A
B:B
C:C
D:D
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）  
A: Database Datafiles
B: Database Control Files
C: Online redo logs
D: Archived redo logs
E: The database SPFILE
F: None of the above，all these files are backed up
首页 <上一页 123 124 125 126 127 下一页> 尾页