多选题Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）AThe constraint remains vali

题目

多选题

Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

The constraint remains valid.

The index on the constraint is dropped.

It allows the loading of data into the table using SQL *Loader.

New data conforms to the constraint， but existing data is not checked.

It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?()

A. The execution of the script fails because multiple channels cannot coexist.

B. The script is executed and both the channels are used for the script execution.

C. The new channel, CHI, is Ignored because a channel has been configured already.

D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.

参考答案：D

第2题：

Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?()

A. The SELECT statement is syntactically accurate.

B. The SELECT statement does not work because there is no HAVING clause.

C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

参考答案：A

第3题：

View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outcome of the above command?（）

A. The index is not used by the optimizer but is maintained during DML operations.

B. The index is not used by the optimizer and is not maintained during DML operations.

C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.

D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

参考答案：A

第4题：

Which of the following is correct regarding full-state backups?（）

A、used for either a single or dual UCS catastrophic failure
B、can be restored with no special requirements
C、stored as gzipped tarball
D、easy to modify as needed

正确答案:C

第5题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第6题：

Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources

参考答案：C, D

第7题：

Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?（）

A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.

B. The statement returns an error at the SELECT clause.

C. The statement returns an error at the WHERE clause.

D. The statement returns an error at the ORDER BY clause.

参考答案：C

第8题：

Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

参考答案：D

第9题：

You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.

You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do?

A．Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed

B．Use the sp_who stored procedure to discover who is logged in as spid 52

C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52

D．Use System Monitor to log the locks that are granted in the database

正确答案：A
解析：Explanation: The current activity window in SQL Server Enterprise Manager can be used to perform. ad hoc monitoring of an instance of SQL Server. This allows for the quick analysis of the volume and general types of activity on the system and can indicate current blocked and blocking transactions, currently connected users on an instance of SQL Server and the last statement executed and locks that are in effect on the database.

In the screen shot of current activity window the icon, labeled spid 51, indicates that a database lock is in place; the second icon, labeled spid 52, can be used to identify the process that is blocking one or more connections; and the third icon, labeled spid 53, can be used to identify the process that is being blocked by another connection

Incorrect Answers:
B: The system stored procedure sp_lock can be used to return a result set that contains information about resources that are locked and the sp_who stored procedure provides information about current SQL Server 2000 users and processes. The information returned by the sp_who procedure can be filtered to return only current non-idle processes. This makes it possible to identify which resources are being locked and which processes are responsible for creating those locks. These stored procedures require more resources and more administrative effort than the Current Activity window. It is therefore not the best answer.

C: The SQL profiler is not the best tool to immediately solve the locking problem. It could be used at a later moment if a long-term solution to the problem is required. SQL profiler would require more system resources and might impact normal database activities.

Note: SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of SQL Server. Data pertaining to an event can be captured and saved to a file or SQL Server table to be analyzed at a later date. It can be is used to step through problem queries to find the cause of the problem; to find and diagnose slow-running queries; to capture the series of SQL statements that led to a problem; and to monitor the performance of SQL Server to tune workloads.

D: SQL Server provides objects and counters that can be used by System Monitor in a Windows 2000 or by Performance Monitor in Windows NT 4.0 to monitor the system performance of computers running an instance of SQL Server. However, these counters are used for statistics and alerts and they cannot, in a direct way, be used to track down the cause of the locking problem.

第10题：

You issued the following statement： SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（）

A、 the value of the NLS_LANGUAGE variable
B、 the value of the NLS_TERRITORY variable
C、 the value of the NLS_CURRENCY variable
D、the character encoding scheme used by the client application

正确答案:C

Examine the following statement that is used to modify the p

题目

相似问题和答案

更多相关问题

相关内容