The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement?（）A、The results are not sorted.B、The results are sorted numerically.C、The results are sorted alphabetically.D、The results are sorted numerically and then alphabetically.

考题 The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）A. The results are not sorted.B. The results are sorted numerically.C. The results are sorted alphabetically.D. The results are sorted numerically and then alphabetically.

查看答案

考题 What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?() A. It fails with the ORA-665610 Invalid DDL statement on history-tracked messageB. The rows in the table are truncated without being archived.C. The rows in the table are archived, and then truncated.D. The rows in both the table and the archive are truncated.

查看答案

考题 A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A.REFERENCESB.SELECTC.UPDATED.ALTER

查看答案

考题 When an ICMP redirect is received， which of the following options is the most appropriate to conclude？（）A、A routing table has changedB、The IP address has changedC、The system has become a gatewayD、A hacker is posing a threat to the system

查看答案

考题 In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it

查看答案

考题在Products数据库中建立一个新表Authors，表中应该包含name列和每个作者的ID列，下列语法正确的是（）。A、CREATE TABLE AUTHORS ON Prpducts(name varchar(50),IDsmallint)B、ALTER DATABASE products ADD TABLE Authors(name varchar(50),IDsmallint)C、CREATE TABLE Products.Authors(name varchar(50),IDsmallint)D、Create TABLE Products.Authors(name,ID)

查看答案

考题 A customer currently buys HP ProLiant servers and EMC storage. The customer has encountered various problems getting certain servers to work with their storage. Which of the following arguments can the Sales Specialist present to best position IBM？（）A、IBM’s ServerProven program is a reference that assures a customer of compatibility with specific third-party products.B、IBM sells other vendors’ products and will test compatibility with the customer’s products. C、B IBM’s storage division regularly tests their products with other vendors’ server products. D、IBM’s server division regularly tests their products with other vendors’ storage products.

查看答案

考题 A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A、REFERENCESB、SELECTC、UPDATED、ALTER

查看答案

考题 What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）A、It fails with the ORA-665610 Invalid DDL statement on history-tracked messageB、The rows in the table are truncated without being archived.C、The rows in the table are archived, and then truncated.D、The rows in both the table and the archive are truncated.

查看答案

考题 You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?（）A、All data along with the table structure is deleted B、The pending transaction in the session is committed C、All indexes on the table will remain but they are invalidated D、All views and synonyms will remain but they are invalidated E、All data in the table are deleted but the table structure will remain

查看答案

考题 User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）A、null lock on the row being updatedB、null lock on the table containing the rowC、ROW SHARE lock for the row being updatedD、ROW EXCLUSIVE lock for the row being updatedE、shared row-exclusive lock for the row being updatedF、a shareable table lock for the table containing the rowG、exclusive table-level lock for the table containing the row

查看答案

考题 The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）A、 All the related indexes and views are automatically droppedB、 The flashback drop feature can recover only the table structureC、 Only the related indexes are dropped whereas views are invalidatedD、 The flashback drop feature can recover both the table structure and its data

查看答案

考题 The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code， which is the primary key.As part of the archival process， the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products， the company deals with many new products during every quarter. Whichmethod is best suited for this quarterly data transfer（）A、Using the MERGE commandB、Using the SQL*Loader utilityC、Using the correlated UPDATE commandD、Using the INSERT command to perform bulk operation

查看答案

考题 You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A、— quickB、— skip-bufferC、— single-transactionD、— tab

查看答案

考题 You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）A、 Create an INSERT trigger to assign the default value to each item in the table. B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. C、 Create an UPDATE trigger to update the default value for each new item in the table. D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

查看答案

考题多选题User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）Anull lock on the row being updatedBnull lock on the table containing the rowCROW SHARE lock for the row being updatedDROW EXCLUSIVE lock for the row being updatedEshared row-exclusive lock for the row being updatedFa shareable table lock for the table containing the rowGexclusive table-level lock for the table containing the row

查看答案

考题单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code， which is the primary key. As part of the archival process， the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products，the company deals with many new products during every quarter. Which method is best suited for this quarterly data transfer（）A using the MERGE commandB using the SQL*Loader utilityC using the correlated UPDATE commandD using the INSERT command to perform bulk operation

查看答案

考题单选题As a result of sophisticated technologies, this device has several advantages over like products.A traditionalB intelligentC industriousD advanced

查看答案

考题单选题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 recordsB a table name which has 10s of recordsC a table name which has empty recordsD a table name which has 1000s of recordsE never use a table name

查看答案

考题多选题You execute the following PL/SQL:Which two statements are true?（）AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.BFGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.CFGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.DFGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

查看答案

考题多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it

查看答案

考题单选题What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）A It fails with the ORA-665610 Invalid DDL statement on history-tracked messageB The rows in the table are truncated without being archived.C The rows in the table are archived, and then truncated.D The rows in both the table and the archive are truncated.

查看答案

考题多选题You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?（）AAll data along with the table structure is deletedBThe pending transaction in the session is committedCAll indexes on the table will remain but they are invalidatedDAll views and synonyms will remain but they are invalidatedEAll data in the table are deleted but the table structure will remain

查看答案

考题单选题The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）A The results are not sorted.B The results are sorted numerically.C The results are sorted alphabetically.D The results are sorted numerically and then alphabetically.

查看答案

考题单选题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 is named Instance01. Instance01 contains a database which is named SellingHelp. There isthe Products table in the SellingHelp database. Now according to the company requirement, the Products table has to be replicated to the SQL Server instances installed in laptopscomputers. You have to create a Replication topology to perform this. The Products table is updated from Instance01 when the laptops reconnect to the corporate network. The Products table on Instance01 is frequently updated between reconnections. You must make sure that you can implement the Replication topology along with the Subscription type successfully and meanwhile reduce the bandwidth usage to the least. So what action should you perform to achieve this goal?（）A You should implement the Snapshot Replication topology along with a Push Subscription. B You should implement the Merge Replication topology along with a Pull Subscription. C You should implement the Snapshot Replication topology along with a Pull Subscription. D You should implement the Transactional Replication topology along with a Pull Subscription

查看答案

考题单选题How we pack the products has a significant impact _____ the cost of logistics.A ofB onC toD with

查看答案

考题单选题Ms. Ravi has already conducted market research ______ two new products.A aroundB fromC onD near

查看答案

考题单选题It can be inferred from the passage that the minimal basis for a complaint to the international Trade Commission is which of the following?A A foreign competitor has received a subsidy from a foreign government.B A foreign competitor has substantially increased the volume of products shipped to the United States.C A foreign competitor selling products in the United States at less than fair market value.D The company requesting import relief has been injured by the sale of imports in the United States.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：