A.One tablespace has only one datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces
您可能感兴趣的试卷
你可能感兴趣的试题
A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON
A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT
A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running
A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP
A.SYSTEM
B.OUTLN
C.INTERNAL
D.SYS
A.Clone
B.Copy
C.Template
D.Terminal
A.DB_CREATE_FILE_DEST
B.DB_CREATE_ONLINE_LOG_1
C.DB_CREATE_ONLINE_LOG_2
D.The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
A.When the instance is started
B.When the database is mounted
C.When the database is opened
D.When the database is closed
A.Acquire locks on table queried
B.Generate redo for statement
C.Fetch data from disk into memory
D.Write changes to disk
A.ALTER DATABASE
B.SET TRANSACTION
C.ALTER ROLLBACK SEGMENT
D.ALTER TABLE
最新试题
Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?()
You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? ()
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?()
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?()
The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?()
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?()
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()
Records from the data dictionary information are stored in which of the following database memory areas?()