网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
SQL
参考答案
更多 “SQL” 相关考题
考题
Which two are attributes of ／SQL*Plus? ()
A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.You cancel the SQL Server upgrade wizard.You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
考题
下列关于PL／SQL的说法正确的是()
A.PL/SQL是应用于各种数据库上的通用语言B.PL/SQL是过程化的SQL语言C.PL/SQL是只能在SQL*PLUS中运行D.在PL/SQL可以直接执行所有的SQL操作
考题
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A、SQL statements that are part of the AWR baseline only B、SQL statements based on the AWR top SQL identificationC、SQL statements that are part of the available SQL Tuning Set (STS) only D、SQL statements that are available in the cursor cache and executed by a user other than SYS
考题
You are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. To ensure that your queries are functional， you must configure access to the vendors site. What should you do？（）A、Configure an HTTP endpoint for SQL2 on SQL1.B、Configure SQL2 as a linked server on SQL1.C、Configure an HTTP endpoint for SQL1 on SQL2.D、Configure SQL1 as a linked server on SQL2.
考题
Which statement correctly describes SQL and /SQL*Plus?（）A、Both SQL and /SQL*plus allow manipulation of values in the database.B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
考题
Which two statements are true regarding the SQL Repair Advisor？（） A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
考题
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）A、The tuned plan is not added to the SQL plan baseline.B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan.C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
考题
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 advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）A、SQL Repair AdvisorB、SQL OptimizerC、SQL Access AdvisorD、SQL Tuning Advisor
考题
What happens when you run the SQL Tuning Advisor with limited scope？（） A、 Access path analysis is not performed for SQL statements.B、 SQL structure analysis is not performed for SQL statements.C、 SQL Profile recommendations are not generated for SQL statements.D、 Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.
考题
What happens when you run the SQL Tuning Advisor with limited scope?（）A、Access pathanalysis is not performed for SQL statements.B、SQL structure analysis is not performed for SQL statements.C、SQL Profile recommendations are not generated for SQL statements.D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.
考题
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）A、generating the SQL profileB、testing and accepting the SQL profileC、generating a list of candidate SQLs for tuningD、adding tuned SQL plans into the SQL plan baselineE、tuning each SQL statement in the order of importanceF、generating baselines that include candidate SQLs for tuning
考题
Which two statements are true about Shared SQL Area and Private SQL Area（）A、Shared SQL Area will be allocated in the shared pool.B、Shared SQL Area will be allocated when a session starts.C、Shared SQL Area will be allocated in the large pool always.D、Private SQL Area will be allocated in the Program Global Area （PGA） always.E、Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.F、The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
考题
下列关于PL/SQL的说法正确的是（）A、PL/SQL是应用于各种数据库上的通用语言B、PL/SQL是过程化的SQL语言C、PL/SQL是只能在SQL*PLUS中运行D、在PL/SQL可以直接执行所有的SQL操作
考题
You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table. You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification. What should you recommend？（）A、 Use the SQL Azure Data Sync service.B、 Run the SQL Server Agent in SQL Azure.C、 Use SQL Server Integration Services （SSIS） to connect to SQL Azure.D、 Connect the existing on-premise SQL Server Agent jobs to SQL Azure.
考题
单选题Which statement correctly describes SQL and /SQL*Plus?（）A
Both SQL and /SQL*plus allow manipulation of values in the database.B
/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C
/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D
/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
考题
多选题Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）Agenerating the SQL profileBtesting and accepting the SQL profileCgenerating a list of candidate SQLs for tuningDadding tuned SQL plans into the SQL plan baselineEtuning each SQL statement in the order of importanceFgenerating baselines that include candidate SQLs for tuning
热门标签
最新试卷