A.NLS_LANGB.ORACLE_SIDC.ORACLE_HOMED.ORACLE_BASEE.LD_LI……

单项选择题TheSCOTTuserhasanindexontheITEM_DESCcolumnoftheITEMtable.Aspartoftheyear-endingtask，SCOTTupdatestheITEM_DESCcolumnformostoftherowsintheITEMtable.Howdoesthischangetothetableaffecttheindex？（）

A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is deleted and inserted.

单项选择题Your tnsnames.ora file has the following entry for the service alias ORCL：  ORCL =  （DESCRIPTION =  （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521））   （CONNECT_DATA =  （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com）   ）   ）   The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command：  SQL> CONNECT scott tiger@orcl  What could be the reason for this？（）

A.The listener is not running at the server.
B.The TNS_ADMIN environmental variable is set to a wrong value.
C.The orcl.oracle.com database service is not registered with the listener.
D.The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.

单项选择题Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

A.The table is moved to the SYSAUX tablespace.
B.The table is moved to the SYSTEM tablespace.
C.The table is removed from the database permanently.
D.The table is renamed and remains in the TBSFD tablespace.

多项选择题WhichtwostatementsaboutRecoveryManager（RMAN）backupsaretrue？（）

A.Online redo log files can be backed up.
B.Archived redo log files are backed up.
C.Only used data blocks can be backed up as backup sets.
D.Only consistent database backups can be performed.
E.RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.

单项选择题ThedatabaseusersareconnectingtothePRODdatabasefromdifferentapplications，therebydegradingthedatabaseperformance.Theseniordatabaseadministratorsuspectsthelargenumberofconcurrentconnectionstobethereasonforlowperformanceandasksyoutorestrictthenumberconcurrentconnectionsperdatabaseusertoone.Whichactionwouldyoutaketoachievethisobjective？（）

A.set the SESSIONS to 1 in the parameter file
B.grant SINGLE SESSION privilege to all of the users
C.set the SESSIONS_PER_USER to 1 in the users’ profile
D.grant RESTRICTED SESSION privilege to all of the database users
E.create a role with SINGLE SESSION privilege and assign the role to the users