更多"The ADMIN_EMP table "的相关试题:
[单项选择]The oscillating water column produces power from ______.
A. the turbine that powers the generator
B. the generator that produces electricity
C. the cylinders that drives the turbine
D. the air that escapes from the turbine
[单项选择] You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.（）
A. 3，2，1，4
B. 2，3，4，1
C. 4，1，3，2
D. 3，2，4，1
[单项选择]Which constraint can be defined only at the column level?（）
A. UNIQUE
B. NOT NULL
C. CHECK
D. PRIMARY KEY
E. FOREIGN KEY
[单项选择]Which constraint can be defines only at the column level? （）
A. UNIQUE
B. NOT NULL
C. CHECK
D. PRIMARY KEY
E. FOREIGN KEY
[单项选择]Manipulation of the spinal column, massage, and dietary adjustments ______ used in chiropractic therapy.
A. (the principal methods are
B. (are the principal methods
C. (how are the principal methods
D. (are there the principal methods
[多项选择] 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 session
[单项选择]If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）
A. COL1 will accept NULL values and can be referenced in another table's foreign key specification.
B. COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.
C. COL1 will not accept NULL values and can be referenced in another tables foreign key specification.
D. COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.
[单项选择] You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）
A. MERGE
B. INSERT
C. UPDATE
D. ADD
E. ENTER
F. You cannot enter the phone numbers for the existing employee records.
[单项选择] Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1
A. 1, 2, 3, 3
B. 1, 2, 2, 4
C. 1, 2, 3, 3, 6
D. 1, 2, 2, 5, 6
[填空题]创建计算列时应该使用Column的（）属性。
[单项选择]Anna Douglas' newspaper column ________.
A. is about how to find jobs for old people
B. spreads ideas for youngsters
C. discusses the problems of old people
D. contains mostly funny stories
[单项选择] The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task？（）
A. implementing valuebased auditing by using triggers
B. implementing finegrained auditing with audit condition and event handler
C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D. performing standard database auditing to audit SQL statements with granularity level set to ACCESS
[单项选择]What does the FREQ column show when running the tprof option?（）
A. Total amount of Ticks used by all users
B. Total amount of Ticks used by all processes
C. Total amount of Ticks used by a specific user
D. Total amount of Ticks used by a specific type of process
