-
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？（）
A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B . One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
-
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.
-
While troubleshooting some connectivity issues，you issue the “show ip ospf database”in order to ex amine the link state database. Which three of the statements below are true regarding the OSPF link state database（）
A . Each router has an identical link state database.
B . External routes are imported into a separate link state database.
C . Syn chronization of link state databases is maintained via floodingo f LSAs.
D . Information in the link state database is used to build a routing table by calculating a shortest-path tree.
E . By default,link state databases are refreshede very 10 minutes in the absence of topology changes.
-
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 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？（）
A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B . One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
-
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable： SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about the effect of the command（）
A . No flashback is possible to bring back the ITEM table.
B . The ORDER table is dropped along with the ITEM table.
C . The dependent referential integrity constraints in the ORDER table are disabled.
D . The dependent referential integrity constraints in the ORDER table are removed.
E . The table definition of the ITEM table and associated indexes are placed in the recycle bin.
-
You execute the following command toauditdatabase activities： SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
A . Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
B . Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
C . One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E . One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
-
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
-
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command： GRANT ALL ON orders， order_items TO PUBLIC； What correction needs to be done to the above statement？ （）
A . PUBLIC should be replaced with specific usernames.
B . ALL should be replaced with a list of specific privileges.
C . WITH GRANT OPTION should be added to the statement.
D . Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
-
The DBA issues this SQL command:
https://assets.asklib.com/images/image2/2018080117142684706.jpg
What privileges does the user Scott have at this point?（）
A . No privileges.
B . Only the SELECT privilege.
C . Only the CONNECT privilege.
D . All the privileges of a default user.
-
You issue the following code： EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP （’SCOTT’ ’GRP1’， TRUE）； What will be the result of executing the above code？（）
A . The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
B . The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
C . The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
D . The code will execute successfully but no privilege will be granted to the user， Scott.
-
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）
A . No privileges.
B . Only the SELECT privilege.
C . Only the CONNECT privilege.
D . All the privileges of a default user.
-
What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）
A . The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are already in the Recycle Bin are dropped.
B . The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.
C . The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.
D . The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.
-
In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；
A . when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago
B . when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago
C . when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago
D . when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes
E . never， because FLASHBACK TABLE is not a valid command in Oracle 10g.
-
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）
A . INDEXES
B . SKIP_INDEXES_MAINTENANCE
C . SKIP_UNUSABLE_INDEXES
D . RESUMABLE
E . INDEXES_UNUSABLE
-
While troubleshooting some connectivity issues， you issue the "show ip ospf database" in order toexamine the link state database. Which three of the statements below are true regarding theOSPF link state database？（）
A . Each router has an identical link state database
B . External routes are imported into a separate link state database
C . Synchronization of link state databases is maintained via flooding of LSAs
D . Information in the link state database is used to build a routing table by calculating a shortest-path tree
E . By default， link state databases are refreshed every 10 minutes in the absence of topologychange
-
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 execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
A . One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
C . One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E . One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
-
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（）
A . No flashback is possible to bring back the ITEM table.
B . The ORDERS table is dropped along with the ITEM table.
C . The dependent referential integrity constraints in the ORDERS table are disabled.
D . The dependent referential integrity constraints in the ORDERS table are removed.
E . The table definition of the ITEM table and associated indexes are placed in the recycle bi
-
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
-
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？（）
A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B . One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
-
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)
-
听力原文： The United Nations General Assembly has again called for an end to the United States economic embargo against Cuba. But Washington ignored the demand, insisting the sanctions are a bilateral issue.
Cuba's National Assembly president opened the debate at the United Nations by announcing Havana's new legal campaign against the US embargo. Ricardo Allorcon said his country will Erie a US $ 100 billion law suit against Washington. The case seeks compensation for the enormous suffering inflicted by the 37-year-old economic blockade on the Cuban people. After the debate, the UN General Assembly voted 155 to 2 to demand an end to the sanctions for the eighth straight year. Only the US and Israel opposed the resolution. Washington's key allies, Japan, Canada and the European Union supported the calls for the lifting of the blockade. Washington has ignored the non-binding UN resolutions, insisting its embargo is a bilateral trade policy towards Cuba.
In Bogota, Columbia, today, a mass of car bomb, packed with shrapnel, exploded on a busy street. Eight people are dead, forty-five others injured. Police believe that drug lords put the bomb there, angry that the government is sending suspected narcotics traffickers to the United States for trial.
Questions:
6.What is the American government referred to as in the news？
7.How much does Cuba ask for from America as compensation in this law suit？
8.Why does America ignore the UN's resolution？
9.How many people were killed and injured in the car bomb in Bogota, Columbia？
10.What is the suspected reason for the accident according to the police？
(26)
A．U.S. government.
B．Washington.
C．National Assembly.
D．General Assembly.
-
The treasury issued an order stating that______land purchased from the government had to be paid for in gold and silver.
A．moreover
B．henceforth
C．whereby
D．however
