出自:Oracle认证

下列哪个是无效的列名？（）
A:1ST_ID
B:CUST#
C:ADDRESS1
D:EXCEPTION
Which command do you use to create a recovery-catalog schema? （）
A:create recovery catalog 
B:create catalog
C:build catalog 
D:catalog create 
E:mount catalog 
Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）
A:System privileges apply only to the PDB in which they are used.
B:Local users cannot use local system privileges on the schema of a common user.
C:The granter of system privileges must possess the set container privilege.
D:Common users connected to a PDB can exercise privileges across other PDBs.
E:System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）
A:The SELECT statement is syntactically accurate.
B:The SELECT statement does not work because there is no HAVING clause.
C:The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D:The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
Given that t1 is a reference to a live thread， which is true？（）
A:The Thread.sleep（） method can take t1 as an argument.
B:The Object.notify（） method can take t1 as an argument.
C:The Thread.yield（） method can take t1 as an argument.
D:The Thread.setPriority（） method can take t1 as an argument.
E:The Object.notify（） method arbitrarily chooses which thread to notify.
You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?（）
A:It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
B:It generates an error when creating the table because the wallet is closed.
C:It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
D:It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）
A:Include-master-info
B:Master-binlog
C:Include-log-file
D:Master-data
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）  
A: You should perform a log switch
B: You should make a backup of the database
C: You should switch the database to the NONARCHIVELOG mode
D: You should shut down the database instance and perform a complete database recovery
DRAG DROP Click the Task button.
注册Oracle目标数据库的命令是（）。
A:REG DB
B:REGISTER DATABASE
C:DATABASE REGISTER
D:REGST DATABASE
The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）
A: The new setting would be applied but no alerts would be raised immediately.
B: The new setting would be applied and an alert would be raised immediately.
C: The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
D: The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
The CUSTOMERS table has these columns: Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）
A:SELECT customer_id, customer_name   FROM customers   WHERE postal_code CONTAINS NULL;
B:SELECT customer_id, customer_name   FROM customers   WHERE postal_code = '________';
C:SELECT customer_id, customer_name   FROM customers   WHERE postal_code IS NULL;
D:SELECT customer_id, customer_name   FROM customers   WHERE postal code IS NVL;
E:SELECT customer_id, customer_name   FROM customers   WHERE postal_code = NULL;
Which two statements are true regarding the execution of the correlated subqueries？（）
A: The nested query executes after the outer query returns the row.
B: The nested query executes first and then the outer query executes.
C: The outer query executes only once for the result returned by the inner query.
D: Each row returned by the outer query is evaluated for the results returned by the inner query.
下面定义PL/SQL记录的语法正确的是（）。
A:TYPE <记录类型名> IS RECORD
B:TYPE <记录类型名> RECORD
C:RECORD <记录类型名>
D:TYPE RECORD <记录类型名>
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）
A:The PGA_AGGREGATE_TARGET parameter is set to zero.
B:The STATISTICS_LEVEL parameter is setto basic.
C:Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.
D:The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.
Which two operations can be flashed back using the Flashback technology？ （）
A:DROP USER SMITH；
B:DROP TABLE EMPLOYEES；
C:DROP TABLESPACE USERS；
D:ALTER TABLE SALES_REP DROP PARTITION P1；
E:ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
What is the purpose of the until change option of the restore command？（）  
A: It allows you to select the SCN that you want to restore to.
B: It allows you to select the log sequence number you want to restore to.
C: It allows you to select the timestamp you want to restore to.
D: It allows you to manually stop the restore at any time as online redo logs are applied.
E: None of the above.
Identify the two situations in which the alert log file is updated with details. （）
A:Running a query on a table returns "ORA-600： Internal Error."
B:Inserting a value in a table returns "ORA-01722： invalid number."
C:Creating a table returns "ORA-00955： name is already used by an existing object."
D:Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E:Rebuilding an index using ALTER INDEX ...REBUILD fails with an error "ORA-01578： ORACLE data block corrupted （file # 14， block # 50）.
What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?（）
A:100KB default, 10TB maximum
B:256KB default, 1024MB maximum
C:10MB default, 126PB maximum
D:64KB default, 1EB maximum
E:1MB default, 64MB maximum
In which two cases would you use an outer join? （）
A:The tables being joined have NOT NULL columns.
B:The tables being joined have only matched data.
C:The columns being joined have NULL values.
D:The tables being joined have only unmatched data.
E:The tables being joined have both matched and unmatched data.
F:Only when the tables have a primary key/foreign key relationship.
The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1.Display the salary multiplied by the commission_pct. 2.Exclude employees with a zero commission_pct. 3.Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）
A:all of the desired results
B:two of the desired results
C:one of the desired results
D:an error statement
Which command is used to open the database after an incomplete recovery？（）
A: alter database open
B: alter database open repairlog
C: alter database open resetlogs
D: alter database open resetlog
E: alter database resetlogs open
假定已经定义了一个名为arr_type的PL/SQL表类型，那么怎样实例化一个arr_type类型的变量（）
A:v_arr arr_type;
B:v_arr is arr_type;
C:v_arr of arr_type;
D:v_arr arr_type%type;
Identify three components of the WebLogic JMS architecture.（）
A:JMS Server
B:JMS Module
C:Node Manager
D:Queue Manager
E:Persistent Store
Examine the description of the STUDENTS table: Which two aggregate functions are valid on the START_DATE column?（）
A:SUM(start_date)
B:AVG(start_date)
C:COUNT(start_date)
D:AVG(start_date, end_date)
E:MIN(start_date)
F:MAXIMUM(start_date)
Which three JVM options would you add to investigate performance issues in a Hot-Spot JVM?（）
A:-xx:+PrintGCDetails
B:-xx:+PrintGCTimeStamps  
C:-xx:+HandlePromotionFailure
D:-verbose:gc
E:-server
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）
A:backup of offline tablespaces
B:backup of read­only tablespaces
C:backup of system­critical tablespaces
D:backup of online， locally managed tablespaces
E:backup of read/write dictionary­managed tablespaces
在关闭数据库时，要求当前尚未处理完成的事务立即停止处理，未完成事务进行回滚。可采用下列哪种方式（）
A:SHUTDOWN
B:SHUTDOWN ABORT
C:SHUTDOWN IMMEDIATE
D:SHUTDOWN NORMAL
E:SHUTDOWN TRANSACTIONAL
You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）
A:3 hours
B:6 months
C:until last year
D:until last commit
E:until the point when the undotablespacewas refreshed
F:until the database is shut down and the memory erased
对数值型变量V_NUM，进行四舍五入，保留小数点后两位，以下操作正确的是（）
A:SUBSTR（V_NUM，1，2）
B:TRUNC（V_NUM，2）
C:TRUNC（V_NUM，-2）
D:ROUND（V_NUM，2）
E:ROUND（V_NUM，-2）
首页 <上一页 114 115 116 117 118 下一页> 尾页