1. (TCO 1) According to your text, the collection of data in a database is organ
ID: 3824683 • Letter: 1
Question
1. (TCO 1) According to your text, the collection of data in a database is organized into _____. (Points : 10) tablesfiles
logs
records Question 2.2. (TCO 1) According to your text, in the event of a crash which of the following is of crucial importance? (Points : 10) Backups
Log files
data files
Backup power source Question 3.3. (TCO 3) According to your text, which of the following would be the first administrative task that you perform after installing the MySQL database? (Points : 10) Log in and make sure you can log back on.
Ensure that the server can be accessed only by authorized users.
Create the data dictionary.
Run a query to see what tables were installed. Question 4.4. (TCO 3) Which of the following is stated in your textbook as being a way that MySQL handles out-of-range or otherwise improper values numeric or time data type columns in a table? (Points : 10) Data that is too long is truncated to fit the maximum length of the column.
Values outside the legal range are clipped to the nearest endpoint of the range and the resulting value is stored.
It depends on the values that are listed as legal in the column definition.
An error is raised and the value is not allowed. Question 5.5. (TCO 4) Which of the following commands will by default only show session variable values? (Points : 10) SHOW GLOBAL VARIALBES
SHOW VARIABLES
SHOW SESSION VARIABLES
SHOW LOCAL VARIABLES Question 6.6. (TCO 5) Database owners usually, and rightly, consider database contents to be _____. (Points : 10) public
private
shared
personal Question 7.7. (TCO 5) The auth_info clause in the CREATE USER statement serves what purpose? (Points : 10) Which host is authenticated
How the server is authenticated at login
How the account is authenticated at login
How the database is authenticated at login Question 8.8. (TCO 5) When granting privileges to a user account, which key word defines the account to which the privileges apply? (Points : 10) GRANT
COLUMNS
WHAT
ACCOUNT Question 9.9. (TCO 5) Which of the following user privileges is not considered an object privilege? (Points : 10) ALTER
RELOAD
FILE
GRANT OPTION Question 10.10. (TCO 5) In order for a user to be able to grant its own privileges to another user the original user must have which of the following privileges? (Points : 10) GRANT
ALTER
GRANT OPTION
SUPER 1. (TCO 1) According to your text, the collection of data in a database is organized into _____. (Points : 10) tables
files
logs
records
Explanation / Answer
Sol. Question 1. (TCO 1) : Option 1,2 ,4 is right
beacause database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. Database is the collaction of files (tables ) .file is the collaction of blocks ( pages ) . Block is the collaction of records.
Question 2.2. (TCO 1) : Option 1 is right
Because Backup and recovery procedures protect your database against data loss and reconstruct the data, should loss occur. The reconstructing of data is achieved through media recovery, which refers to the various operations involved in restoring, rolling forward, and rolling back a backup of database files.
Question 6.6. (TCO 5) : Option b is right
Dtabase content should be private so that no there user can see or interact with other personal things. for example Account details of person should remain private so that money can only be transfered by owner only .
Question 9.9. (TCO 5) : Option D is right ( Grant option )
More than 4 questions are not allowed.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.