The rows stay in the table only until session termination.
The rows stay in the table only until the next transaction starts on the table.
The rows are visible to all current sessions after the transaction is committed.
The rows stay available for subsequent sessions after the transaction is committed
第1题:
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?()
第2题:
Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
第3题:
Which two operations can be performed on an external table()
第4题:
Examine the commands executed in the following sequence: 1:SQL> CREATE ROLE mgrrole; 2:SQL> GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL> GRANT select,update ON sh.sales TO mgrrole; 4:SQL> CREATE ROLE ceo IDENTIFIED BY boss; 5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo; 6:SQL> GRANT ceo TO mgrrole; Which statement is true about the above commands()
第5题:
You created the ORDERS table in your database by using the following code: SQL> CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE); Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL> INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’); SQL> INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’); SQL> COMMIT; Next, you issued the following statement to change the time zone for the database: SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’; What will be the result of executing the above statement?()
第6题:
You issued the following command: CREATE GLOBAL TEMPORARY TABLE admin_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT DELETE ROWS TABLESPACE tbs_t1; An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command?()
第7题:
Which two operations can be performed on an external table()
第8题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback opertion
第9题:
The rows stay in the table only until session termination.
The rows stay in the table only until the next transaction starts on the table.
The rows are visible to all current sessions after the transaction is committed.
The rows stay available for subsequent sessions after the transaction is committed
第10题:
The rows stay in the table only until session termination.
The rows stay in the table only until the next transaction starts on the table.
The rows are visible to all current sessions after the transaction is committed.
The rows stay available for subsequent sessions after the transaction is committed
第11题:
The statement will fail.
The statement will be executed successfully, and the new time zone will be set for the database.
The statement will be executed successfully, but the new time zone will be set for the current session.
The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
第12题:
It fails with a Resource Busy error.
It deletes the rows successfully because the table is locked in SHARE mode.
It fails to delete the records because the table is locked in EXCLUSIVE mode.
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
第13题:
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()
第14题:
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? ()
第15题:
You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20))ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction ()
第16题:
You create a table in your database that contains 50,000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes?()
第17题:
While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()
第18题:
User A executes the following command to drop a large table in your database:SQL> DROP TABLE trans; While the drop table operation is in progress, user B executes the following command on the same table:SQL> DELETE FROM trans WHERE tr_type=’SL’; Which statement is true regarding the DELETE command()
第19题:
You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()
第20题:
the CREATE TABLE .. command
sorting of the SYSTEM tablespace’s data
sorting of data required by recursive SQL statements
the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
sorting of data if the users have not been allocated temporary tablespace explicitly
sorting of data if the users have been allocated temporary tablespace explicitly
第21题:
You cannot create a table form within Forms.
You must use the FORMS_DDL built-in to create the table.
You must use the DBMS_DYNAMIC_DDL package to create the table.
You can write the CREATE TABLE statement directly into the trigger.
第22题:
It releases the storage space used by the table.
It does not release the storage space used by the table.
You can roll back the deletion of rows after the statement executes.
You can NOT roll back the deletion of rows after the statement executes.
An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
第23题:
Because row IDs may change during the flashback operation
Because the object number changes after the flashback operation
Because the rows are retrieved from the recycle bin during the flashback operation
Because the table is moved forward and back to a temporary during the flashback opertion
第24题:
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE