单选题Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）A USER_TAB_PRIVS_MADEB USER_TAB_PRIVSC USER_COL_PRIVS_MADED USER_COL_PRIVS

题目
单选题
Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）
A

USER_TAB_PRIVS_MADE

B

USER_TAB_PRIVS

C

USER_COL_PRIVS_MADE

D

USER_COL_PRIVS

相似考题

1.Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS

2.Exhibit:UPDATE EzonexamConsolidatedSET District = ‘Mexico’WHERE RtvID = 45You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.When users run the query in the exhibit above the receive the following error message:Server: Mrh3612, Level 16, Stats 1, Line 1View or function ‘EzonexamConsolidated’ is not updateable because itcontains aggregates:How should you enable the query to run?A．Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.B．The appropriate users should be granted UPDATE permissions on each base table.C．To enable updates on the composite tables create an INSTEAD OF trigger on the view.D．On each base table add a cascading update trigger.

3.ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）A、vector B、database view C、database table D、transactional trigger E、PL/SQL table of records F、multi-dimensional array

4.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

参考答案和解析
正确答案： D
解析： 暂无解析
更多“Which data dictionary table should you query to view the obj”相关问题

  • 第1题：

    Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）

    • A、USER_TAB_PRIVS_MADE
    • B、USER_TAB_PRIVS
    • C、USER_COL_PRIVS_MADE
    • D、USER_COL_PRIVS

    正确答案:D

  • 第2题：

    Which version of a view would you use if you just want a quick， easy view within your XPage？（）

    • A、Data Table Control
    • B、View Control
    • C、Repeat Control
    • D、Filter by category View Control

    正确答案:B

  • 第3题：

    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

    • A、 To recover a dropped table.
    • B、 To recover a dropped schema.
    • C、 To recover data from a truncated table.
    • D、 To view changes made by all the transactions during a given period of time.
    • E、 To view changes made by a single transaction during a given period of time.

    正确答案:D,E

  • 第4题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）

    • A、A primary XML index should be created on the XML column.
    • B、Statistics should be created on the nvarchar columns.
    • C、A view should be created， and only the four columns that the query utilizes are contained by a view.
    • D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.

    正确答案:D

  • 第5题：

    单选题
    You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）
    A

    Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.


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

  • 第6题：

    单选题
    Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）
    A

    USER_TAB_PRIVS_MADE

    B

    USER_TAB_PRIVS

    C

    USER_COL_PRIVS_MADE

    D

    USER_COL_PRIVS


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

  • 第7题：

    单选题
    You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）
    A

    a table name which has 100s of records

    B

    a table name which has 10s of records

    C

    a table name which has empty records

    D

    a table name which has 1000s of records

    E

    never use a table name


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

  • 第8题：

    单选题
    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
    A

     creating a table in your schema and you exceed your allocated space quota on the tablespace

    B

     executing a long query that involves a sort operation and the statement runs out of temporary space

    C

     loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

    D

     creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error


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

  • 第9题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


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

  • 第10题：

    单选题
    You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）
    A

    enable index monitoring and query the DBA_OBJECTS view

    B

    enable index monitoring and query the DBA_INDEXES view

    C

    enable index monitoring and query the V$OBJECT_USAGE view

    D

    enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view


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

  • 第11题：

    单选题
    You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）
    A

    Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.

    B

    Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.

    C

    Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.

    D

    Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.


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

  • 第12题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）
    A

     Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.

    B

     Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.

    C

     Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.

    D

     Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.


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

  • 第13题：

    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

  • 第14题：

    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

    • A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
    • B、 executing a long query that involves a sort operation and the statement runs out of temporary space
    • C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
    • D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

    正确答案:D

  • 第15题：

    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

  • 第16题：

    A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）

    • A、 Create a database view to retrieve the data.
    • B、 Use a clustered index on the SQL Azure database tables.
    • C、 Open a new database connection when an operation times out.
    • D、 Create SQL Azure database table indexes basedon application queries

    正确答案:D

  • 第17题：

    多选题
    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
    A

    To recover a dropped table.

    B

    To recover a dropped schema.

    C

    To recover data from a truncated table.

    D

    To view changes made by all the transactions during a given period of time.

    E

    To view changes made by a single transaction during a given period of time.


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

  • 第18题：

    单选题
    You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


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

  • 第19题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）
    A

    A primary XML index should be created on the XML column.

    B

    Statistics should be created on the nvarchar columns.

    C

    A view should be created， and only the four columns that the query utilizes are contained by a view.

    D

    A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.


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

  • 第20题：

    单选题
    You manage a SQL Server 2005 database that contains a table with many indexes.  You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）
    A

    sys.dm fts index population

    B

    sys.dm exec query stats

    C

    sys. dm db index usage stats

    D

    sys.dm db index physical stats


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

  • 第21题：

    单选题
    Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）
    A

    USER_CONSTRAINTS

    B

    USER_OBJECTS

    C

    ALL_CONSTRAINTS

    D

    USER_CONS_COLUMNS

    E

    USER_COLUMNS


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

  • 第22题：

    单选题
    You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）
    A

    V$DATABASE 

    B

    DBA_TABLES 

    C

    SYSAUD$ 

    D

    EMP


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

  • 第23题：

    单选题
    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 created.) How do you obtain the definition of the view?（）
    A

    Use the DESCRIBE command on 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.


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

相关内容