Which of the following are not options of the mysqldump program?
a. |
--databases |
|
b. |
--flush-logs |
|
c. |
--routines |
|
d. |
--stop-datetime |
Which program can you use to create a full backup for a database?
a. |
mysqlcheck |
|
b. |
mysqlbinlog |
|
c. |
mysqldump |
|
d. |
mysql |
Which program can you use to create and populate a database from a full backup file?
a. |
mysql |
|
b. |
mysqlcheck |
|
c. |
mysqldump |
|
d. |
mysqlbinlog |
Which program can you use to execute the statements that contain the changes that were made after the last full backup?
a. |
mysql |
|
b. |
mysqlcheck |
|
c. |
mysqlbinlog |
|
d. |
mysqldump |
Why do generated backup scripts usually include backticks around names such as database names and column names?
a. |
To identify the names as comments. |
|
b. |
To allow for names that include spaces. |
|
c. |
To indicate that names are specific to MySQL. |
|
d. |
Because backticks are required for all names. |
Answer 1) correct answer
d)--stop-datetime
option d) --stop-datetime is correct answer. there
is no such option of mysqldump function.
explanation->
option a)--databases is used to interpret all the name argument as
the names of databases.
option b)--flush-logs is used for flushing the MySQL server log
files(flushing before us start the dump).
option c)--routines are used for dumping the stored routines from
the dumped database. Routines consist of stored functions and
procedures.
---------------------
Answer 2) correct answer c)mysqldump
option c) mysqldump is the program that is used to
create fill backup of the database. With the help of mysqldump, we
can backup all kinds of database tables
explanation->
option a)mysqlcheck is a function used for performing maintenance
tasks like checking of tables, repairing, optimizes, or analyze
tables.
option b)mysqlbinlog is used for processing binary files. it is
used to display the log files written in binary format into the
text format.
option d)mysql is the command used for executing SQL statements one
by one or in batch file mode.
-----------------------
Answer 3)correct answer c)mysqldump
option c)mysqldump -The dump is a collection of SQL statements to create the table, populate it, or both.
explanation->
option a)mysql is the command used for executing SQL statements one
by one or in batch file mode.
option )mysqlcheck is a function used for performing maintenance
tasks like checking of tables, repairing, optimizes, or analyze
tables.
option d)mysqlbinlog is used for processing binary files. it is
used to display the log files written in binary format into the
text format.
-----------------------
Answer 4)correct answer a)mysql
option a)mysql is the command/program used for executing SQL
statements one by one or in batch file mode.
explanation->
option b)mysqlcheck is a function used for performing maintenance
tasks like checking of tables, repairing, optimizes, or analyze
tables.
option c)mysqlbinlog is used for processing binary files. it is
used to display the log files written in binary format into the
text format.
option d) mysqldump is the program that is used to create fill
backup of the database. With the help of mysqldump, we can backup
all kinds of database tables. The dump is a collection
of SQL statements to create the table, populate it, or
both.
Which of the following are not options of the mysqldump program? a. --databases b. --flush-logs c....
Q.5] Answer the following questions based on the company database (based on the homework assignment 2) y database (based on the homework assignment 2) 3 IPage 1. For each department whose average employee salary is more than $30,000, write a SQL statement to retrieve the department name and the number of employees working for that department 2. Write a SQL statement to retrieve first name, last name, and address of each employee who lives in Houston, TX. 3. Write a...
6. Consider the following program: #include <stdio.h> main() { int a,b,c,d ; a=0; while (1) { printf("%d\n", a); printf("Input? "); scanf("%d",&c); if (c == 0) break; d=0; for (b=1; b<=c; b++) if (c%b == 0) d++; if (d == 2 11 C == 1) a=a+c; } } What does this program do? Rewrite the code, organizing it using sound principles. Include comments and redo variable names and indentation. Use multiple functions, blocks, and/or preprocessing if you deem it necessary.
Please highlight was is needed. I have completed # 2, 6, and I
beleive 7.
Everything related to show 7 needs to be highlighted purple
which was everything with capital letters needs to be highlighted
purple which I have done. The yellow highlight shows all the empty
lines which are highlighted already as well. If I could get the
rest done that would be great.
1. All SQL scripts should be written to execute in a SQL Server 2016 database....
Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently managed in order to make the data accessible. Companies rely on database engineers to ensure that their records are accurate, updated, and tracked in real time. This course covers structured query language (SQL) and how it can be used to manage database schemas, manipulate data, and analyze data. For your final...
Write a C++ program that will deliver a multiple choice quiz. The program should Read questions from the file questions.txt Read the answer key for each test question from the file answers.txt When the program runs it will present each question and obtain a response After all questions have been answered, the program should output a report with the question number, the response given and either “correct” or “incorrect”. Show the output on the console and store the report in...
Create a working proof of concept of one of the following applications which meets all of the minimum requirements. The application may be written in any programming language(s). The application should be sent with the following: ● All of the source code required for building ● A completed binary of the application (if applicable) ● Any required database files (if applicable) Each application requires a README. Please ensure the README includes the following components: ● Which application you choose to...
//I NEED THE PROGRAM IN C LANGUAGE!// QUESTION: I need you to write a program which manipulates text from an input file using the string library. Your program will accept command line arguments for the input and output file names as well as a list of blacklisted words. There are two major features in this programming: 1. Given an input file with text and a list of words, find and replace every use of these blacklisted words with the string...
I have homework that asks to create C++ program to include: 1A) Create and populate a parallel-array Data Structure using the following code: //Student grade records are stored in a parallel-array Data Structure. //Here is the code to generate and populate //the Parallel-Array Data Structure: const int NG = 4; //Number of Grades string names[] = {"Amy Adams", "Bob Barr", "Carla Carr", "Dan Dobbs", "Elena Evans" }; int assessment[][NG]= { {98,87,93,88}, {78,86,82,91}, {66,71,85,94}, {72,63,77,69}, {91,83,76,60} }; 1B) Define a...
1) The advantage(s) of creating indexes in the database
is/are
2) Which of the following statements is true?
3) Which of the following statements is true?
4) Identify the correct statement(s) about Columns and Column
Families of a Column Oriented database
5) You are designing a web application. You have a requirement
to provide a facility to the user to store his/her preferences on
the look-and-feel of the web pages of your application. According
to Fowler and Sadalage, which of...
CREATE TABLE DEPT (
DEPTNO INTEGER NOT NULL,
DNAME VARCHAR(14),
LOC VARCHAR(13),
PRIMARY KEY (DEPTNO));
INSERT INTO DEPT VALUES (10,'SPORTS','NEW YORK');
INSERT INTO DEPT VALUES (20,'HOME','DALLAS');
INSERT INTO DEPT VALUES (30,'OUTDOOR','CHICAGO');
INSERT INTO DEPT VALUES (40,'CLOTHING','BOSTON');
CREATE TABLE EMP (
EMPNO INTEGER NOT NULL,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR INTEGER,
SAL FLOAT,
COMM FLOAT,
DEPTNO INTEGER NOT NULL,
FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
FOREIGN KEY (MGR) REFERENCES EMP(EMPNO),
PRIMARY KEY (EMPNO));
INSERT INTO EMP VALUES (7839,'KING','PRESIDENT',NULL,
5000,NULL,10);
INSERT INTO...