-
You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
A . The statements remain suspended for at least 60 seconds.
B . The statements are suspended for 60 seconds and then they are executed.
C . The suspended statements error out if the problem is not rectified within 60 seconds.
D . The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.
-
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
A . Because row IDs may change during the flashback operation
B . Because the object number changes after the flashback operation
C . Because the rows are retrieved from the recycle bin during the flashback operation
D . Because the table is moved forward and back to a temporary during the flashback opertio
-
You create a server control that inherits from WebControl. You need to enable the server control to emit markup for a new kind of mobile device. You must not alter the code in the server controls. Which two actions should you perform?()
A . Create a class that inherits HtmlTextWriter and that can emit the new markup.
B . Create a class that inherits StreamWriter and that can emit the new markup.
C . Reference the class in the <capabilities> element of the new device's browser definition file.
D . Reference the class in the <controlAdapters> element of the new device's browser definition file.
-
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
A . All control files are opened
B . All redo files are opened
C . The password file is opened
D . The parameter file is opened
E . All online data files are opened
-
You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Update menu item. Which item property would you alter to gray out the menu option for the role?()
A . Item Roles.
B . Menu Item Roles.
C . Display without Privilege.
D . Use Security.
E . Command Type.
-
You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE); Which statement is true?()
A . When a file is created in DGROUP1 with the template, it would have threeway mirroring.
B . When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
C . When a file is created in DGROUP1 with the template, it would have twoway mirroring and file striping.
D . When a file is created in DGROUP1 with the template, it would have threeway mirroring and file striping.
E . When a file is created in DGROUP1 with the template, it would have twoway mirroring but no file striping.
-
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()
A . the system change number
B . the locations of the redo log files
C . the locations of the datafiles
D . the physical location of all the database change
-
You should have a health()if you work in a restaurant.
A . diploma
B . certificate
C . license
D . passport
-
You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
A . The statements remain suspended for at least 60 seconds.
B . The statements are suspended for 60 seconds and then they are executed.
C . The suspended statements error out if the problem is not rectified within 60 seconds.
D . The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.
-
You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended?()
A . The statements remain suspended for at least 60 seconds.
B . The statements are suspended for 60 seconds and then they are executed.
C . The suspended statements error out if the problem is not rectified within 60 seconds.
D . The statements are automatically suspended 60 seconds after an error is received, and then attempt toexecute normally again.
-
If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?()
A . The command fails unless you specify the FORCE option.
B . The command fails unless you specify the REUSE option.
C . The command must be reissued with a more specific discovery string.
D . The other disks, already part of the disk group,are ignored.
-
You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE);Which statement is true?()
A . When a file is created in DGROUP1 with the template, it would have three-way mirroring.
B . When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
C . When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
D . When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
E . When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.
-
You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE); Which statement is true?()
A . When a file is created in DGROUP1 with the template, it would have three-way mirroring.
B . When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
C . When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
D . When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
E . When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file Striping.
-
Before a Flashback Table operation,you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
A . Because row IDs may change during the flashback operation
B . Because the object number changes after the flashback operation
C . Because the rows are retrieved from the recycle bin during the flashback operation
D . Because the table is moved forward and back to a temporary during the flashback opertio
-
Do you have a ?
-
A: I have a toothache. B:You should .
-
Anyone who doesn’t have a reservation is taking a chance unless you don’t really care whether you have a place to stay.
-
_ a week if you have a partner and _ a week if you are single
-
3 Complete the questions.► Have you got a car? If so, what kind?1 Have you ____ a bike? If so, when do you use it?
-
Once you have finished the design, you may have a whole week.
A.off
B.down
C.in D.up
-
Jony: Do you have a car?
Bill: Yes,I do.___8___
Jony: Is it new?
Bill: It was new in 2008.
John: So, it's pretty old now.
Bill: Yes,it is.___9___
Jony: Do you take good care of it?
Bill: Oh,yes.___10___ And my mechanic changes the oil twice a year.
A.But it still looks good
B.What kind of car do you have
C.I have a Honda
D.I Wash it once a week
-
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?()
A. The index remains invisible.
B. The index is not updated by the DML statements on the indexed table.
C. The index automatically becomes visible in order to have it updated by DML on the table.
D. The index becomes unusable but the table is updated by the DML.
E. The index is updated by the DML on the table.
-
" You have put a bug in his ear" means that you have________.
A.made him laugh
B.shown concern for him
C.made fun of him
D.given him some kind of warning
此题为多项选择题。
-
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?()
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback operation