1. The use of DBMS automatically removes redundancies.
2. Relational model requires the use of connectors as ‘links’.
3. In the network model a record can have many parents.
4. Char conserves memory as compared to varchar.
5. A table once created can be dropped.
6.The name of a table can be changed with Alter command.
7. A table can have more than one primary key.
8. The columns on which ORDER BY is done must be a part of <Select Statement>
9. For a valid UNION of two result sets, the column names of the result sets should match.
10. Char datatype stores only characters in the database.
11. The VARCHAR2 datatype comes under standard SQL datatypes
12. The maximum length of VARCHAR2 datatype is identical when used in a PL/SQL code and when used in a
table
13. The ORDER BY clause whenever used should always be the last clause of an SQL query (True)
14. 4 The size of a column in a table cannot be decreased once a value is inserted in it (True)
15. The UNIQUE and FOREIGN keys cannot have NULL values (False)
16. Online Transaction Processing (OLTP) consists of more DML and less DQL statements( True)
17. Decision Support System (DSS) is used to understand the trends of data (True)
18. ROWID is the only pseudo column in any Oracle table (False)
19. Database Manager is the person responsible for proper functioning of a DBMS. (False)
20. A set of privileges assembled together is called a ROLE (True)
21. An Oracle SQL query may or may not have a FROM clause (False)
22. The DATE datatype of Oracle occupies 8 bytes (False)
23. The default value of any datatype in Oracle is “ ” (False)
24. Both an SQL query as well as a PL/SQL code is interpreted in Oracle (False)
25. A SELECT statement cannot be used to lock a table (False)
26. All functions performed by constraints can equally be performed by triggers (True)
27. By default, the trigger is created at ROW level (False)
28. Oracle automatically creates an index on the primary key of a table (True)
29. A single trigger can be used for handling Insert/delete/update on a table (True)
|