单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A UDTB TriggerC PackageD Access plan

题目

单选题

Which of the following objects contains control structures that are considered the bound form of SQL statements?（）

UDT

Trigger

Package

Access plan

更多“单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A UDTB TriggerC PackageD Access plan”相关问题

第1题

To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A、It contains only the plan for the SQL statement executed by the user.B、It contains the SQL text executed by the user and the bind variables used with it.C、It contains the plan and statistics associated with the SQL statement executed by the user.D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

点击查看答案
第2题

You execute the following command to change the status of the SALES tablespace： SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

点击查看答案
第3题

Which of the following database objects is considered executable using SQL?（）A、ViewB、TableC、RoutineD、Package

点击查看答案
第4题

Which of the following database objects can be used to raise an error if a table is updated?（）A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint

点击查看答案
第5题

Which of the following are types of routine objects?（）A、Package and functionB、Function and userexitC、Procedure and packageD、Function and procedure

点击查看答案
第6题

Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)A、It contains only SQL profiles generated by SQL Tuning Advisor.B、It stores plans generated by the optimizer using a stored outline.C、It is part of the data dictionary and stored in the SYSAUX tablespace.D、It is part of the data dictionary and stored in the SYSTEM tablespace.E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

点击查看答案
第7题

Which statement is true when you run the SQL Tuning Advisor with limited scope？（）A、Access path analysis is not performed for the SQL statements.B、SQL structure analysis is not performed for the SQL statements.C、SQL Profile recommendations are not generated for the SQL statements.D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

点击查看答案

单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A UDTB TriggerC PackageD Access plan

题目

更多“单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A UDTB TriggerC PackageD Access plan”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容