From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating

考题 Which two are attributes of ／SQL*Plus? () A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.

查看答案

考题 From SQL*Plus, you issue this SELECT statement:You use this statement to retrieve data from a data table for()。 A. UpdatingB. ViewingC. DeletingD. InsertingE. Truncating

查看答案

考题 SQL*Plus是运行在B/S模式下的工具，而iSQL*Plus是运行在C/S模式下的工具。

查看答案

考题 Which statement correctly describes SQL and /SQL*Plus?（）A、Both SQL and /SQL*plus allow manipulation of values in the database.B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

查看答案

考题 How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（） A、 Issue the grant command from the SYS user （or equivalent） of the target database.B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.

查看答案

考题 In which scenario will you use the Flashback Transaction Query feature？（）A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

查看答案

考题 Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

查看答案

考题 You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）A、PMON coordinates media recovery.B、SMON coordinates instance recovery.C、PMON coordinates instance recovery.D、Undo Advisor would roll back all uncommitted transactions.E、SQL*PLUS reports an error with the message asking you to perform instance recovery.

查看答案

考题 Which two are attributes of iSQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accessed from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

查看答案

考题 You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.D、You should place a unique index on the PartNum column.

查看答案

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 cluster. According to the company requirement, the failover response of the cluster has to be tested. The company assigns this task to you. On the cluster, you have to implement a manual failover. What should you do? （） A、The contents of a shared folder on the active node should be encrypted by using Encrypting File System (EFS) B、You should restore a backup to the active node C、You should get rid of the shared array from the active node D、From the active node, you have to uplug the network cable(s)

查看答案

考题 Which two are attributes of /SQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accesses from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

查看答案

考题多选题In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;A$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sqlBMysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'C$ mysql – u root – p – h localhost test ＜ /tmp/t1.sqlDMysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1E$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

查看答案

考题单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least. Which action should you perform？（）A First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.B First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.C First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.D You should place a unique index on the PartNum column.

查看答案

考题多选题Which two are attributes of /SQL*Plus? （）A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accesses from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

查看答案

考题多选题Which two are attributes of iSQL*Plus? （）A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accessed from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

查看答案

考题单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）A Issue the grant command from the SYS user （or equivalent） of the target database.B Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E Issue the grant command from RMAN when connected to the target database.

查看答案

考题多选题You issued the following command： SQL DROP TABLE MYTABLE； SQL SHOW RECYCLEBIN The following output is returned： ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ------------- ------------------------------ --------------- -------------------- MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE 2005-01-13：20：11：31 You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）ADROP TABLE MYTABLE PURGE；BPURGE RECYCLEBIN；CPURGE TABLE MYTABLE；DPURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；

查看答案

考题单选题You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（）A Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E Issue the restore spfile from autobackup command from the RMAN prompt.

查看答案

考题单选题You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?（）A backup database plus archivelogB backup database plus archivlog until time ‘10:00‘C backup database plus archivelog timeout ‘10:00‘D backup database plus archivelog duration 10:00

查看答案

考题单选题Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）A User processB Server processC System Monitor (SMON)D Process Monitor (PMON)E Checkpoint process (CKPT)

查看答案

考题单选题Which statement correctly describes SQL and /SQL*Plus?（）A Both SQL and /SQL*plus allow manipulation of values in the database.B /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

查看答案

考题多选题Which two are attributes of iSQL*Plus? （）AiSQL*Plus commands cannot be abbreviated.BiSQL*Plus commands are accessed from a browser.CiSQL*Plus commands are used to manipulate data in tables.DiSQL*Plus commands manipulate table definitions in the database.EiSQL*Plus is the Oracle proprietary interface for executing SQL statements.

查看答案

考题单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?（）A Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B Capture the plans from the previous version using STS and then load them into the stored outline.C Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).D Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

查看答案

考题单选题In which scenario will you use the Flashback Transaction Query feature？（）A when you want to restore an important table that is dropped from the Recycle BinB when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC when you want to restore a dropped user’s schemaD when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

查看答案

考题多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.AUpdatingBViewingCDeletingDInsertingETruncating

查看答案

考题多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

查看答案

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

更多 “ From SQLPlus, you issue this SELECT statement: SELECT FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating” 相关考题

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

更多 “ From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating” 相关考题

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

更多 “ From SQLPlus, you issue this SELECT statement: SELECT FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating” 相关考题