更多"In a database with the database cha"的相关试题:
[单项选择]uch a database would be extremely costly to (set up).
A. transfer
B. destroy
C. establish
D. update
[单项选择]Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
A. ASMB
B. PMON
C. RBAL
D. SMON
[单项选择] Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?() 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.
A. 1,3,6,7
B. 2,3,6,8
C. 1,2,3,6,7
D. 1,2,3,6,,7,8
E. 2,3,6,5,7
[单项选择]Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible?()
A. Restore the data file for the SYSTEM tablespace then open the database.
B. Restore all redo logs form last night's backup, then restart the database.
C. Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.
D. Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
[单项选择]Such a database would be extremely costly to {{U}}set up{{/U}}.
A. establish
B. destroy
C. update
D. transfer
[单项选择]We will {{U}}set off{{/U}} after he finishes packing.
A. set out
B. set back
C. set up
D. set down
[单项选择]A research center has been {{U}}set up{{/U}} in this country.
A. praised
B. established
C. reformed
D. criticized
[单项选择] In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()
A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)
[单项选择]His long-term {{U}}goal{{/U}} is to set up his own business.
A. idea
B. energy
C. order
D. aim
[单项选择]Why did the U.S. Navy set up underwater microphones around the world in the 1960s
A. To listen for changes in ocean structure.
B. To listen for changes of ocean currents or volcanic activity.
C. To make sure whether there was a giant squid deep in the ocean.
D. To follow the track of the Soviet warships under water.
[单项选择]执行下列程序段以后,内存变量a的内容是______。 CLOSE DATABASE A=0 use STOCK GO TOP DO WHILE.NOT.EOF( ) IP 单价>10 a=a+1 ENDIF SKIP ENDDO
A. 1
B. 3
C. 5
D. 7
[单项选择]In the U. S. , the television set has attained the rank of a legal necessity, safe from repossession. ______ debt, along with clothes, cooking utensils, and the like.
A. on accout of
B. at the risk of
C. in case of
D. in spite of
[多项选择] You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()
A. The ASM compatibility attribute controls the format of the disk group metadata.
B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.