单选题You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）A imp hr/hr TABLES=（ts_employees） rows=yB imp system/manager FROMUSER=hr file=expdat.dmpC imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmpD imp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts

考题 Before replacing a MAG Series device, using the admin GUI, you export two backup files, system.cfg from Maintenance ImportfExport Configuration and user.cfg from Maintenance Import/Export Users. When you receive the new hardware, you import all of the settings stored in the system.cfg file (including the IP address, network configuration, and device certificates), but you fail to import the user.cfg file.Which three configuration areas were updated by system.cfg?（）A. Cluster configuration settingsB. Static routesC. SNMP settingsD. Sign-in policiesE. MAC authentication realms

查看答案

考题 YouneedtoimportalldefinitionsofobjectsbelongingtotheTS_EMPLOYEEStablespacebyusingtheexportfileexpdat.dmp.Whichimportstatementiscorrect?() A.imphr/hrTABLES=（ts_employees）rows=yB.impsystem/managerFROMUSER=hrfile=expdat.dmpC.imphr/hrTRANSPORT_TABLESPACE=yfile=expdat.dmpD.impsystem/managerTRANSPORT_TABLESPACE=yTABLESPACE=ts_employees

查看答案

考题 You are the administrator of a Windows 2000 Server computer. A folder named HR-Data on the system partition of the server is shared on the network as HR-Data. The owner of the HR-Data folder is Administrators.The shared permissions and NTFS permissions are shown in the following table.Share permissions:Everyone: FULL ControlNTFS permissionsDomain Admins: ReadKatrin: Full ControlKatrin creates a file in the HR-Data folder. She sets the NTFS permissions for the file to list only herself on the access control list, with Full Control permission. Katrin then leaves on vacation and cannot be contacted.Later, you discover that the file contains sensitive information and must be removed from the server as soon as possible. You want to delete the file without modifying any of the permissions for other files in the HR-Data folder. You want your actions to have least possible impact on users who may be using other files in the HR-Data folder. You want to use the minimum amount of authority necessary to delete the file.What should you do?A．Grant yourself Full Control permission for only the HR-data folder and not its subobjects. Delete the file. Then remove Full Control permission for HR-Data folder.B．Take ownership of the HR-Data folder. When prompted, take ownership of the existing files. Grant yourself Full Control permission for the file. Delete the file.C．Take ownership of the file. Grant yourself Modify permission for the file. Delete the file.D．Grant yourself Modify permission for the HR-Data folder and its subobjects. Delete the file. Then remove Modify permission for the HR-Data folder.

查看答案

考题 You are designing a strategy for migrating the UNIX user accounts to Active Directory. Which three actions should you perform?（）A、Import the user accounts as inetOrgPerson objects. B、Import the user accounts into Active Directory by using the Ldifde command-line tool. C、Export all user accounts from the UNIX servers to a text file. D、Export all user accounts and their passwords from the UNIX servers to a text file. Encrypt this file to achieve extra security. E、Assign random passwords to each user object, and securely distribute the password to the users. F、Create the same strong password for each user object, and require users to change their passwords at first logon.

查看答案

考题 Before replacing a MAG Series device, using the admin GUI, you export two backup files, system.cfg from "Maintenance" "ImportfExport Configuration" and user.cfg from "Maintenance" "Import/Export Users". When you receive the new hardware, you import all of the settings stored in the system.cfg file (including the IP address, network configuration, and device certificates), but you fail to import the user.cfg file. Which three configuration areas were updated by system.cfg?（）A、Cluster configuration settingsB、Static routesC、SNMP settingsD、Sign-in policiesE、MAC authentication realms

查看答案

考题 The user HR receives the following error while inserting data into the TTK table： ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon investigation， you find that SMD is a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

查看答案

考题 You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）A、imp hr/hr TABLES=（ts_employees） rows=yB、imp system/manager FROMUSER=hr file=expdat.dmpC、imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmpD、imp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts_employees

查看答案

考题 Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A、Perform Export before TSPITR and Import after TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

查看答案

考题 Which of the following roles must be granted to a user to perform a full database import？（）A、CONNECTB、IMP_FULL_DATABASEC、FULL_EXPORT_PRIVSD、RESOURCEE、FULL_IMPORT_PRIVS

查看答案

考题 Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A、All database operations performed by the impdp command are logged.B、Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C、Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D、None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

查看答案

考题 You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？（）A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system （OS） file.D、It is a Recovery Manager （RMAN） script

查看答案

考题 The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic

查看答案

考题 Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

查看答案

考题 What is true about this statement used during import？（） imp hr/hr tables= （employee， departments） file=hr.dmp ignore=yA、It ignores duplicates.B、It prevents character set translation on import.C、It allows rows to be inserted into a table that already exists.D、It ignores storage parameters in the DML executed during import.

