The CUSTOMERS table has these columns:
https://assets.asklib.com/images/image2/2018080116181325145.jpg
Which statement finds the rows in the CUSTOMERS table that do not have a postal code?()
A . SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
B . SELECT customer_id, customer_name FROM customers WHERE postal_code = '________';
C . SELECT customer_id, customer_name FROM customers WHERE postal_code IS NULL;
D . SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
E . SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL
-
You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?()
A . SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC
B . SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit
C . SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST
D . SELECT cust_last_name, cust_credit_limit FROM customers ORDER BY cust_last_name, cust_credit_limit NULLSLAST
-
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?()
A . ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
B . ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
C . ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;
D . ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
E . ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
F . ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL
-
One of your customers has deployed a Layer 3 gateway in the untrusted network. Which gateway mode is appropriate for this customer?()
A . Virtual Gateway
B . Real-IP Gateway
C . NAT Gateway
D . Central Gateway
-
One of your customers has deployed a Layer 3 gateway in the untrusted network. Which gateway mode is appropriate for this customer?()
A . Virtual Gateway
B . Real-IP Gateway
C . NAT Gateway
D . Central Gateway
-
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable: SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about the effect of the command()
A . No flashback is possible to bring back the ITEM table.
B . The ORDER table is dropped along with the ITEM table.
C . The dependent referential integrity constraints in the ORDER table are disabled.
D . The dependent referential integrity constraints in the ORDER table are removed.
E . The table definition of the ITEM table and associated indexes are placed in the recycle bin.
-
One of your best customers has limited funding and is interested in the ability to increase a system’s computing power as needed. Which of the following System x server attributes should the Sales Specialist promote?()
A . Ability to hot-plug additional processors on demand
B . Low cost of System x servers makes scaling out an option
C . "Pay as you Grow" scalability of the IBM System x3950 server
D . Integration of System x servers with the existing servers using an interconnect
-
You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?()
A . Design a trigger that verifies that the first names and surnames are not empty strings.
B . Design a check constraint that verifies that the first names and surnames are not empty strings.
C . Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
D . Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
E . Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.
F . Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.
-
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 message
B . 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.
-
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?()
A . A check constraint on the EMPLOYEE table
B . A unique constraint on the EMPLOYEE table WORKDEPT column
C . A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE table
D . A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table
-
Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()
A . Automatic statistics collection is stopped for the CUSTOMERS table.
B . Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
D . Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics.
-
The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?()
A . ALTER TABLE employees monitor index employee_idx_fk;
B . ALTER INDEX employee_idx_fk monitoring on;
C . ALTER TABLE employees monitor all indexes;
D . ALTER INDEX employee_idx_fk monitoring usage;&e
-
The CUSTOMERS table has these columns:
https://assets.asklib.com/images/image2/2018080116294948484.jpg
The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? ()
A . SELECT TOTAL(*) FROM customers;
B . SELECT COUNT(*) FROM customers;
C . SELECT TOTAL(customer_id) FROM customers;
D . SELECT COUNT(customer_id) FROM customers;
E . SELECT COUNT(customers) FROM customers;
F . SELECT TOTAL(customer_name) FROM customer
-
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 . REFERENCES
B . SELECT
C . UPDATE
D . ALTER
-
pany has implemented numerous multilayer switches that utilize FIB tables. Which statement is true about the Forward Information Base (FIB) table?()
A . The FIB is derived from the IP routing table and is optimized for maximum lookup throughput.
B . The FIB table is derived from the Address Resolution Protocol table, and it contains Layer 2 rewrite (MAC) information for the next hop.
C . When the FIB table is full, a wildcard entry redirects traffic to the Layer 3 engine.
D . The FIB lookup is based on the Layer 2 destination MAC address.
E . None of the other alternatives apply
-
The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?()
A . CREATE SYNONYM ord FOR orders; This command is issued by OE
B . CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
C . CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
D . CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator&e
-
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()
A . No flashback is possible to bring back the ITEM table.
B . The ORDERS table is dropped along with the ITEM table.
C . The dependent referential integrity constraints in the ORDERS table are disabled.
D . The dependent referential integrity constraints in the ORDERS table are removed.
E . The table definition of the ITEM table and associated indexes are placed in the recycle bi
-
You executed the following commands:
https://assets.asklib.com/images/image2/201808020910365583.jpg
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()
A . The statistics are stored in the pending statistics table in the data dictionary.
B . The statistics are treated as the current statistics by the optimizer for all sessions.
C . The statistics are treated as the current statistics by the optimizer for the current sessions only.
D . The statistics are temporary and used by the optimizer for all sessions until this session terminates.
-
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 updated
B . null lock on the table containing the row
C . ROW SHARE lock for the row being updated
D . ROW EXCLUSIVE lock for the row being updated
E . shared row-exclusive lock for the row being updated
F . a shareable table lock for the table containing the row
G . exclusive table-level lock for the table containing the row
-
Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?()
A . Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
B . Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
C . Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
D . Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
E . Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
-
Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statementdescribes the effect of the above command()
A . Automatic statistics collection is stopped for the CUSTOMERS table.
B . Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
D . Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistic
-
The firm has identified 60 ___________________ (potentially) customers at home and abroad.
-
The writer wrote the text because he has noticed that good table manners______.
A.are completely forgotten by young people
B.are brought back to people' s attention
C.are used when making professional decisions
D.are difficult to learn and practise
-
You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queri
A.SELECT?cust_last_name,?cust_credit_limit?FROM?customers?ORDER?BY?cust_credit_limit?DESC
B.SELECT?cust_last_name,?cust_credit_limit?FROM?customers?ORDER?BY?cust_credit_limit
C.SELECT?cust_last_name,?cust_credit_limit?FROM?customers?ORDER?BY?cust_credit_limit?NULLS?LAST
D.SELECT?cust_last_name,?cust_credit_limit?FROM?customers?ORDER?BY?cust_last_name,?cust_credit_limit?NULLSLAST
-
Suppose a DMC has the property that for some input assignment P(x)>0,x∈A={0,1,…,k-1},th
Suppose a DMC has the property that for some input assignment P(x)>0,x∈A={0,1,…,k-1},the variance of I(x;y)=0.Prove that the input assignment achieves channel capacity.