单选题What is necessary for your query on an existing view to execute successfully?（）A The underlying tables must have data.B You need SELECT privileges on the view.C The underlying tables must be in the same schema.D You need SELECT privileges only on the u

题目
单选题
What is necessary for your query on an existing view to execute successfully?（）
A

The underlying tables must have data.

B

You need SELECT privileges on the view.

C

The underlying tables must be in the same schema.

D

You need SELECT privileges only on the underlying tables.

相似考题

1.You are granted the CREATE VIEW privilege. What does this allow you to do? ()A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.

2.Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.

3.A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

4.What is necessary for your query on an existing view to execute successfully? ()A. The underlying tables must have data.B. You need SELECT privileges on the view.C. The underlying tables must be in the same schema.D. You need SELECT privileges only on the underlying tables.

更多“What is necessary for your query on an existing view to exec”相关问题

  • 第1题：

    You share your computer with other users. You install a new Microsoft add-on to view videos on the computer. You discover that this add-on conflicts with existing add-ons that other users frequently require.You need to ensure that you are able to view videos without affecting other users.What should you do?（）

    A.A

    B.B

    C.C

    D.D


    参考答案：C

  • 第2题：

    Which of the following statements best describes Flashback Versions Query？（）  

    • A、 Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
    • B、 Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.
    • C、 Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
    • D、 Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.

    正确答案:D

  • 第3题：

    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）

    • A、Use the DESCRIBE command in the EMP_DEPT VU view.
    • B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
    • C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
    • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
    • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
    • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

    正确答案:D

  • 第4题：

    What is necessary for your query on an existing view to execute successfully?（）

    • A、The underlying tables must have data.
    • B、You need SELECT privileges on the view.
    • C、The underlying tables must be in the same schema.
    • D、You need SELECT privileges only on the underlying tables.

    正确答案:B

  • 第5题：

    You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do？（）

    • A、Use the DBCC INPUTBUFFER command.
    • B、Use the sys.dm_exec_query_stats dynamic management view （DMV）.
    • C、Use the sqldiag utility.
    • D、Use the SHOWPLAN session option.

    正确答案:B

  • 第6题：

    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）

    • A、In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.
    • B、In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.
    • C、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.
    • D、In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.

    正确答案:A,C

  • 第7题：

    问答题
    ◆Topic 8: Is education Losing its Value?　　Questions for reference:　　1. Some people think that this increased access to education is devaluing degrees. What’s your point of view?　　2. What can the degrees bring to people?　　3. Do you think it’s necessary to have increased emphasis on degrees in our society? Why?

    正确答案： 【参考答案】
    People have several arguments against the need for degrees. They say that having so many graduates devalues a degree. People lose respect for the degree holder. It is also claimed that education has become a rat race. Graduates have to compete for jobs even after years of studying.
    Another point is that studying for such a long time leads to. learners becoming inflexible. They know a lot about one narrow subject, but are unable to apply their skills. Employers prefer more flexible and adaptable workers.
    However, I feel strongly that this move to having more qualifications is a positive development.
    In the past education was only for the rich and powerful. Now it is available to everyone, and this will have many advantages for the country and the individual. First of all, it is impossible to be overeducated. The more people are educated, the better the world will be, because people will be able to discuss and exchange ideas. A further point is that people with degrees have many more opportunities. They can take a wider variety of jobs and do what they enjoy doing, instead of being forced to take a job they dislike. Finally, a highly educated workforce is good for the economy of the country. It attracts foreign investment.
    In conclusion, although there are undoubtedly some problems with increased levels of education, I feel strongly that the country can only progress if all its people are educated to the maximum of their ability.
    解析： 暂无解析

  • 第8题：

    单选题
    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）
    A

    Execute the query and view Active Session History (ASH) for information about the query.

    B

    Enable SQL trace for the query.

    C

    Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D

    Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.   You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）
    A

    Add an XML index to the table that contains the product data.

    B

    Add the XSINIL argument to the ELEMENTS directive in the query.

    C

    Add a HAVING clause to the query.

    D

    Add the replace value of clause to the query.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）
    A

    The optimizer statistics are collected automatically.

    B

    Only the timed operating system （OS） statistics and plan execution statistics are collected.

    C

    The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

    D

    The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 

    E

    Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    多选题
    TestKing.com uses SQL Server 2005. A user reports that an order processing application stopped responding in the middle of an order transaction. The users SQL Server session ID is 54. You need to find out if session 54 is blocked by another connection. If it is,you need to identify the blocking session ID. What are two possible ways to achieve this goal？（）
    A

    In SQL Server Management Studio， open the Activity Monitor. Open the Process Info page. View the blockedBy column for session 54.

    B

    In SQL Server Management Studio，open the Activity Monitor. Open the Locks by Process page. View the Request Mode column for session 54.

    C

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec requests WHERE session id = 54View the blocking session id column.

    D

    In SQL Server Management Studio， open a new query window and execute the following statement.SELECT * FROM sys.dm exec sessionsWHERE session id = 54View the status column.


    正确答案： C,D
    解析： 暂无解析

  • 第12题：

    单选题
    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
    A

     Query the V$FLASHBACK_DATABASE_LOG view.

    B

     Query the V$FLASHBACK_DATABASE_STAT view.

    C

     Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.

    D

     Query the V$RECOVERY_FILE_DEST view.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    If there were only one question left ,what would it most probably be?

    A.What was your childhood dream?

    B.What is your biggest achievement?

    C.What is your parents view of you?

    D.What was your handest expenrience in the war?


    正确答案：B

  • 第14题：

    You are granted the CREATE VIEW privilege. What does this allow you to do?（）

    • A、Create a table view.
    • B、Create a view in any schema.
    • C、Create a view in your schema.
    • D、Create a sequence view in any schema.
    • E、Create a view that is accessible by everyone.
    • F、Create a view only of it is based on tables that you created.

    正确答案:C

  • 第15题：

    In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting？（）

    • A、The optimizer statistics are collected automatically.
    • B、Only the timed operating system （OS） statistics and plan execution statistics are collected.
    • C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
    • D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
    • E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

    正确答案:D

  • 第16题：

    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

    • A、 Query the V$FLASHBACK_DATABASE_LOG view.
    • B、 Query the V$FLASHBACK_DATABASE_STAT view.
    • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
    • D、 Query the V$RECOVERY_FILE_DEST view.

    正确答案:B

  • 第17题：

    You are the network administrator for your company. The network consists of a single Active Directory domain. All network servers run Windows Server 2003, and all client computers run Windows XP Professional. A user named Peter uses a client computer named Client1. This computer has a locally attached tape device. You grant Peter the necessary permissions to perform backups of a member server named Server1. Peter runs the Backup utility on Client1 to back up the files located on Server1. You need use your client computer to view the most recent backup logs for Server1. What should you do? （）

    • A、Use Notepad to view the contents of the backup report located on Server1.
    • B、Use Notepad to view the contents of the backup report located on Client1.
    • C、Use Event Viewer to view the contents of the application log located on Server1.
    • D、Use Event Viewer to view the contents of the application log located on Client1.

    正确答案:B

  • 第18题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time.  So in the options below, which dynamic management view should you choose to use?（）  

    • A、sys.dm_os_wait_stats 
    • B、sys.dm_exec_requests 
    • C、sys.dm_exec_sessions 
    • D、sys.dm_exec_query_stats

    正确答案:D

  • 第19题：

    单选题
    Which of the following statements best describes Flashback Versions Query？（）
    A

     Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

    B

     Flashback Versions Query is used to view all version changes on rows that existed between the time  the query was executed and a point in time in the past.

    C

     Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

    D

     Flashback Versions Query is used to view all version changes on rows that existed between two  points in time.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    What is necessary for your query on an existing view to execute successfully?（）
    A

    The underlying tables must have data.

    B

    You need SELECT privileges on the view.

    C

    The underlying tables must be in the same schema.

    D

    You need SELECT privileges only on the underlying tables.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You are granted the CREATE VIEW privilege. What does this allow you to do?（）
    A

    Create a table view.

    B

    Create a view in any schema.

    C

    Create a view in your schema.

    D

    Create a sequence view in any schema.

    E

    Create a view that is accessible by everyone.

    F

    Create a view only of it is based on tables that you created.


    正确答案： E
    解析： 暂无解析

  • 第22题：

    单选题
    You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）
    A

    Replace the named query with an SQL view.

    B

    Set the transaction isolation level to serializable in the named query.

    C

    Set the source database to use snapshot isolation.

    D

    Set the transaction isolation level to repeatable read in the named query.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）
    A

    A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

    B

    All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

    C

    A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.

    D

    A TOP-N query is created to limit the rows to 20 percent of the total rows


    正确答案： B
    解析： 暂无解析

相关内容