-
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 distinction between competence and performance was proposed by F. de Saussure.
A . 正确
B . 错误
-
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? ()(Choose four.)
A . ALTER DATABASE FLASHBACK ON;
B . GRANT SELECT any transaction TO scott;
C . GRANT EXECUTE ON dbms_flashback TO scott;
D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E . ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema. Which two statements are true regarding the outcome of this action?()
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
Which statement is true regarding the effect of this command on the transaction in Scott’s session()https://assets.asklib.com/images/image2/201808011648102152.jpg
A . The command fails as a transaction is still pending.
B . The transaction in Scott’s session is rolled back and the tablespace becomes read-only.
C . The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
D . The command hangsuntil all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in read-only mode.
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? ()(Choose two)
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?()
A . SELECT*FROMDEPT;
B . SELECT*FROMSCOTT.DEPT;
C . SELECT*FROMDBASCOTTDEPT;
D . SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;
-
You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()
A . You must enable the row movement on the SCOTT.EMP table.
B . You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
C . You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
D . You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
-
Mother was busy. Although she was not watching the basketball on TV, she()it on the radio.
A . was listening to
B . was hearing
C . was listening
-
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
A . ALTER DATABASE FLASHBACK ON;
B . GRANT SELECT any transaction TO scott;
C . GRANT EXECUTE ON dbms_flashback TO scott;
D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E . ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
-
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?()
A . SYS sessions, regardless of the roles that are set in the session
B . SYSTEM sessions, regardless of the roles that are set in the session
C . SCOTT sessions, only if the MGR role is set in the session
D . SCOTT sessions, only if the MGR role is granted to SCOTT
E . SCOTT sessions, because he is the owner of the table
F . SYSTEM session, only if the MGR role is set in the sessio
-
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
A . ALTER DATABASE FLASHBACK ON
B . GRANT SELECT any transaction TO scott
C . GRANT EXECUTE ON dbms_flashback TO scott
D . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
E . ALTER TABLESPACE undots1 RETENTION GUARANTEE
F . ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
-
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()
A . All the related indexes and views are automatically dropped
B . The flashback drop feature can recover only the table structure
C . Only the related indexes are dropped whereas views are invalidated
D . The flashback drop feature can recover both the table structure and its data
-
5 It was very windy on Friday. There was a lot of ____ on Friday.
-
F. Scott Fitzgerald is known as the author of one of his greatest novels The Great Gatsby.
-
Walter Scott was ______.
-
The Romantic Age in the early 19th century English literature was a period of great poetry represented by Wordsworth, Shelley, Walter Scott, etc.
-
F. Scott Fitzgerald wrote the following novels EXCEPT _______.
-
While he achieved limited success in his lifetime, F. Scott Fitzgerald is now widely regarded as one of the greatest American writers of the 20th century.
-
42 The surey was focused on
A the liing conditions of older physicians in the U. S.
B the career plans of older physicians in the U. S.
C the retirement plans of older physicians in the U. S.
D the achieements of older physicians in the U. S.
-
F. Scott Fitzgerald is often acclaimed as the literary spokesman of the___ Age.
-
---Who was on duty yesterday?---().
A.I was
B.I were
C.I am
D.I have been
-
The Fitzgeralds lived so extravagantly that they frequently spent more money than Fitzgerald earned for parties, liquor, entertaining their friends and travelling. It was this living style that nicknamed the decade of the 1920s as .
A、The Roaring Twenties
B、The Jazz Age
C、The Dollar Decade
D、all of the above
-
How important for John F. Kennedy was elected as the president of America?
A.It is a vitory of the Democratic Party.
B.It is a celebration of freedom to elect the people’s own president.
C.It symbolized ont only the end of Eisenhower’s presidency but also the beginning of a new presidency.
D.It signified the continuity of the presidency and the changes of some policies pushed forward by John
F.Kennedy.
此题为多项选择题。