A.The leaf blocks in the index are doubly linked.
B.The leaf node stores a bitmap for each key value.
C.The rows with NULL value in key columns also have entries in the index.
D.The deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry
您可能感兴趣的试卷
你可能感兴趣的试题
Given below is a list of scenarios：
1） A user terminates his session abnormally.
2） The connection between the server and the client application terminates because of a network failure.
3） A schema is accidentally dropped.
4） The tablespace is accidentally dropped from the database.
5） The hard disk gets corrupted and the data files in the disk are lost.
6） The database instance abnormally shuts down because of power failure.
Which scenarios require DBAintervention to perform recovery（）
A.1， 3， and 6
B.4， 5， and 6
C.3， 4， and 5
D.1， 2， and 6
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.
Which method would you use to load data into the Oracle database（）
A.Use the external table population.
B.Use the Oracle Data Pump export and import utility.
C.Use the conventional path data load of the SQL*Loader utility.
D.Use the INSERT INTO...SELECT command to load the data
A.Run the root.sh script.
B.Create the oraInst.loc file.
C.Create the tnsnames.ora file.
D.Run the oraInstRoot.sh script.
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.
What would be your next step to improve performance（）
A.Run the SQL Access Advisor.
B.Run the Memory Advisor for the sga
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache
A.The MTTR advisor will be disabled.
B.Automatic checkpoint tuning will be enabled.
C.The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
D.The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.
Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.
Which two statements are trueregarding the MRKT tablespace（）
A.No more data files can be added to the tablespace.
B.Segment space is managed by free lists in the tablespace.
C.A user created without being assigned a default tablespace uses this tablespace.
D.The tablespace can be dropped with the current setting with segments present in it
A.Multiple transactions can use the same undo segment.
B.A transaction is assigned an undo segment when it is started.
C.More than one transaction cannot share the same extent in the undo tablespace.
D.The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
View the Exhibit1， which shows the options that are selected to create the user SL_REP. View the Exhibit2 andexamine the contents of DATABASE_PROPERTIES.
Which two statements are true regarding this user（）
A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database bydefault.
A.Data files
B.Control files
C.Parameter file
D.Online redo log files
E.Server parameter file
最新试题
The database instance has the following parameter setting：OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）
The user HR receives the following error while inserting data into the TTK table：ERROR at line 1：ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace.Which three action would allow the user to insert data（）
Examine the command that is used to create a table：SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users；Which two statements are true about the effect of the above command（）
Which statements are true about logical structures of the Oracle database（）
Which statements are correct about temporary tables（）
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr；Which statement describes the outcome of the command（）
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error（）
You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE；Which statements describe the effect of the command（）