Oracle认证考试章节练习(2020.01.15)

单项选择题
在Oracle中，表分区方式（）建议分区数是2的幂（2、4、8等），以获得最平均的数据发布。
A.范围分区
B.列表分区
C.散列分区
D.复合分区
单项选择题
Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）
A.RESTORE
B.RECOVER
C.REPORT
D.BACKUP
多项选择题
You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?（）
A. Increase the value of the ASM_POWER_LIMIT parameter.
B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
C. Specify the statement that adds the disk back to the disk group.
D. Increase the number of ASMB processes.
E. Increase the number of DBWR_IO_SLAVES in the ASM instance.
单项选择题
You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）
A.Use the database link.
B.Use the SQL*Loader utility.
C.Use the Oracle Data Pump utility.
D.Create an external table and leave the data in the flat file
多项选择题
Examine the SQL statements that creates ORDERS table: CREATE TABLE orders(SER_NO NUMBER UNIQUE,ORDER_ID NUMBER,ORDER_DATE DATE NOT NULLSTATUS VARCHARD2(10)CHECK (status IN ('CREDIT','CASH')),PROD_ID_NUMBERREFERENCES PRODUCTS(PRODUCT_ID),ORD_TOTAL NUMBER,PRIMARY KEY (order id, order date));For which columns would an index be automatically created when you execute the aboveSQL statement? （）
A. SER_NO
B. ORDER_ID
C. STATUS
D. PROD_ID
E. ORD_TOTAL
F. Composite index on ORDER_ID and ORDER_DATE
单项选择题
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine（）
A.host naming method
B.local naming method
C.external naming method
D.directory naming method
多项选择题
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？（）
A. A total of 14 GB memory will be allocated to the automatically tuned memory components
B. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB
D. A maximum of 3 GB can be allocated to shared pool
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
单项选择题
You deploy two different applications to the WebLogic container. One application use Xerces parser version A and the other application uses Xerces parser version B. Both these versions are different from the parser version that the WebLogic server uses internally. You want to use the Filtering Classloader feature to solve this problem.What action would you take to generate proper filtering Classloader entries?（）
A.Modify the applications to use the same version that WebLogic uses internally.
B.Based on available examples of Filtering Classloader entries, try to modify get the proper entries.
C.Deploy and use the Classloader Analyzing Tool to resolve all conflicts with conflicting libraries. This tool will generate all proper entries.
D.Split the application into separate WebLogic containers and use different WLS versions of Xerces but identical that applications require.
E.Look for a WebLogic release that uses the same version of Xerces that the applications use.
单项选择题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）
A.Displays only the list of default values
B.Displays only the list of all basic parameters
C.Displays the currently in effect parameter values
D.Displays only the list of all advanced parameters
E.Displays the list of all the parameter files of a database
F.Displays the current contents of the server parameter file.
多项选择题
Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
D.The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

首页

题库

网课

在线模考

桌面端

Oracle认证考试章节练习(2020.01.15)

在Oracle中，表分区方式（）建议分区数是2的幂（2、4、8等），以获得最平均的数据发布。

Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine（）

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？（）

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

Oracle认证考试章节练习(2020.01.15)

在Oracle中，表分区方式（）建议分区数是2的幂（2、4、8等），以获得最平均的数据发布。

Which of the following commands cannot use the functionality assosciated with theNLS_DATE_FORMAT variable？（）

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine（）

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？ （）

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario？（）