网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which statements are true regarding a tablespace（）
A
It can span multiple databases.
B
It can consist of multiple data files.
C
It can contain blocks of different sizes.
D
It can contain segments of different sizes.
E
It can contain a part of a nonpartitioned segment
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment” 相关考题
考题
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
考题
单选题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 methodB
local naming methodC
external naming methodD
directory naming method
考题
单选题You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name. Which statement is true in this case（）A
The ORACLE_BASE parameter is not set.B
The installation is being performed by the root user.C
The operating system group that will be specified should have root user as its member.D
The installation is being performed without the Create Starter Database option selected.E
The operating system group that will be specified must have permission to write to the inventory directory
考题
单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command： SQL SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 （4M） Why is the value set to 4194304 and not to 2516582（）A
because 4194304 is the granule sizeB
because 4194304 is the standard block sizeC
because 4194304 is the largest nonstandard block size defined in the databaseD
because 4194304 is the total size of data already available in the database buffer cache
考题
多选题Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）AFailure when no standby database is configuredBFailure because a data file is renamed accidentallyCFailure that requires no archive logs to be applied for recoveryDFailure due to loss of connectivity-for example， an unplugged disk cable
考题
单选题You executed the following commands in an RMAN session for your database instance that has failures： RMAN LIST FAILURE； After some time， you executed the following command in the same session： RMAN ADVISE FAILURE； But there are new failures recorded in the Automatic Diagnostic Repository （ADR） after the execution ofthe last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario（）A
It produces a warning for new failures before advising for CRITICAL and HIGH failures.B
It ignores new failures and considers the failures listed in the last LIST FAILURE command only.C
It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignoredD
It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
考题
单选题Note the points about data dictionary views and dynamic performance views： 1.These are stored in the SYSTEM tablespace. 2.These are the based on the virtual tables. 3.These are owned by the SYSuser. 4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE. 5.V$FIXED_TABLE view can be queried to list the names of these views. Which statements listed describe the data dictionary views（）A
1 and 3B
2，3，and 5C
1，2，and 3D
2，3，4，and 5
考题
单选题You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A
The online redo log files and archived redo log files are required to accomplish the recovery.B
The uncommitted transaction will be committed at the next startup of the database instance.C
The uncommitted transaction is rolled back automatically at the next opening of the database.D
The DBA has to perform the recovery on the database to recover the uncommitted transaction
考题
单选题Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA
Large PoolB
Redo Log BufferC
Database Buffer CacheD
Program Global Area （PGA）
考题
单选题In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A
When the data file of the undo tablespace is autoextensibleB
When there are more than one undo tablespaces available in the databaseC
When the undo tablespace is of a fixed size and retention guarantee is not enabledD
When the undo tablespace is autoextensible and retention guarantee is not enabled
热门标签
最新试卷