单选题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（）AThe rows stay in the table only until session termination.BThe rows stay in the table only until the next transaction starts on the table.CThe rows are visible to all current sessions after the transaction is committed.DThe rows stay available for subsequent sessions after the transaction is committed
单选题
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（）
A
The rows stay in the table only until session termination.
B
The rows stay in the table only until the next transaction starts on the table.
C
The rows are visible to all current sessions after the transaction is committed.
D
The rows stay available for subsequent sessions after the transaction is committed
参考解析
解析：
暂无解析
相关考题：
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?() A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion
You issued the following command: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? () A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged
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=employeesWhich two statements are true regarding the command?（）A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.B. It fails because no SQL *Loader data file location is specified.C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.D. It fails because no SQL *Loader control file location is specified.
You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）A、Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORYB、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY tableC、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary tableD、Set binlog_format=MIXED with the – replicate-ignore-temp-table optionE、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
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？（）A、MERGEB、SELECT …CROSS JOINC、INSERT ALL …SELECTD、CREATE VIEW …CONSTRAINT
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（）A、The commands execute successfully.B、Command 6 produces an error because of circular role grant.C、Command 5 produces an error because a role cannot be granted to another role.D、Command 3 produces an error because the MGRROLE role already contains system privileges.E、The table created by HR remains and HR still has the CREATE TABLE system privilege.F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）A、FORMS_DDL B、DO_SQL C、FORM_SUCCESS D、FORM_NOT_SUCCESSE、DBMS.ERROR_CODE
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（）A、The rows stay in the table only until session termination.B、The rows stay in the table only until the next transaction starts on the table.C、The rows are visible to all current sessions after the transaction is committed.D、The rows stay available for subsequent sessions after the transaction is committed
You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do？（）A、Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.B、Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.C、Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.D、Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
单选题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？（）Athe CREATE TABLE .. commandBsorting of the SYSTEM tablespace’s dataCsorting of data required by recursive SQL statementsDthe CREATE TABLE .. ORGANIZATION EXTERNAL .. commandEsorting of data if the users have not been allocated temporary tablespace explicitlyFsorting of data if the users have been allocated temporary tablespace explicitly
单选题You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do？（）APublish the data in the database as an XML Web service by using the FOR XML AUTO clause.BCreate a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.CCreate a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.DHave a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
单选题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 （）AThe rows stay in the table only until session termination.BThe rows stay in the table only until the next transaction starts on the table.CThe rows are visible to all current sessions after the transaction is committed.DThe rows stay available for subsequent sessions after the transaction is committed
单选题Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）AFORMS_DDL BDO_SQL CFORM_SUCCESS DFORM_NOT_SUCCESSEDBMS.ERROR_CODE
单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）AThe tablespace TBS1 is full.BThe user is not the owner of the SYSTEM tablespace.CThe user does not have quota on the TBS1 tablespace.DThe user does not have sufficient system privileges to create table in the TBS1 tablespace.EThe user does not have sufficient privileges to create table on the default permanent tablespace.
单选题You execute the following command to audit the database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command？（）AOne audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.BOne audit record is created for every session when any user successfully drops a table owned by SCOTT.COne audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.DOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.EOne audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）ABecause row IDs may change during the flashback operationBBecause the object number changes after the flashback operationCBecause the rows are retrieved from the recycle bin during the flashback operationDBecause the table is moved forward and back to a temporary during the flashback operation
单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?（）AYou cannot create a table form within Forms. BYou must use the FORMS_DDL built-in to create the table. CYou must use the DBMS_DYNAMIC_DDL package to create the table. DYou can write the CREATE TABLE statement directly into the trigger.
单选题Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）ASRW.BREAK BSRW.SET_ALTER CSRW.REFERENCE DSRW.DO_SQL ESRW.RUN_REPORTFSRW.SET_FIELD
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）AThe table is moved to the SYSAUX tablespace.BThe table is moved to the SYSTEM tablespace.CThe table is removed from the database permanently.DThe table is renamed and remains in the TBSFD tablespace.
单选题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？（）A The statement will fail.B The statement will be executed successfully， and the new time zone will be set for the database.C The statement will be executed successfully， but the new time zone will be set for the current session.DThe statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
单选题Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）A Because row IDs may change during the flashback operationB Because the object number changes after the flashback operationC Because the rows are retrieved from the recycle bin during the flashback operationD Because the table is moved forward and back to a temporary during the flashback opertion
多选题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？（）AIt stores only the temporary table but not its indexes.BIt stores both the temporary table as well as its indexes.CIt must be a nondefault temporary tablespace for the database.DIt can be a default or nondefault temporary tablespace for the database.EIt must be the default temporary tablespace of the user who issues the command.