摘要:
25. choose the best answer Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect 阅读全文
摘要:
24. choose the best answer In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years. Evaluate the fo 阅读全文
摘要:
23.choose the best answer View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the numbe 阅读全文
摘要:
5.choose the best answer Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCA 阅读全文
摘要:
3.choose three View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where the PR 阅读全文
摘要:
20.choose two Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be execute 阅读全文
摘要:
1.choose the best answerWhat is the primary difference between the relational database (RDB) andobject-oriented database (OODB) models?A) RDB allows t 阅读全文
摘要:
18、(8-7) choose twoWhich two statements are true regarding views? (Choose two.) A) A simple view in which column aliases have been used cannot be upda 阅读全文
摘要:
17、(7-11) choose twoView the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.You need to remove from the ORDER_ITEMS table those ro 阅读全文
摘要:
16、(7-5) choose the best answerThe PRODUCTS table has the following structure:Evaluate the following two SQL statements:SQL>SELECT prod_id, NVL2(prod_ 阅读全文