Databases - Upwork

Question: Consider the following select statement and its output: SELECT * FROM table1 ORDER BY column1; Column1 -------- 1 2 2 2 2 2 3 Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2?
A
DELETE FIRST 4 FROM table1 WHERE column1=2

B
DELETE 4 FROM table1 WHERE column1=2

C
DELETE WHERE column1=2 LIMIT 4

D
DELETE FROM table1 WHERE column1=2 LIMIT 3

E
DELETE FROM table1 WHERE column1=2 LEAVING 1

Note: Not available
1. Report
Question: Consider the following queries:
create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade);
Which of the following statements is true?
A
Two tables are created

B
If a row in table foo2, with a foo_id of 2 is deleted, then the row with id = 2 in table foo is automatically deleted

C
Those queries are invalid

D
If a row with id = 2 in table foo is deleted, all rows with foo_id = 2 in table foo2 are deleted

Note: Not available
1. Report
Question: What is NDB?
A
An in-memory storage engine offering high-availability and data-persistence features

B
A filesystem

C
An SQL superset

D
MySQL scripting language

E
None

Note: Not available
1. Report
Question: Which of the following statements are true?
A
Names of databases, tables and columns can be up to 64 characters in length

B
Alias names can be up to 255 characters in length

C
Names of databases, tables and columns can be up to 256 characters in length

D
Alias names can be up to 64 characters in length

Note: Not available
1. Report
Question: Which of the following statements is used to change the structure of a table once it has been created?
A
CHANGE TABLE

B
MODIFY TABLE

C
ALTER TABLE

D
UPDATE TABLE

Note: Not available
1. Report
Question: What does DETERMINISTIC mean in the creation of a function?
A
The function returns no value

B
The function always returns the same value for the same input

C
The function returns the input value

D
None

Note: Not available
1. Report
Question: Which of the following statements grants permission to Peter with password Software?
A
GRANT ALL ON testdb.* TO peter PASSWORD 'Software'

B
GRANT ALL ON testdb.* TO peter IDENTIFIED by 'Software'

C
GRANT ALL OF testdb.* TO peter PASSWORD 'Software'

D
GRANT ALL OF testdb.* TO peter IDENTIFIED by 'Software'

Note: Not available
1. Report
Question: What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;
A
EMPNO, unique value of ENAME and then SALARY are displayed

B
EMPNO, unique value ENAME and unique value of SALARY are displayed

C
DISTINCT is not a valid keyword in SQL

D
No values will be displayed because the statement will return an error

Note: Not available
1. Report
Question: Which of the following is the best way to disable caching for a query?
A
Add the /*!no_query_cache*/ comment to the query.

B
Flush the whole cache with the command: FLUSH QUERY CACHE

C
Reset the query cache with the command: RESET QUERY CACHE

D
Use the SQL_NO_CACHE option in the query.

Note: Not available
1. Report
Question: What is the maximum size of a row in a MyISAM table?
A
No limit

B
OS specific

C
65,534

D
2'147'483'648

E
128

Note: Not available
1. Report

First Prev 2 3 4 5 6 Next Last

Question: Consider the following select statement and its output: SELECT * FROM table1 ORDER BY column1; Column1 -------- 1 2 2 2 2 2 3 Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2?

Question: Consider the following queries:
create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade);
Which of the following statements is true?

Question: What is NDB?

Question: Which of the following statements are true?

Question: Which of the following statements is used to change the structure of a table once it has been created?

Question: What does DETERMINISTIC mean in the creation of a function?

Question: Which of the following statements grants permission to Peter with password Software?

Question: What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;

Question: Which of the following is the best way to disable caching for a query?

Question: What is the maximum size of a row in a MyISAM table?

Question: Consider the following select statement and its output: SELECT * FROM table1 ORDER BY column1; Column1 -------- 1 2 2 2 2 2 3 Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2?

Question: Consider the following queries:create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade); Which of the following statements is true?

Question: What is NDB?

Question: Which of the following statements are true?

Question: Which of the following statements is used to change the structure of a table once it has been created?

Question: What does DETERMINISTIC mean in the creation of a function?

Question: Which of the following statements grants permission to Peter with password Software?

Question: What will happen if you query the emp table as shown below: select empno, DISTINCT ename, Salary from emp;

Question: Which of the following is the best way to disable caching for a query?

Question: What is the maximum size of a row in a MyISAM table?

Question: Consider the following queries:
create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade);
Which of the following statements is true?

Question: What will happen if you query the emp table as shown below:
select empno, DISTINCT ename, Salary from emp;