please help me with number 1,2,3,4,5,6,7,8,9,10,11,12,13,14
You need to create a table for keeping customer's banking details for the JustLee Books database. One of the columns in the table has the following requirements: . You want a column in the table to store the duration of the credit period The data in the columns should be stored in a format such that it can be easily added and subtracted with date data type without using the conversion functions The maximum period of the credit provision in the application is 30 days The interest has to be calculated for the number of days an individual has taken a credit for Which data type would use for such a column in the table? 1. INTERVAL DAY TO SECOND 2. NUMBER 3. TIMESTAMP 4. DATE Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle? 1. SQL 2. SQL*Plus 3. ASCII 4. Script Which three tasks can be performed using SQL functions built into Oracle Database? A Displaying a date in a non-default format B. Finding the number of characters in an expression C. Substituting a character string in a text expression with a specified string D. Combining more than two columns or expressions into a single column in the output. Choose the best combination of tasks 1. A,B,D 2. B,C,D 3. A,C,D 4. A,B,C Contents of the BOOKS table Oracle SQL Plus File Edit Search Options Help ax ISBN TITLE PUBDATE PUBID COST RETAIL CATEGORY 1859831198 BODYBUILD IN 10 MINUTES A DAY 21-JAN-01 0401140733 REVENGE OF MICKEY 14-DEC-01 4981341716 BUILDING A CAR WITH TOOTHPICKS 18-MAR-02 8843172113 DATABASE IMPLEMENTATION B-JUN-99 3437212490 COOKING WITH MUSHROOMS 28-FEB-00 3957136468 HOLY GRAIL OF ORACLE 31-DEC-01 1915762492 HANDCRANKED COMPUTERS 21-JAN-01 9959789321 E-BUSINESS THE EASY WAY 01-MAR-02 2491748320 PAINLESS CHILD-REARING 17-JUL-00 0299282519 THE WOK WAY TO COOK 11-SEP-00 8117999391 BIG BEAR AND LITTLE DOVE 08-NOV-01 0132149871 HOW TO GET FASTER PIZZA 11-NOV-02 9247381001 HOW TO MANAGE THE MANAGER 09-MAY-99 2147928890 SHORTEST POEMS 01-MAY-01 18.75 14.2 37.8 31.4 12.5 47.25 21.8 37.9 VanNWEWN 30.95 FITNESS 22 FAMILY LIFE 59.95 CHILDRENS 55.95 COMPUTERS 19.95 COOKING 75.95 COMPUTERS 25 COMPUTERS 54.5 COMPUTERS 89.95 FAMILY LIFE 28.75 COOKING 8.95 CHILDRENS 29.95 SELF HELP 31.95 BUSINESS 39.95 LITERATURE 18 19 5.32 17.85 15.4 21.85 Which of the following SQL statements will display the profit generated by each book currently stored in the BOOKS table? 1. SELECT title, retail, cost as Profit FROM books, 2. SELECT title, retail-cost as Profit FROM books; 3. SELECT Profit FROM books; 4. SELECT * FROM books, Which three SQL statements would display the value 1890.55 as $1,890.55? SELECT TO_CHAR(1890.55, 'SOGOOOD00') FROM DUAL; SELECT TO CHAR(1890.55, '99,999V99') FROM DUAL; SELECT TO CHAR(1890.55, '$99,999D99) FROM DUAL: D SELECT TO CHAR(1890.55, '$996999D00') FROM DUAL: SELECT TO CHAR(1890.55, '$996999D99') FROM DUAL: C. Choose the correct combination of statements A,B,C 2. A,C,D 3. A, BE 4. A,D,E Which of the following terms refers to commands that are used to create or modify database tables? 1. data manipulation language (DML) 2. data control language (DCL) 3. data definition language (DDL) 4. data formatting language (DFL) Which keywords are used to complete the deletion of a column previously marked with SET UNUSED? 1. DELETE UNUSED COLUMNS 2. DROP UNUSED COLUMNS 3. UNSET UNUSED COLUMNS 4. DROP SET COLUMNS Which command instructs Oracle to create a new table from existing data? 1. CREATE NEW TABLE 2. CREATE TABLE...FROM 3. CREATE TABLE 4. CREATE TABLEAS Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase the size of the LASTNAME column from 10 to 14? 1. ALTER TABLE customers MODIFY (City VARCHAR2(+8). lastname VARCHAR2(+4)) 2. ALTER TABLE customers MODIFY (city VARCHAR2(20), lastname VARCHAR2(14)): 3. ALTER TABLE customers MODIFY (city (+8). lastname (+4)): 4. ALTER TABLE customers MODIFY (city (20), lastname (14)): 10. Which data dictionary object contains a column named HIDDEN_COLUMN? 1. USER_HIDE_COLS. 2. USER_TABLES. 3. USER_COLUMNS 4. USER_TAB_COLS. In the CUSTOMERS table of the JustLee Books database, the CITY column contains the value 'BOSTON' for the customer Firstname 'William'. Evaluate the following query: SELECT INITCAP (firstname Il lupper(substr(city, -length(city). 2))) FROM customers WHERE firstname = WILLIAM': What would be the outcome? 2. William Bos William Bo William Boston An error message 3 You te the following commands SQL DEFINE onder date 01-APR-2011 SOL SELECT Onde FROM orders WHERE onderde Customer customer number onder date and For which substitution abwe you prompted for the input? 1. None, because no inputs ruired 2. Both substitution variables order_date and customer number 3. Only customer number 4. Only onder date Which of the following keywords must have been included during the creation of a FOREIGN KEY construint to allow a row from the parent table to be deleted, even if it is referenced by a row in the child table? 1. CASCADE 2 AUTO REMOVE 3. ON DELETE CASCADE 4. None of the above INF3707 If a PRIMARY KEY constraint named ORDERTEMS PK, exists for the ORDER ITEM columns of the ORDERITEMS table, which of the following commands will disable the constraint? 1. ALTER TABLE order items DISABLE PRIMARY KEY CONSTRAINT 2 ALTER TABLE orderiters DISABLE CONSTRAINT order temspk 3. ALTER TABLE orderitems REMOVE PRIMARY KEY CONSTRAINT 4 ALTER TABLE orderiems MODIFY PRIMARY KEY CONSTRAINT DISABLE
