-
编辑 删除
转:1Z0-042 记录(四)
242. Consider the following scenario: You have a directory, data, under the disk group tdgroup A. You want to create an alias for one of the data files and you execute the following command:ALTER DI...
-
编辑 删除
转:1Z0-042记录(三)
201. You work as a database administrator for Supportcenter.cn. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this? (Select two)...
-
编辑 删除
转:1Z0-042记录(二)
81. You want to refer the employee personal information stored in operating system(OS) files in EMPLOYEEtable. You plan to add a new column to EMPLOYEE table to achieve this.Which data type would y...
-
编辑 删除
转:1Z0-042 记录(一)
3. You want to create a new optimized database for yourtransactional productionenvironmentto be used by a financial application. While creating the database, you want the Oracle software to take care...
-
编辑 删除
转:the record of learning asm
1、create a diskgroup for asm(no failure groups)when you create a external diskgroup,the initial state of the diskgroup is dismount,you can query the view v$asm_diskgroup to see it.Sql>CREATE DISKGR...
-
编辑 删除
转:1Z0-043记录(四)
43、You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:INSTANCE_TYPE = RDBMSDB_NAME ...
-
编辑 删除
转:1Z0-043记录(三)
29、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 dgroup1ADD TEMPLATE my_tempATTR...
-
编辑 删除
转:1Z0-043记录(二)
18、You are working on an Oracle Database10gdatabase. Because of data loss, you decided to perform. a Flashback Database operation using the following command:SQL> FLASHBACK DATABASE TO TIMESTAMP(SY...
-
编辑 删除
转:1Z0-043记录(一)
1、You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 1...
