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)