Oracle SQL Level 1 Dumps | Wipro TrendNxt Dumps

0

Oracle SQL Level 1 Dumps | Wipro TrendNxt Dumps

Disclaimer: The primary purpose of providing this solution is to assist and support anyone who are unable to complete these courses due to a technical issue or a lack of expertise. This website's information or data are solely for the purpose of knowledge and education.

Make an effort to understand these solutions and apply them to your Hands-On difficulties. (It is not advisable that copy and paste these solutions).

Topic: Data Types

1. Which of the following is not true regarding LONG values?

 a) A table can contain only one LONG column 

 b) LONG columns can appear in where clauses 

 c) Stored function cannot return a LONG value 

 d) LONG columns cannot be indexed 

Topic: Data Types

2. A table can have column of boolean data type.

 a) TRUE 

 b) FALSE 

Topic: Data Types

3. Oracle Table can have a boolean data type for its column(s)?

 a) TRUE 

 b) FALSE 

Topic: Data Types

4. A long column can store data upto

 a) 2 Megabytes 

 b) 2 Gigabytes 

 c) 2000 bytes 

 d) None of the above 

Topic: Data Types

5.BFILE data type can store upto a maximum of

 a) 1 GB 

 b) 2 GB 

 c) 4 GB 

 d) None of the above 


Topic: Data Types

6. Create table tab_name(col1 long, col2 long); The above statement will create a table tab_name

 a) TRUE 

 b) FALSE  (only one long col can be there)

Topic: Data Types

7. CREATE TABLE table_name(column_name CHAR); What will be the length of the column column_name in the table table_name

 a) 1 (default is 1)

 b) 2 

 c) 10 

 d) 2000 

Topic: Data Types

8. Which all are DATETIME data types that can be used when specifying column definitions?

 a) TIMESTAMP 

 b) INTERVAL MONTH TO DAY 

 c) DATE 

 d) A & C 

Topic: Data Types

9. CREATE TABLE table_name(column_name CHAR); 

The above SQL statement will throw an error as length for CHAR data type is not specified

 a) TRUE 

 b) FALSE 

Topic: Data Types

10. Which of the following is not a valid data type in Oracle 10g?

 a) DATE 

 b) TIMESTAMP(3) 

 c) TIMESTAMP(6) 

 d) TIME 

Topic: Data Types

11. What is the maximum length of a CHAR data type

 a) 2000 

 b) 4000 

 c) 8000 

 d) No limit 

Topic: Data Types

12. Assume we want to store patient's image onto the hospital database while creating the patient table which of the following data types should be used for storing image within the database.

 a) CLOB 

 b) BFILE – store a link to an external binary file (file stored outside of the database)

 c) BLOB 

 d) NCLOB 

Topic: Data Types

13. Which of the following is a not Unicode-only datatype?

 a) CHAR 

 b) NCHAR 

 c) NVARCHAR2 

 d) All of the above 

Topic: Data Types

14. How many columns are allowed in Oracle10g table?

 a) 255 

 b) 10000 

 c) 1000 

 d) there is no limit (infinite) 

Topic: Data Types

15. What is the maximum length we can give to VARCHAR2( )?

 a) 2000 

 b) 4000 

 c) 1000 

 d) there is no limit (infinite) 

Topic: Data Types

16. Which data type(s) can hold a null value?

 a) VARCHAR2( ) 

 b) NUMBER( ) 

 c) DATE 

 d) All of the above 

Topic: Data Types

17. Which of the following is a Unicode-only datatype?

 a) Char 

 b) NCHAR 

 c) VARCHAR2 

 d) None 

Topic: Data Types

18. What would be the value stored in database, if 123.89 is stored in a column of datatype NUMBER(6,-2)?

-2 means round to hundreds

 a) 123 

 b) 100 

 c) 120 

 d) 123.9 

Topic: Data Types

19. Which of the following datatype is stored as an external file on the server?

 a) BLOB 

 b) NCLOB 

 c) CLOB 

 d) BFILE 

Topic: Data Types

20. Which of the following SQL functions can operate on any datatype?

 a) MAX 

 b) LOWER 

 c) LPAD 

 d) ADD_MONTHS 

Topic: Data Types

21. Which of the following can be stored in a NUMBER(8,2) datatype?

 a) 999999.99 

 b) 999999.999 

 c) 9999999.99 

 d) 99999.999


*For remaining MCQs, please look on the below given PDF link.

(getButton) #text=(Download PDF Here) #icon=(info) #color=(#1bc517)



**************************************************
Credit for the above notes, goes to the respective owners. 

If you have any queries, please feel free to ask on the comment section.

If you want MCQs and Hands-On solutions for any courses, Please feel free to ask on the comment section too.

Post a Comment

0Comments
Post a Comment (0)

#buttons=(Accept !) #days=(20)

Our website uses cookies to enhance your experience. Learn More
Accept !

Join Telegram Channel

Join MNCAnswers To Get Instant Updates

Join Telegram Channel