查看答案

考题 You are designing a strategy for migrating the UNIX user accounts to Active Directory. Which three actions should you perform？（）A、 Import the user accounts as inetOrgPerson objects.B、 Import the user accounts into Active Directory by using the Ldifde command-line tool.C、 Export all user accounts from the UNIX servers to a text file.D、 Export all user accounts and their passwords from the UNIX servers to a text file. Encrypt this file to achieve extra security.E、 Assign random passwords to each user object， and securely distribute the password to the users.F、 Create the same strong password for each user object， and require users to change their passwords at first logon.G、 Instruct users to use the same name and password as they used on the UNIX servers.

查看答案

考题 You are the network administrator in the New York office of TestKing. The company network consists of a single Active Directory domain The New York office currently contains one Windows Server 2003 file server named TestKingA. All file servers in the New York office are in an organizational unit (OU) named New York Servers. You have been assigned the Allow - Change permission for a Group Policy object (GPO) named NYServersGPO, which is linked to the New York Servers OU. The written company security policy states that all new servers must be configured with specified predefined security settings when the servers join the domain. These settings differ slightly for the various company offices. You plan to install Windows Sever 2003, on 15 new computers, which all functions as file servers. You will need to configure the specified security settings on the new file servers. TestKingA currently has the specified security settings configured in its local security policy. You need to ensure that the security configuration of the new file servers is identical to that of TestKingA. You export a copy of TestKingA's local security policy settings to a template file. You need to configure the security settings of the new servers, and you want to use the minimum amount of administrative effort. What should you do?（）A、Use the Security Configuration and Analysis tool on one of the new servers to import the template file.B、Use the default Domain Security Policy console on one of the new servers to import the template file.C、Use the Group Policy Editor console to open NYServersGPO and import the template file.D、Use the default Local Security Policy console on one of the new servers to import the template file.

查看答案

考题单选题You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）A imp hr/hr TABLES=（ts_employees） rows=yB imp system/manager FROMUSER=hr file=expdat.dmpC imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmpD imp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts_employees

查看答案

考题单选题You are the network administrator in the New York office of TestKing. The company network consists of a single Active Directory domain The New York office currently contains one Windows Server 2003 file server named TestKingA. All file servers in the New York office are in an organizational unit (OU) named New York Servers. You have been assigned the Allow - Change permission for a Group Policy object (GPO) named NYServersGPO, which is linked to the New York Servers OU. The written company security policy states that all new servers must be configured with specified predefined security settings when the servers join the domain. These settings differ slightly for the various company offices. You plan to install Windows Sever 2003, on 15 new computers, which all functions as file servers. You will need to configure the specified security settings on the new file servers. TestKingA currently has the specified security settings configured in its local security policy. You need to ensure that the security configuration of the new file servers is identical to that of TestKingA. You export a copy of TestKingA's local security policy settings to a template file. You need to configure the security settings of the new servers, and you want to use the minimum amount of administrative effort. What should you do?（）A Use the Security Configuration and Analysis tool on one of the new servers to import the template file.B Use the default Domain Security Policy console on one of the new servers to import the template file.C Use the Group Policy Editor console to open NYServersGPO and import the template file.D Use the default Local Security Policy console on one of the new servers to import the template file.

查看答案

考题多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $ sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.

查看答案

考题单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

查看答案

考题单选题Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object？（）A Perform Export before TSPITR and Import after TSPITRB Move objects to another schema that has the same tablespace assignedC Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）D Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）

查看答案

考题单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）A use the external table populationB use the Oracle Data Pump export and import utilityC use the conventional path data load of SQL*Loader utilityD use the direct path data load of Oracle export and import utility

查看答案

考题单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A All database operations performed by the impdp command are logged.B Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

查看答案

考题单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）A Perform Export before TSPITR and Import after TSPITRB Move objects to another schema that has the same tablespace assignedC Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

查看答案

考题单选题You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？（）A It is a SQL script.B It is a PL/SQL file.C It is an operating system （OS） file.D It is a Recovery Manager （RMAN） script

查看答案

考题单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A All database operations performed by the impdp command are logged.B Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

查看答案

考题单选题After you back up /export using a file system snapshot， and you have removed the snapshot， you also need to remove the backing store. If the snapshot was created with： # mkdir /var/tmp/backup-snaps # fssnap -o bs=/var/tmp/backup-snaps /export Which file do you need to remove？（）A AB BC CD D

查看答案

考题单选题What is true about this statement used during import？（） imp hr/hr tables= （employee， departments） file=hr.dmp ignore=yA It ignores duplicates.B It prevents character set translation on import.C It allows rows to be inserted into a table that already exists.D It ignores storage parameters in the DML executed during import.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：