1. (TCO 1) According to the book, a database system is essentially a high-powere

Question

1. (TCO 1) According to the book, a database system is essentially a high-powered way to manage _____. (Points : 4)

       people
       numbers
       lists of information
       SQL

Question 2.2. (TCO 1) Which of the following is not a valid MySQL program used to communicate with the server? (Points : 4)

       mysqladmin
       mysqlcheck
       mysqlroot
       mysqldump

Question 3.3. (TCO 2) To set up a MySQL account to use for connecting to the server it is necessary to connect to the server as the MySQL _____ user. (Points : 4)

       admin
       root
       general
       DBA

Question 4.4. (TCO 2) Which of the following statements about how MySQL needs to be or can be installed is false? (Points : 4)

       Because MySQL works on a network you do not need to be logged in on the server machine.
       Because MySQL works on a network you need to be logged in on the server machine.
       Because MySQL works on a network you only need to be able to connect a client to the server.
       Because MySQL works on a network you have to have Internet access regardless.

Question 5.5. (TCO 3) Which one of the following scripts is run to initialize the data directory during a MySQL install on a Unix system? (Points : 4)

       mysql_install_db
       mysql_install_dd
       mysql_install_dir
       mysql_install

Question 6.6. (TCO 3) On a Windows server you have two options for starting MySQL. You can start it manually or you can _____. (Points : 4)

       start it from a command line prompt
       start it from a browser window
       start it using a Window service for MySQL
       start it from a shortcut

Question 7.7. (TCO 3) The server maintains several system variables that are involved in various aspects of character set support. Which one of the following is not a character set variable that indicates properties of the server or the current database? (Points : 4)

       character_set_system
       character_set_server
       character_set_client
       character_set_database

Question 8.8. (TCO 3) Which of the following MySQL storage engines does not support spatial values? (Points : 4)

       InnoDB
       MEMORY
       MyISAM
       ARCHIEVE

Question 9.9. (TCO 3) Which of the following MySQL storage engines offers the most flexibility for sequence handling? (Points : 4)

       InnoDB
       MEMORY
       MyISAM
       ARCHIEVE

Question 10.10. (TCO 3) According to your textbook, which one of the following would not be considered a guideline for identifying columns to index? (Points : 4)

       Columns that appear in the WHERE clause
       Columns that appear in the JOIN clause
       Columns that appear in the SELECT statement
       Columns that appear in the ORDER BY or GROUP BY

Question 11.11. (TCO 3) The data type used to define a column and the way it is defined can have a direct impact on how a query runs. Which of the following would not be considered a good practice based on information presented in your textbook? (Points : 4)

       Using an enum or set data type for columns used in numeric operations when the columns have a limited number of values
       Using smaller data types like MEDIUMINT or FLOAT when appropriate
       Always allowing columns to have NULL values
       Using BLOB or TEXT columns to allow data to be packed

Question 12.12. (TCO 3) Which one of the following storage engines treat CHAR and VARCHAR columns the same in fixed-length rows making the choice in data type immaterial? (Points : 4)

       InnoDB
       MyISAM
       MEMORY
       Federated

Question 13.13. (TCO 4) Which of the following is not an option for setting system variables? (Points : 4)

       Setting at server startup
       Setting in an option file
       Setting before server startup
       Setting at runtime

Question 14.14. (TCO 4) The MySQL server provides a number of different storage engines to select from. Which of the storage engines listed below is not available by default? (Points : 4)

       MyISAM
       MEMORY
       CSV
       FEDEERATED

Question 15.15. (TCO 4) To perform the initial setup of the system tablespace, which of the following steps would not be valid? (Points : 4)

       Add the appropriate lines to the options file
       Make sure that all of the component files already exist.
       Make sure that the directories exist for the tablespace component files.
       Start the server.

Question 16.16. (TCO 5) Which one of the following statements is not a valid statement to use in the creation or modification of a USER in MySQL? (Points : 4)

       CREATE
       GRANT
       PROFILE
       REVOKE

Question 17.17. (TCO 5) When granting privileges to a user account, which key word defines the level at which the privileges apply? (Points : 4)

       GRANT
       COLUMNS
       WHAT
       ACCOUNT

Question 18.18. (TCO 5) When granting privileges to a user account, which key word defines the account to which the privileges apply? (Points : 4)

       GRANT
       COLUMNS
       WHAT
       ACCOUNT

Question 19.19. (TCO 5) Which of the following is not a valid level at which a privilege can be applied? (Points : 4)

       Global
       Database
       Group
       Table

Question 20.20. (TCO 5) To enable an account to perform operation on stored routines the DBA would use the ALTER ROUTINE and EXECUTE privileges at which of the following levels? (Points : 4)

       Global
       User
       Group
       Table

1. (TCO 1) According to the book, a database system is essentially a high-powered way to manage _____. (Points : 4)

       people
       numbers
       lists of information
       SQL

Explanation / Answer

1) According to the book, a database system is essentially a high-powered way to manage ---->SQL (structured query language)

2)Which of the following is not a valid MySQL program used to communicate with the server? --->mysqlroot

3)To set up a MySQL account to use for connecting to the server it is necessary to connect to the server as the MySQL _____ user. ----> root

4)Which of the following statements about how MySQL needs to be or can be installed is false?--> Because MySQL works on a network you need to be logged in on the server machine.

5)Which one of the following scripts is run to initialize the data directory during a MySQL install on a Unix system?

--->mysql_install_dir

6)On a Windows server you have two options for starting MySQL. You can start it manually or you can _____. ---> start it from a command line prompt

7)

8)Which of the following MySQL storage engines does not support spatial values?--->InnoDB

9)Which of the following MySQL storage engines offers the most flexibility for sequence handling? --MYISAM

10) According to your textbook, which one of the following would not be considered a guideline for identifying columns to index?---> Columns that appear in the ORDER BY or GROUP BY

11)

12)Which one of the following storage engines treat CHAR and VARCHAR columns the same in fixed-length rows making the choice in data type immaterial?-->MyISAM

13) Which of the following is not an option for setting system variables---> Setting at runtime

14)The MySQL server provides a number of different storage engines to select from. Which of the storage engines listed below is not available by default?--MEMORY

15)To perform the initial setup of the system tablespace, which of the following steps would not be valid?-->Make sure that the directories exist for the tablespace component files.

16)Which one of the following statements is not a valid statement to use in the creation or modification of a USER in MySQL? --->PROFILE

17)When granting privileges to a user account, which key word defines the level at which the privileges apply?

---->GRANT

18)When granting privileges to a user account, which key word defines the level at which the privileges apply?

---->GRANT

19) Which of the following is not a valid level at which a privilege can be applied?--->Group

20)To enable an account to perform operation on stored routines the DBA would use the ALTER ROUTINE and EXECUTE privileges at which of the following levels?--->Global

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.