单选题What is true about sequences? （）A Once created, a sequence belongs to a specific schema.B Once created, a sequence is linked to a specific table.C Once created, a sequence is automatically available to all users.D Only the DBA can control which sequenc
题目
Once created, a sequence belongs to a specific schema.
Once created, a sequence is linked to a specific table.
Once created, a sequence is automatically available to all users.
Only the DBA can control which sequence is used by a certain table.
Once created, a sequence is automatically used in all INSERT and UPDATE statements.
相似考题
参考答案和解析
更多“单选题What is true about sequences? （）A Once created, a sequence belongs to a specific schema.B Once created, a sequence is linked to a specific table.C Once created, a sequence is automatically available to all users.D Only the DBA can control which sequenc”相关问题
-
第1题：
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）
- A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
- B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
- C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
- D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
- E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
- F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
正确答案:C,D -
第2题：
Which two statements are true about simple views？（）
- A、Views can be created as read only.
- B、Views are data segments like tables.
- C、Views can be created on the basis of more than one table.
- D、Data manipulation language （DML） operations cannot be performed on views.
正确答案:A,C -
第3题：
What is true about sequences? （）
- A、The start value of the sequence is always 1.
- B、A sequence always increments by 1.
- C、The minimum value of an ascending sequence defaults to 1.
- D、The maximum value of descending sequence defaults to 1.
正确答案:A -
第4题：
Which two statements about creating constraints are true? （）
- A、Constraint names must start with SYS_C
- B、All constraints must be defines at the column level
- C、Constraints can be created after the table is created
- D、Constraints can be created at the same time the table is created
- E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view
正确答案:C,D -
第5题：
Which two statements about creating constraints are true?（）
- A、Constraint names must start with SYS_C
- B、All constraints must be defines at the column level.
- C、Constraints can be created after the table is created.
- D、Constraints can be created at the same time the table is created.
- E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.
正确答案:C,D -
第6题：
多选题Which two statements are true about standard database auditing（）ADDL statements can be audited.
BStatements that refer to stand-alone procedure can be audited.
COperations by the users logged on as SYSDBA cannot be audited.
DOnly one audit record is ever created for a session per audited statement even though it is executedmore than once.
正确答案： A,D解析： 暂无解析 -
第7题：
多选题Which two statements about views are true?（）AA view can be created as read only.
BA view can be created as a join on two or more tables.
CA view cannot have an ORDER BY clause in the SELECT statement.
DA view cannot be created with a GROUP BY clause in the SELECT statement.
EA view must have aliases defined for the column names in the SELECT statement.
正确答案： D,E解析： 暂无解析 -
第8题：
单选题What is true about sequences? （）AOnce created, a sequence belongs to a specific schema.
BOnce created, a sequence is linked to a specific table.
COnce created, a sequence is automatically available to all users.
DOnly the DBA can control which sequence is used by a certain table.
EOnce created, a sequence is automatically used in all INSERT and UPDATE statements.
正确答案： D解析： 暂无解析 -
第9题：
单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）AThe baseline， once created， cannot be removed.
BDisable the baseline metrics in the Database Control Manage Metrics page.
CThe baseline will be automatically removed once the database performance has been optimized.
DDrop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
正确答案： D解析： 暂无解析 -
第10题：
Which two statements about views are true?（）
- A、A view can be created as read only.
- B、A view can be created as a join on two or more tables.
- C、A view cannot have an ORDER BY clause in the SELECT statement.
- D、A view cannot be created with a GROUP BY clause in the SELECT statement.
- E、A view must have aliases defined for the column names in the SELECT statement.
正确答案:A,B -
第11题：
Which two statements about sequences are true? （）
- A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
- B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
- C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
- D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
- E、If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
- F、You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
正确答案:B,C -
第12题：
Which two statements are true about standard database auditing（）
- A、DDL statements can be audited.
- B、Statements that refer to stand-alone procedure can be audited.
- C、Operations by the users logged on as SYSDBA cannot be audited.
- D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.
正确答案:A,B -
第13题：
Which two statements are true with respect to the maintenance window? （）
- A、A DBA can enable or disable an individual task in all maintenance windows.
- B、A DBA cannot change the duration of the maintenance window after it is created.
- C、In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
- D、A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
正确答案:A,D -
第14题：
单选题Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）AIt would be created only if a unique index is manually created first.
BIt would be created and would use an automatically created unique index.
CIt would be created and would use an automatically created nonunique index.
DIt would be created and remains in a disabled state because no index is specified in the command.
正确答案： A解析： 暂无解析 -
第15题：
单选题What is true about sequences?（）AThe start value of the sequence is always 1.
BA sequence always increments by 1.
CThe minimum value of an ascending sequence defaults to 1.
DThe maximum value of descending sequence defaults to 1.
正确答案： A解析： 暂无解析 -
第16题：
多选题Which two statements are true with respect to the maintenance window？（） .AA DBA can enable or disable an individual task in all maintenance windows.
BA DBA cannot change the duration of the maintenance window after it is created.
CIn case of a long maintenance window，all Automated Maintenance Tasks are restarted every four hours.
DA DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
正确答案： B,A解析： 暂无解析 -
第17题：
多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_C
BAll constraints must be defines at the column level.
CConstraints can be created after the table is created.
DConstraints can be created at the same time the table is created.
EInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view.
正确答案： A,E解析： 暂无解析