单选题A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）A Acquire locks on table queried B Generate redo for statement C Fetch data from disk in

题目内容(请给出正确答案)

单选题

A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

Acquire locks on table queried

Generate redo for statement

Fetch data from disk into memory

Write changes to disk

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command： SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim； Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）A The command fails because SCOTT still has privileges.B The command succeeds and privileges are revoked from JIM.C The command fails because HR cannot revoke the privileges from JIM.D The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

点击查看答案
第2题

单选题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

点击查看答案
第3题

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

点击查看答案
第4题

单选题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）A CREATE SYNONYM ord FOR orders; This command is issued by OE B CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE C CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator D CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator

点击查看答案
第5题

单选题User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）A UPDATE pets…B SELECT….FROM petsC INSERT INTO pets…D ALTER TABLE pets…

点击查看答案
第6题

单选题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.

点击查看答案
第7题

多选题SQ L*Loader is a utility that can perform which two tasks？（）ALoad data from a disk， tape， or named pipes.BLoad data into an Oracle database using DML statements.CExtract， reorganize， and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.

点击查看答案

单选题A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）A Acquire locks on table queried B Generate redo for statement C Fetch data from disk in

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容