出自:Oracle认证

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?（）
A:Use Data Pump to transfer the existing data to a new encrypted tablespace
B:Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace
C:Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
D:Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace
E:Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
A: The time when the last flashback operation in your database was performed.
B: The time when the first flashback operation in your database was performed.
C: A list of flashback operations performed in your database using SCN and time.
D: The approximate time and the lowest system change number （SCN） to which you can flash back your database.
In which two scenarios do you use SQL* Loader to load data?（）
A:Transform the data while it is being loaded into the database.
B:Use transparent parallel processing without having to split the external data first.
C:Load data into multiple tables during the same load statement.
D:Generate unique sequential key values in specified columns.
The following command is executed to create the baseline template：   SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2），  END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’，  TEMPLATE_NAME=>’Mytemp4’， EXPIRATION=>NULL）；   Which statement is true about the effect of the above command？（）  
A: It creates a baseline template that never expires.
B: It produces an error because no snapshot information is provided to create the baseline.
C: It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.
D: It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.
You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen.  Which parameter of the DBVERIFY utility will you use？（）
A: FILE
B: PARFILE
C: LOGFILE
D: FEEDBACK
You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）
A:configure a default device for RMAN backups
B:temporarily disable the retention policy for RMAN backups
C:configure automatic channel allocation for RMAN backups
D:use the CONFIGURE command to reconfigure the recovery window to 60 days
Examine the description of the CUSTOMERS table: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?（）
A:SELECT city_address, COUNT(*) FROM customers WHERE city_address IN ('Los Angeles', 'San Francisco');
B:SELECT city_address, COUNT(*) FROM customers WHERE city_address IN ('Los Angeles', 'San Francisco') GROUP BY city_address;
C:SELECT city_address, COUNT(customer_id) FROM customers WHERE city_address IN ('Los Angeles', 'San Francisco') GROUP BY city_address, customer_id;
D:SELECT city_address, COUNT(customer_id) FROM customers GROUP BY city_address IN ('Los Angeles', 'San Francisco');
In this scenario， assume that you archive logs 101 to 104 to two archiving destinations， /log1 and /log2. The control file contains archived log records as follows：   Sequence Filename  101 /log1/log_1_101.arc  101 /log2/log_1_101.arc  102 /log1/log_1_102.arc  102 /log2/log_1_102.arc  103 /log1/log_1_103.arc  103 /log2/log_1_103.arc  104 /log1/log_1_104.arc  104 /log2/log_1_104.arc   You accidentally delete logs 102 and 104 from log 1. You run this command：   BACKUP ARCHIVELOG FROM SEQUENCE 101 UNTIL SEQUENCE 105；   What happens？（）
A:A
B:B
C:C
D:D
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）
A:On startup， SMON coordinates instance recovery.
B:On startup， CKPT coordinates instance recovery.
C:On startup， use RMAN to perform instance recovery.
D:Uncommitted changes will be rolled back after the database is opened.
E:On startup， perform media recovery and then instance recovery.
F:On startup， all the files will be synchronized and you get both committed and uncommitted data.
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（）  
A: NLS_SORT = BINARY
B: NLS_SORT = BINARY_AI
C: NLS_SORT = BINARY_CI
D: NLS_SORT = BINARY_AI_CI
E: Binary sorts are case insensitive and accent insensitive by default
（）是一种用于执行SQL语句的Java API，可以为多种关系数据库提供统一访问，它由一组用Java语言编写的类和接口组成。
A:JDBC
B:OCI
C:程序包
D:过程
Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）
A:make redo log files smaller
B:increase the size of the checkpoint file
C:make the changes as per the advice given by MTTR Advisor
D:make the changes as per the advice given by Checkpoint Advisor
Which two client requests are captured during database replay Capture?（） (Choose two)
A:Flashback queries
B:Shared server requests
C:Login and logoff activities of sessions
D:Direct path load of data from external files by using utilities such as SQL *loader
E:Data definition language (DDL) and data manipulation language (DML) operations
Which two operations require undo data？（）
A:committing a transaction
B:rolling back a transaction
C:recovering from failed transactions
D:recording a transaction to redo log files
E:rolling forward during instance recovery
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
A:You can perform consistent backups only.
B:You can perform a complete database backup without shutting down the database instance.
C:You can back up data files only when all data files have the same SCN recorded in the control file.
D:You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands
在Oracle中，关于PL/SQL下列描述正确的是（）。
A:PL/SQL代表Power Language/SQL
B:PL/SQL不支持面向对象编程
C:PL/SQL块包括声明部分、可执行部分和异常处理部分
D:PL/SQL提供的四种内置数据类型是character，integer，float，boolean
The EMP table contains these columns: You need to display the employees who have not been assigned to any department. You write the SELECT statement: What is true about this SQL statement?（）
A:The SQL statement displays the desired results.
B:The column in the WHERE clause should be changed to display the desired results.
C:The operator in the WHERE clause should be changed to display the desired results.
D:The WHERE clause should be changed to use an outer join to display the desired results.
In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting？（）
A:The optimizer statistics are collected automatically.
B:Only the timed operating system （OS） statistics and plan execution statistics are collected.
C:The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D:The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
E:Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
Upon starting your database， you receive the following error：   SQL> startup ORACLE instance started.  Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted.  ORA-00313： open failed for members of log group 1 of thread 1  ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01.log’ ORA-00312： online log 1 thread 1： ’/oracle01/oradata/orcl/redo01a.log’   You can choose from the following steps：   a. Restore the database datafiles.  b. Issue the alter database clear unarchived logfile group 1 command. c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using point-in-time recovery. f. Issue the Startup Mount command to mount the database.  g. Back up the database.  Which is the correct order of these steps in this case？（）
A:a， f， e， d， g
B:f， e， d
C:f， b， c， g
D:a， f， c
E:The database cannot be recovered.
You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result？（）  
A: Hash cluster
B: Index cluster
C: Sorted hash cluster
D: Real Application cluster
在SQL*PLUS版本9中，可以通过以下哪条命令更改当前的用户口令（）
A:pass
B:passw
C:passwd
D:pass word
E:以上所述都不正确
A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）
A: Flashback Drop
B: Flashback Query
C: Flashback Versions Query
D: Flashback Transaction Query
E: Flashback Table
在Oracle中使用（）可以允许用户从逻辑上组织过程、函数、对象类型等各种内容。
A:程序包
B:过程
C:函数
D:对象
Which three are true regarding the use of outer joins? （）
A:You cannot use IN operator in a condition that involves an outerjoin.
B:You use (+) on both sides of the WHERE condition to perform an outerjoin.
C:You use (*) on both sides of the WHERE condition to perform an outerjoin.
D:You use an outerjoin to see only the rows that do not meet the join condition.
E:In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
F:You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
假设用户正在执行UPDATE操作，此时用以下哪种方法可以关闭数据库（）
A:SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORT
B:SHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONAL
C:SHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATE
D:SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
E:SHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?（）
A:Group left. 
B:Form like. 
C:Matrix W/group. 
D:Group above. 
E:Mailing label. 
F:Form letter.
Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）
A: Oracle Net Manager
B: Listener Control utility
C: Database Configuration Assistant
D: Oracle Net Configuration Assistant
Which syntax turns an existing constraint on? （）
A:ALTER TABLE table_name ENABLE constraint_name;
B:ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;
C:ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;
D:ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
（）是在分区中使用范围分区分区数据，而在子分区中使用散列分区方法，它适合于历史数据和条块数据，改善范围分区及其数据放置的管理性，提供了散列分区的并行机制优点。
A:列表分区
B:组合分区
C:交叉分区
D:时间分区
The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）
A:The session is terminated after receiving the error and JIM can continue with his transaction.
B:SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C:The session is rolled back after receiving the error and JIM can continue with his transaction.
D:SCOTT has to reexecute the last command in the transaction after he commits the transaction.
首页 <上一页 33 34 35 36 37 下一页> 尾页