[Q][031]Discuss Together

xmzw

QUESTION NO: 38
For a tablespace created with automatic segment-space management, where is free space managed?
A. In the extent
B. In the control file
C. In the data dictionary
D. In the undo tablespace
Answer: D
书上好像没写清楚，我猜是A

xmzw

QUESTION NO: 40
The credit controller for your organization has complained that the report she runs to show customers with bad credit ratings takes too long to run. You look at the query that the report runs and determine that the report would run faster if there were an index on the CREDIT_RATING column of the CUSTOMERS table.
The CUSTOMERS table has about 5 million rows and around 100 new rows are added every month. Old records are not deleted from the table.The CREDIT_RATING column is defined as a VARCHAR2(5) field. There are only 10 possible credit ratings and a customer's credit rating changes infrequently. Customers with bad credit ratings have a value in the CREDIT_RATINGS column of 'BAD' or 'F'.
Which type of index would be best for this column?
A. B-Tree
B. Bitmap
C. Reverse key
D. Function-based
Answer: D

我选B

xmzw

QUESTION NO: 42
You decide to use Oracle Managed Files in your database.
Which two are requirements with respect to the directories you specify in the DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n initialization parameters? (Choose two).
A. The directory must already exist.
B. The directory must not contain any other files.
C. The directory must be created in the $ORACLE_HOME directory.
D. The directory must have appropriate permissions that allow Oracle to create files in it.
Answer: B, C         

我选择A,D

xmzw

QUESTION NO: 47
Select the memory structure(s) that would be used to store the parse information and actual value of the bind variable id for the following set of commands:
VARIABLE id NUMBER;
BEGIN
:id:=1;
END;
/
A. PGA only
B. Row cache and PGA
C. PGA and library cache
D. Shared pool only
E. Library cache and buffer cache
Answer: B


这题我不是很清楚

xmzw

QUESTION NO: 52
A network error unexpectedly terminated a user's database session.
Which two events occur in this scenario? (Choose two.)
A. Checkpoint occurs.
B. A fast commit occurs.
C. RECO performs the session recovery.
D. PMON rolls back the user's current transaction.
E. SMON rolls back the user's current transaction.
F. SMON frees the system resources reserved for the user session.
G. PMON releases the table and row locks held by the user session.
Answer: E, G

我选择D,G

xmzw

QUESTION NO: 55
Which three statements about the Oracle database storage structure are true? (Choose three.)
A. A data block is a logical structure.
B. A single data file can belong to multiple tablespaces.
C. When a segment is created, it consists of at least one extent.
D. The data blocks of an extent may or may not belong to the same file.
E. A tablespace can consist of multiple data files, each from a separate disk.
F. Within a tablespace, a segment cannot include extents from more than one file.
Answer: A, C, F

我选择A,C,E

wood zhang

A,C,F

AlanFang

QUESTION NO: 100
SALES_DATA is a nontemporary tablespace. You have set the SALES_DATA tablespace
OFFLINE by issuing this comman
ALTER TABLESPACE sales_data OFFLINE NORMAL;
Which three statements are true? (Choose three.)
A. You cannot drop the SALES_DATA tablespace.
B. The SALES_DATA tablespace does not require recovery to come back online.
C. You can read the data from the SALES_DATA tablespace, but you cannot perform any
write operation on the data.
D. When the tablespace SALES_DATA goes offline and comes back online, the event will
be recorded in the data dictionary.
E. When the tablespace SALES_DATA goes offline and comes back online, the event will
be recorded in the control file.
F. When you shut down the database the SALES_DATA tablespace remains offline, and is
checked when the database is subsequently mounted and reopened.
Answer: B, D, E

lwn123

Question 100
因该是BDE, F是错误的

xmzw

QUESTION NO: 7
You are going to re-create your database and want to reuse all of your existing database files. You issue the following SQL statement:
CREATE DATABASE sampledb
DATAFILE
'/u01/oradata/sampledb/system0l.dbf' SIZE 100M REUSE
LOGFILE
GROUP 1 ('/u01/oradata/sampledb/logla.rdo',
'/u02/oradata/sampledb/loglb.rdo') SIZE 50K REUSE,
GROUP 2 ('/u01/oradata/sampledb/log2a.rdo',
'/u02/oradata/sampledb/log2b.rdo') SIZE 50K REUSE
MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10;
Why does the CREATE DATABASE statement fail?
A. You have set MAXLOGFILES too low.
B. You omitted the CONTROLFILE REUSE clause.
C. You cannot reuse the online redo log files.
D. You cannot reuse the data file belonging to the SYSTEM tablespace.
Answer: B

我选D，因为A,B,C都是错的