You are attempting to create an Oracle-Managed Files (OMF) tablespace in a production database with the following statement and receive the following error message:
CREATE TABLESPACE tbsl;
ORA-02199: missing DATAFILE/TEMPFILE clause oerr ora 2199
02199, 00000, “missing DATAFILE/TEMPFILE clause”
*Cause: A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause.
*Action: specify DATAFILE/TEMPFILE clause.
What is the corrective action to create the OMF based tablespace?()
A.A
B.B
C.C
D.D
您可能感兴趣的试卷
你可能感兴趣的试题
A.The standby database is protected against write operations.
B.The primary database is protected against write operations.
C.The primary database is protected against data loss and data divergence.
D.The standby database is protected against data loss and data divergence.
A.An improved version of multithreaded server configuration.
B.A connection pooling configuration where several clients are connected to the same server process.
C.Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected.
D.A configuration of Real Application Cluster where the client connection is routed to the least busy instance.
A.The CONNECT INTERNAL is disallowed.
B.The Server Manager tool is no longer supplied.
C.The listener must be running to make a connection.
D.The use of remote password login file (orapw<sid>) is unchanged.
A.The size of the redo buffer in SGA.
B.The instance that will perform recovery in Real Application Cluster database.
C.The number of blocks to be read during instance recovery, or the time needed to complete instance recovery.
D.The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
A.ALTER TABLE employees monitor index employee_idx_fk;
B.ALTER INDEX employee_idx_fk monitoring on;
C.ALTER TABLE employees monitor all indexes;
D.ALTER INDEX employee_idx_fk monitoring usage;
A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.
A.During a query’s parse time only.
B.During a query’s execution time only.
C.During any kind of DML statement execution.
D.During the execution of an INSERT statement only.
A.External tables can be updated.
B.External tables are read-only tables.
C.Indexes can be created on external tables.
D.Indexes cannot be created on external tables.
Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (-
2> ownname => ‘OE’, -
3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, -
4> method opt => ‘for all columns size AUTO’);
What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option?()
A.The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.
B.The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
C.The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema.
D.The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.
Examine the list of variables and their data types:
AME DATA Type
TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS, IDSI INTERVAL YEAR To SECOND
Which three expressions using the new data and time data types are valid?()
A.IDS* 2
B.TS + IYM
C.TS –TSI
D.IDS – TS
E.IDS + IYM
最新试题
Which one of the following files includes the parameter NAMES.DIRECTORY_PATH(hostname)?()
Which of the following parameters must be specified to define the number of dispatchers that need to be started?()
Which of the following roles must be granted to a user to perform a full database import?()
Which data dictionary views displays the error information related to a data file, when an internal read fails on that file?()
The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file. Which naming method was configured?()
As a result of a media failure, the current online redo log group is corrupted. The database crashes, as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform? ()
What is the maximum database block size supported for the Oracle9i database?()
Which Oracle background process frees SGA resources that were allocated to a user process that failed?()
Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()
Which server stack communication layer corresponds to the client application layer in a distributed environment?()