please answer these MYSQL questions for me and please take y

please answer these MYSQL questions for me and please take your time to answer them correctly . Thanks

Multiple choice Questions 2 points for each corect answer l. Oracle 11g is an example of a(n) A. hierarchical model relational data model D. XMLI d data model B, file system data model 2. Suppose you have a column in which most records are going to be between 30 and 32 characters. Which of the following column types in MySQL would be most efficient? A. VARCHAR B. CHAR Either VARCHAR or CHAR 3. Which is the default order of sort in ORDER BY clause in MySQL? A. Ascending 4. Analyzing the company situation is part of the phase of the Database Life Cycle B. Descending al study database B, database design C. implementation and loading, testing, and evaluation operation 5. The \"USE\" keywi in MySQL Database Application is used to select a ord A. Tab B, Column C. Database 6. D. All of above and its attributes are dependent on the A table that has a key attributes defined, has no repeating groups, a primary key, is said to be in C, 3NF D. 4NF B. 2NF 7. The SOL command that lets you permanently save data changes is C, COMM NSERT D. UPDATE. B. SELECT 8. The SQL command clause in MySQL that modifies an attribute\'s values in one or more table\'s rows is C. INSERT A. ALTER D. UPDATE B, SELECT

Solution

1. answer is optin a. hierarchical model(

2. (a) VARCHAR

3.(A)Ascending

4.(a)database initial study

5.(c)USE keyword is used to select database in mysqol or sql server

6.(a)1nf (FIRST NORMAL FORM-in this value are independent and they cannot be divided into other)

7.(b) COMMIT (THIS perfoms the current transactions and make permanent chnges in all the commands)

8.(a) ALTER

9.(D)

10.(d) all rows are deleted (if we will not apply where condition,then it willl delet the complete recod permanents from the table.

11.(a)

12.(c)DROP TABLE (It delets a table permanently and the data lost canot be recovered once deleted by usin drop table)

13.(b)

14.(a)

15.(c) relational database model

16.(d)

17.(b) networks

18.(a)

19.(a)DBMS

20.(a)defining the object ( here mainly overall analysis of the situation is done and all problems and situations are defined)

21.(

22.(a) two approache( for database design mainly two approaches are followed bottom up and the top down approach

23.(b)

24.(d)collection of queries

25.(c)workgroup database

26.(d)

27.(a)