From SQL*Plus, you issue this SELECT statement: https://assets.asklib.com/images/image2/2018080116203977752.jpg You use this statement to retrieve data from a data table for（）。

A . Updating B . Viewing C . Deleting D . Inserting E . Truncating

时间：2022-09-05 10:12:17 所属题库：1Z0-007题库

相似题目

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）

A . The database must have multiplexed redo logs for the flashback to succeed. B . The database must be MOUNTED for the flashback to succeed. C . The database must use block change tracking for the flashback to succeed. D . The database must be opened in restricted mode for the flashback to succeed. E . The database must be opened with the RESETLOGS option after the flashback is complete. F . The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

查看最佳答案
You issue this SQL statement： ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’； What does this SQL statement do？（）

A . It updates the control file with the new location of the data file. B . It updates only the data dictionary with the new location of the data file. C . It changes the location of the user_data01.dbf file in the operating system. D . It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.

查看最佳答案
You issued the following statement： SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）

A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command. B . The command will not execute successfully because resumable space allocation is enabled at the session level. C . The command will execute successfully and resumable space will be allocated at the session level. D . The command will execute successfully and resumable space will be allocated at the instance level.

查看最佳答案
You issued the following statement： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）

A . The control file will be multiplexed. B . The control file will be recreated. C . The script containing the CREATE CONTROLFILE statement will be created. D . The binary backup of the control file will be created.

查看最佳答案
You issued the following statement in your SQL*Plus session： SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

A . creating a table in your schema and you exceed your allocated space quota on the tablespace B . executing a long query that involves a sort operation and the statement runs out of temporary space C . loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit D . creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

查看最佳答案
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

A . Immediately following statement execution B . After the ALTER TABLE DROP UNUSED COLUMNS command is issued C . After the ALTER TABLE SET UNUSED COLUMN command is issued D . After the ALTER TABLE MODIFY command is issued

查看最佳答案
You issued the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（ ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）； END； SQL>/ Which option is NOT a result of executing the above code？（）

A . The switch privilege is granted to the PROG_ROLE role. B . The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group. C . The users cannot grant the switch privilege to other users. D . The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

查看最佳答案
You work as a database administrator for Supportcenter.cn. 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.

查看最佳答案
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）

A . It succeeds because the PDB_ADMIN user has the required privileges. B . It fails because common users are unable to use the SET CONTAINER statement. C . It fails because local users are unable to use the SET CONTAINER statement. D . If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

查看最佳答案
You issued the following statement： SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（）

A . the value of the NLS_LANGUAGE variable B . the value of the NLS_TERRITORY variable C . the value of the NLS_CURRENCY variable D . the character encoding scheme used by the client applicatio

查看最佳答案
A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）

A . Create a database view to retrieve the data. B . Use a clustered index on the SQL Azure database tables. C . Open a new database connection when an operation times out. D . Create SQL Azure database table indexes basedon application querie

查看最佳答案
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

A . DROP emp_dept_uv; B . DELETE emp_dept_uv; C . REMOVE emp_dept_uv; D . DROP VIEW emp_dept_uv; E . DELETE VIEW emp_dept_uv; F . REMOVE VIEW emp_dept_uv

查看最佳答案
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.

A . Updating B . Viewing C . Deleting D . Inserting E . Truncating

查看最佳答案
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.sql B . Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql' C . $ mysql – u root – p – h localhost test ＜ /tmp/t1.sql D . Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1 E . $ mysqlinport – u root – p – h localhost test /tmp/t1.sql

查看最佳答案
You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）

A . The tablespace must be locally managed. B . The tablespace must have only one temp file. C . The tablespace must be made nondefault and offline. D . The tablespace can remain as the default but must have no active sort operations.

查看最佳答案
In which scenario will you issue the following command？（） SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；

A . when all the control files are missing and only a binary backup of the current control file exists B . when a multiplexed copy of the current control file is missing C . when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists D . when the SPFILE is missing

查看最佳答案
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.&e

查看最佳答案
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

A . All data along with the table structure is deleted B . The pending transaction in the session is committed C . All indexes on the table will remain but they are invalidated D . All views and synonyms will remain but they are invalidated E . All data in the table are deleted but the table structure will remai

查看最佳答案
Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）

A . ALTER SYSTEM KILL SESSION B . ALTER SYSTEM DISCONNECT SESSION C . ALTER SYSTEM QUIESCE RESTRICTED D . ALTER SYSTEM ENABLE RESTRICTED SESSION

查看最佳答案
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 process B . Server process C . System Monitor (SMON) D . Process Monitor (PMON) E . Checkpoint process (CKPT)

查看最佳答案
You issued the following command on the temporary tablespace LMTEMP in your database： SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M； Which requirement must be fulfilled for this command to succeed？（）

A . The tablespace must be locally managed. B . The tablespace must have only one temp file. C . The tablespace must be made nondefault and offline. D . The tablespace can remain as the default but must have no active sort operations.

查看最佳答案
Evaluate this SQL statement:What will happen if you remove all the parentheses from the calculation？（）

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/b0aed9f70f3cf7c71c4d975acbe48082.jpg' /> A. The value displayed in the CALC_VALUE column will be lower. B. The value displayed in the CALC_VALUE column will be higher. C. There will be no difference in the value displayed in the CALC_VALUE column. D. An error will be reported.

查看最佳答案
While troubleshooting a connectivity problem on the network, you issue the ping command from your PC command prompt, but the output shows "request times out."

At which OSI layer is this problem associated with？ A．The data link layer B．The application layer C．The access layer D．The session layer E．The network layer

查看最佳答案
While troubleshooting connectivity issues, you log into a remote router. From there,you wish to see the layer 1 and layer 2 status of the interface.Which of the following IOS commands would you issue to check the current IP addressing, as well as theyer 1 and layer 2 status of an interface？（）

A. TK1 show version B. TK1 show protocols C. TK1 show interfaces D. TK1 show controllers E. TK1 show ip interface F. TK1 show startup-config

查看最佳答案

推荐题目