1.Mysql A relational database
A. True
B. False
2. What are the characteristics of MySQL?
A. Replication
B. Query caching
C. Storage
D. Security
3. What have the option to license MySQL?
A. MySql Open Source License
B. MySql Personal Edition license
C. Commercial License
D. Enterprise Version License
4. Which MySQL 5.0 features the following?
A. Complete Foreign key support
B. Stored System Support
C. Integrated support Report
D. Batch Query Support
5. What MySQL- the storage engine does?
A.HDD
B. InnoDB
C. MyISAM
D. Backup
6. How to set an administrator password?
A.SET administrator @ localhost = password (‘hidden’);
B.SET root @ localhost root password = password (‘hidden’);
C.SET @ localhost root password = password (‘hidden’);
D.SET @ localhost = password (‘hidden’)
;
7. Which the following is true?
A. capable Database backup
B. Capable, Restore, etc.
C. Viewing configuration variables and system status
8. Which use the table to see?
A. View table
B. Show table
C. Display table
9. To see a list of all existing database
A. View
B. Show
C. Display Database
10. How to see the structure of the table?
A. Structure
B. Display students
C. Describe students
D. View Student
11. MySQL saving engines, namely
A.ARCHIVE
B. Index
C.XLS,
D. InnoDB
E. MyISAM.
12. A ___________ relational database stores data, and a data structure used to organize.
A. View
B. Table Methods
C. Report
D. Stored
13. MyISAM table to handle the transaction, which means that you now carry, such as extra overhead required making transactions, you should use these types of transactions for all needs.
A. True
B. False
14. Which command to see a list of storage engines?
A. View engine
B. Show Storage Engine
C. Show
15. How do I convert MyISAM Tables ISAM tables?
A.MODIFY table TABLE_NAME type = MYISAM;
B.ADD table TABLE_NAME type = MYISAM;
C.ALTER table TABLE_NAME type = MYISAM;
16. What VARCHAR type column is the maximum size?
A.255
B.255 byte characters
C.512
D.512 byte characters
17. How benefits systems work?
A. Authentication
B. Grant
C. Revoke
D. Authorization
18. __________ to determine whether a user is allowed to connect to the server.
A. Authentication
B. Authorization
19. Where access to the information stored?
A. MySQL Database
B. User Database
C. Set the database User
20. Which MySQL command to drop a user?
A.DROP;
Jason from user @ localhost
B. Delete;
Jason
C. Delete user @ localhost;
Jason
D.DROP user @ localhost;
21. Which not use the MySQL command to rename users?
a. Add to Jason Gilmore Jason A.CHANGE USER @ localhost @ localhost
b. Who is Jason B.RENAME USER @ localhost;
c. Add to Jason Gilmore Jason C.RENAME USER @ localhost @ localhost
22. What are the key features of MySQL extension?
A. Object-oriented:
b. Client support
c. Embedded
d. Transactional support:
23. Which method do you use to select the MySQL database?
A. mysqli__db (mysqli link, string dbname)
B. mysqli_select_database (mysqli link, string dbname)
C. mysqli__database (mysqli link, string dbname)
D. mysqli_select_db (mysqli link, string dbname)
24. Which function is responsible for the connection is closed?
A. mysqli_Exit (mysqli link)
B. mysqli_close (mysqli link)
C. mysqli_Nothing (mysqli link)
25. What differences between mysqli_fetch_object (mysqli_result result) and mysqli_fetch_array (mysqli_result result)?
A. mysqli_fetch_object.
B. Both similar functions
C. mysqli_fetch_object except that a value is returned instead of an array.
26. Commit methods and false otherwise return true success, even if the transaction does not appear in the database.
A. True
B False
27.A set of SQL statements that are stored in the database, and what is known as a query executed in the name of the call?
A. Stored routine functions
B. Stored
C. Stored table
D. View
28. There are a number of advantages routine Stored
A. Consistency
B. Performance
C. Reference integrity
D. Security
29. MySQL the two procedural variants, which are collectively referred to as the application is stored routine
A. Stored function
B. Trigger
Methods
C. Views
D. Stored
30. Which select, insert, update, and delete commands?
A. Stored function
B. Trigger Methods
C. Views
D. Stored
1) Views are virtual tables.
A true
B) False
2)
SQL Views in the operation (s) can perform.......
A) Select
B) Filter
C) Sort
D) Joined
E) All of the above
3.)
Views can be indexed, and they trigger the default value may be associated with them.
A true
B) False
4.)
You can update a view by using the following syntax:
A)
See Create or update AS VIEW_NAME
Select COLUMN_NAME (s)
From TABLE_NAME
Where conditions
B)
See update or VIEW_NAME REPLACE AS
Select COLUMN_NAME (s)
From TABLE_NAME
Where conditions
C)
See Create or VIEW_NAME REPLACE AS
Select COLUMN_NAME (s)
From TABLE_NAME
Where conditions
5.)
You can delete a scene with orders...........
A) Delete view
B) Remove View
C) By dropping
D) Digg View
6.)
Oracle SQL and any insert, update or view the change are allowed the use of the view that a clear definition of the following constructs:
A) Joined
B) As a function of the total sum, minimum, maximum, etc.
C) set-valued subqueries (any all), or check the existence of (existing)
D) section by section or distinct group
E) All of the above
7)
The following statements scene name, job title and annual salary of the employees working in 20 categories: (Choose the right)
A)
The scene is DEPT20
The Ename | JOB, * 12-year annual salary from EMP
Where DEPTNO = 20;
B)
Watch as the DEPT20
The Ename | JOB, * 12-year annual salary from EMP
Where DEPTNO = 20;
C)
Watch as the DEPT20
The Ename | JOB, * 12-year annual salary from EMP
Where DEPTNO <> 20;
8.)
Again, each time it is accessed in a scene are evaluated.
A true
B) False
9)
............ view the database contains an entry for each data file.
A) v $ datafile
B) vs. $ datfile
C) vs. $ datafiles
D) vs. $ datafile
10)
Each log contains information on ............... team.
A) Versus $ Log
B) vs. $ logfile
C) vs. $ log group
D) vs. $ log group
11)
A relational database is a SQL INSERT statement to add a single table ............... record.
A
B) one or more
C) Only two
D) None of the above
12)
Also, an insert statement, change it, and it is necessary to recover data from another table can be used to directly insert.
A true
B) False
13)
With SQL insert, it is possible to add specific columns of data.
A true
B) False
14)
You can remove columns from a table definition so you can insert operation.
A true
B) False
15)
Select a place to filter the data used can include a statement........... The clause will be inserted.
A) Where
B)
C) In the
D) Both a and c
16)
A copy of the data in the table and select.....
A) Old
B) New
C) Into the system table
D) A and B are both
17)
........ SQL statement can be used to create backup copies of tables.
A) Election
B) Selection
C) Select the Eye
D) that Choose
18)
... The statement of the new table is a primary key in the selection, so you can manually calculate that does not work.
A true
B) False
19)
By default, only a selected one of the row will return to that statement.
A true
B) False
20)
This is what the following query:
"The first name" selects individual E1.
In New Table
From the "employee" E1
A) Query field "Firstname" akin to a new table and place it inside the "NewTable" NAME, including giving back all the names.
B) Query field "Firstname" it "New Table" NAME duplicate and places it on a new table without giving the names of the returns.
C) Query giving it the name of the field "Firstname" akin to a new table and places it inside the names of all returns except "renewable"
D) A and B are both
Answer
1), 2) E, 3), B, 4) c, 5), C, 6) E, 7), B, 8), 9), D, 10)
11) B, 12) a, 13) b, 14), 15), 16), B, 17), D, 18), 19), 20), B
No comments:
Post a Comment