Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?()A、Oracle Data Pump.B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D、Online Table Redefinition.E、Edition-Based Table Redefinition.
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?()
- A、Oracle Data Pump.
- B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
- C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
- D、Online Table Redefinition.
- E、Edition-Based Table Redefinition.
相关考题:
Youwanttoviewthenameofaprogramassociatedwithajobformakingsomechangestotheprogram.Whichviewwillyouquerytofindthenameoftheprogramassociatedwiththejob?() A.DBA_SCHEDULER_JOB_RUN_DETAILSB.DBA_SCHEDULER_RUNNING_JOBSC.DBA_SCHEDULER_JOBSD.DBA_SCHEDULER_JOB_LOG
Whichviewwillyouusetoviewinformationregardingthejobsthatarecurrentlyrunninginadatabase?() A.DBA_SCHEDULER_RUNNING_JOBSB.DBA_SCHEDULER_JOB_RUN_DETAILSC.DBA_SCHEDULER_JOBSD.DBA_SCHEDULER_JOB_LOG
YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment,thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However,youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers,soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation?()A.DBA_AUDIT_TRAILB.DBA_AUDIT_SESSIONC.DBA_FGA_AUDIT_TRAILD.DBA_COMMON_AUDIT_TRAIL
Your ERX router is supporting 100 virtual routers.A specific line module supports IP interfaces in 5 virtual routers.How many routing tables are maintained on that module?() A.0B.1C.5D.100
查看审计策略是否生效的视图是?() A. DBA_AUDIT_EXISTSB. DBA_AUDIT_OBJECTC. DBA_AUDIT_POLICY_COLUMNSD. DBA_AUDIT_POLICIESE. DBA_AUDIT_SESSION
Inordertofindouthowmanydatabaseobjectsauserhascreated,whichviewwouldtheDBAqueryintheOracledatadictionary?() A.DBA_USERSB.DBA_OBJECTSC.DBA_TS_QUOTASD.DBA_TAB_PRIVS
Todeterminethespaceallocatedfortemporarysegments,theDBAcanaccesswhichofthefollowingviews?() A.DBA_TABLESPACESB.DBA_TABLESC.DBA_SEGMENTSD.DBA_FREE_SPACE
November 26thID: 733185Dylan BrownWorld Travel Inc.8840 Mayfair Ave.London, UKMr. Brown,We were unfortunately unable to process your last monthly donation to SaveTheYouth because of anauthorization issue with your company's credit card. Please confirm your credit card number in the space below and return this letter in the enclosed response envelope, or call us toll-free at 1-800-555-9090.Confirmation of credit card information:Card Number: _______________________________Expiration Date: ______________/________________We would like to take this opportunity to thank you for supporting SaveTheYouth. By donating, your companyis helping us pursue our vital mission of protecting children and young people the world over. The youth are our future, but millions suffer from malnutrition and are lacking in medical care, education, drinkable water and adequate public health while in the Western world we have an excess of material items and an embarrassment of riches. With your monthly donation, you are helping and protecting the lives of young people in over 150 countries.We appreciate your company’s help. Together, we are working to create a better world.With Regards,Doreen EnsanProgram DirectorSaveTheYouthWhat is Doreen's main purpose in writing this letter?A. To note that Mr. Brown's last payment couldn't be processedB. To re-confirm his credit card information for safetyC. To thank him for supporting SaveTheYouthD. To explain SaveTheYouth's mission
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()A、DBA_USERS B、DBA_OBJECTS C、DBA_TS_QUOTAS D、DBA_TAB_PRIVS
Your ERX router is supporting 100 virtual routers. A specific line module supports IP interfaces in 5 virtual routers.How many routing tables are maintained on that module?()A、0B、1C、5D、100
Which view will you use to view information regarding the jobs that are currently running in a database?()A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG
Which Scheduler view(s) can be queried to see which jobs are currently executing?()A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_CURRENT_JOBSD、 DBA_SCHEDULER_JOBSE、 DBA_SCHEDULER_EXECUTING_JOBS
Which Scheduler view(s) can be queried to see which jobs are currently executing? ()A、DBA_SCHEDULER_JOB_RUN_DETAILSB、DBA_SCHEDULER_RUNNING_JOBS DBAC、DBA_SCHEDULER_CURRENT_JOBSD、DBA_SCHEDULER_JOBS DBAE、DBA_SCHEDULER_EXECUTING_JOBS
You are the administrator of a small network supporting Windows NT 4.0 computers. You configure a setup script to automatically upgrade Windows NT Workstation 4.0 computers to Windows 2000 Professional. When you attempt to test the process on a single computer, you receive this error message: "The specified Setup script file (path:/unattend.txt) is inaccessible or invalid. Contact your system administrator." Which action will most likely resolve this error? ()A、Add the UnattendedInstall="Yes" parameter to the [Unattended] section of your Unattend.txt fileB、Add the UnattendMode=FullUnattended parameter to the [Data] section of your Unattend.txt fileC、Add the UnattendedInstall="Yes" parameter to the [GuiUnattended] section of your Unattend.txt fileD、Add the UnattendMode=FullUnattended parameter to the [Unattended] section of your Unattend.txt file
单选题Your ERX router is supporting 100 virtual routers.A specific line module supports IP interfaces in 5 virtual routers.How many routing tables are maintained on that module?()A0B1C5D100
单选题The atmosphere in a tank is too lean if it is().Aincapable of supporting combustion because the hydrocarbon content is below the LFL (Lower Flammable Limit)Bcapable of supporting combustion because the hydrocarbon content is above the UFL (Upper Flammable Limit)Ccapable of supporting a fire once startedDnot safe for ballasting
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?()AOracle Data Pump.BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.DOnline Table Redefinition.EEdition-Based Table Redefinition.
单选题When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()ARMAN keeps a list of archive logs in a text file.BThe DBA must manually tell RMAN which archive logs to backup.CRMAN has access to target control file and/or catalog information.DRMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.
单选题Which describes the default behavior when you create a table? ()AThe table is accessible to all users.BTables are created in the public schema.CTables are created in your schema.DTables are created in the DBA schema.EYou must specify the schema when the table is created.
单选题As A DBA, which of the following methods can you use to make a backup of your table?()ARecover Manager (RMAN) utilityBImport utilityCExport utilityDO/S backup command
单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?()AUpgrade the hardware/memory to accommodate the data.BLoad the data into your database by using the PARALLEL clause.CGive analysts DBA privilege, so that they can query DBA_EXTERNAL_TABLES.DUse an external table so you can have the metadata available in your database, but leave the data in the operating system files.
问答题Directions: Talk in English on the following topic for at least 3 minutes. Be sure to make your point clear and supporting details adequate. You should also be ready to answer any questions raised by the examiners during your talk. You need to have your name and registration number recorded. Start your talk with “My name is...”, “My registration number is...” ◆Topic 1:How to Keep Healthy Psychologically? Questions for Reference 1) How serious is the problem of psychological health since it will lead to physical illness and ill effect on life? 2) What are the causes of psychological problem? 3) What are the recommendations you can offer?
问答题Directions: Talk on the following topic for 5 minutes. Be sure to make your points clear and supporting details adequate. You should also be ready to answer any questions raised by the examiners during your talk. You need to have your name and registration number recorded. Start your talk with “My name is...,” “My registration number is...” ◆Topic 1: The Retirement Age for Chinese Questions for reference: 1. Do you agree that the mandatory retirement age for Chinese should be extended? Give your reasons. 2. Some people are opposed to the extension initiative for fear that it might reduce job opportunities for young people. What’s your comment on this opinion? 3. China is facing a surplus labor force. What are the possible solutions to such a problem?