1、Which two statements about online redo log members in a group is true
B、All members in a group are the same size
C、The members should be on different disk drivers
2、Which command does a DBA user to list the current status of archiving
A、ARCHIVE LOGLIST
3、How many control files are required to create a database
A、one
4、Complete the following sentence: The recommended configuration fro control files is
C Two control files on two disks
形容难过的词语二字词语>网银跨行转账多少时间到账5、When you create a control file, the database has to be:
C Open
6、Which data dictionary view shows that the database is in ARCHIVELOG mode C、V$DATABASE
7、What is the biggest advantage of having the control files on different disks B Guards against failure
8、Which file is used to record all changes made to the database and is used only when performing an instance recovery A, Archive log file
9、How many ARCn processes can be associated with an instance C ten
10、Whichtwo parameters cannot be used together to specify the archive destination
A．LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST
第七章
1、A collection of segments is a an: C、TABLESPACE
2 When will the rollback information applied in the event of a database crash C immediately after re-opening the database before the recovery
3、The data dictionary tables and views are stored in
B、SYSTEM tablespace
4 PCTFREE and PCTUSED together should not exceed:
A 100
5 Which of the following three portions of a data block are collectively called as Overhead
C table directory, row directory and data block header
6 When the database is open , which of the following tablespace must be online A, SYSTEM
7 Sorts can be managed efficiently by assigning _____ tablespace to sort operations B TEMPORARY
8 The sort segment of temporary tablespace is created:
A at the time of the first sort operation
9 Which of the following segments is self administered
B ROLLBACK
10 What is the default temporary tablespace, if no temporary tablespace is defined D SYSTEM
11 Rollback segments are used for: D ,all of the above
12 Rollback segment stores:
二本院校有哪些学校A old values of the data changed by each transaction
第八章
1 An Oracle instance is : D All of the above
2 The SGA consists of the following items:
D All of the above
3 The area that stores the blocks recently used by SQL statements is called: B Buffer Cache
4 Which of the following is not a background server processes in Oracle B LGWR
5 Which of the following is valid background server processes in Oracle D All of the above
6 The process that writes the modified blocks to the data files is: 男士牛仔裤A DBWR
7 The process that records information about the changes made by all transactions that commit is :D None of the above
8 Oracle does no consider a transaction committed until:
B The LGWR successfully writes the changes to redo
9 The process that performs internal operations like tablespace coalescing is :B SMON
10 The process that manages the connectivity of user sessions is: A PMON
第十章
1 The Database must be in this mode for in instance to be started: C NOMOUNT
meihua2 When Oracle startups up , what happens if a datafile or redo file no available or corrupted due to OS Problems
B Oracle returns a warning message and does not open the database
3 The RESTRICTED SESSION system privilege should be given to
B DBA, who perform structural maintenance exports and imports the data
4 When Starting up a database, If one or more of the files specified in the CONTROL_FILES parameter does not exist ,or cannot be opened
A Oracle returns a warning message and does not mount the database
5 Bob tried to shutdown normal, Oracle said it was unavailable, and when he tried to startup, oracle said that it was already started. What is the best mode that bob can use to force a shutdown on the server B ABORT
6 Tom issued a command to startup the database. What modes does the Instance and Database pass through to finally have the database open
B NOMOUNT, MOUNT, OPEN
数学类专业7 Diane is a new DBA and issued a shutdown command while her server is being used. After a while she figures that oracle is waiting for all the users to sign off. What shutdown mode did she use: A NORMAL
8 Which script file creates commonly used data dictionary views B
9 In order to perform a full media recovery, the Database must be :
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
发表评论