1z0 071

Question no: 2 You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. the STUDENT_GRADES table stores information about the student's

Question no: 1 Evaluate the SQL statement: Truncate table dept; Which three are true about the SQL statement? (Choose three .) A. It releases the storage space used by the table. B. It does not release the storage space used by the table. C. You can

586. Consider the following command: Backup database plus archivelog delete input; How many backup sets wocould be created by this command if the following were true: Control-file auto backups were enabled. The size of backup sets was not restricted.

400. Which of the following methods can be used to detect block upload uption? A. ANALYZE operations B. dbv C. SQL queries that access the potentially encrypted upt block D. RMAN E. All of the above Answer: E Answer: Reference:

ViewThe view is nothing more than Select statement. Note: The view is the same namespace as the table share: It is syntactically correct to use the view name anywhere you can use the table name.1 reasons to use the view( 1 ) with a view that

33.You want to create an ORD_DETAIL table to store details for an order placed having the following business requirement:1) The order ID will be unique and cannot have null values.2) The order date cannot have null values and the default shocould be

21. Examine the description of the EMP_DETAILS table given below:Name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME not null VARCHAR2 (40)EMP_IMAGE LONGWhich two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?

6. Examine the structure of the SHIPMENTS table: Name Null Type PO_ID not null number (3) PO_DATE NOT NULL DATE SHIPMENT_DATE NOT NULL DATE SHIPMENT_MODE VARCHAR2 (30) SHIPMENT_COST NUMBER (8, 2) You want to generate a report that displays the PO_ID

24. Examine the structure proposed for the TRANSACTIONS table:Name Null TypeTRANS_ID not null number (6)CUST_NAME not null VARCHAR2 (20)CUST_STATUS not null VARCHAR2TRANS_DATE NOT NULL DATETRANS_VALIDITY INTERVAL DAY TO SECONDCUST_CREDIT_VALUE

12. You need to produce a report where each customer's credit limit has been incremented by $1000. InThe output, the customer's last name shoshould have the heading Name and the incremented credit limitShocould be labeled New Credit Limit. The

13. View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box's category is ElectronicsEnvoy Ambassador's category is

1 about undoThe database can have more than one undo tablespace;Undo segments can automatically grow, shrink on demand 2 about Oracle Data Dump export and importYou can change the table name during the import operation;You can override an existing

5. Which SQL statements wocould display the value 1890.55 as $1,890.55? (Choose three .) A. Select to_char (1890.55, '$0g000d00 ') From dual; B. Select to_char (1890.55, '$9, 999v99 ') From dual; C. Select to_char (1890.55, '$99,999 d99 ') From dual;

4. Which two statements are true regarding single row functions? (Choose two .) A. They a ccept only a single argument. B. They can be nested only to two levels. C. Arguments can only be column values or constants. D. They a lways return a

1. view the exhibit and examine the structure of the sales, MERS MERs, products, and times tables. The prod_id column is the foreign key in the sales table, which references the Products table. Similarly, the cust_id and time_id columns are also

QUESTION 169 When starting up your ASM instance, you receive the following error: Sql> Startup Pfile=?/dbs/init+asm.ora ASM instance started Total System Global area 104611840 bytes Fixed Size 1298220 bytes Variable Size 78147796 bytes ASM Cache 2516

When you set layout parameters for the view in getview of the adapter, use the following method: Layoutparams Params =NewLayoutparams (layoutparams. fill_parent ,(Int) (Metrics. heightpixels * 0.23f + 0.5f); Convertview. setlayoutparams (Params ); ProgramAn error occurs. 06-08 15:39:43. 071: E/androidruntime (610 ): Java. Lang. classcastexception: Android. View. viewgroup $ layoutparams 06-08 15:39:43. 071