MySQL interview questions part 31
MySQL interview questions part 31
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. The three language components of a database management system (DBMS) like DDL, DCL, DML. Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?
Correct Answer is : STRAIGHT_JOIN
2. How can a SQL developer add a key on a table?
Correct Answer is : INT/BIGINT
3. A _______________ key is a minimal super key
Correct Answer is : 2
4. Which of the following is not a Key in SQL Server?
Correct Answer is : same
5. What is true about Unique and primary key?
Correct Answer is : optimizer_prune_level
6. By default, which key creates Clustered index?
Correct Answer is : optimizer_search_depth
7. A Key which is a set of one or more columns that can identify a record uniquely is called?
Correct Answer is : TRUE
8. Which key accepts multiple NULL values?
Correct Answer is : LIKE
9. A Foreign key is combined with a foreign key creates
Correct Answer is : LIKE
10. Which of the following statements is not correct?
Correct Answer is : suffixed with ‘name’
11. In a database, a foreign key is ?
Correct Answer is : suffixed with ‘name’
12. Oracle server configuration is dedicated for
Correct Answer is : information_schema
13. What SYSTEM VARIABLE is used to refer DATABASE TIME ?
Correct Answer is : information_schema
14. You notice that the database instance takes a long time to start up after the instance crash. How will you resolve the problem?
Correct Answer is : storage engine
15. Which statement is correct regarding undo management?
Correct Answer is : storage engine
16. Which operations can be performed using the Data Recovery Ad-visor?
Correct Answer is : Student
17. A user receives the following error while executing a query: ORA-01555: snapshot too old Predict one way to avoid such errors in near future.
Correct Answer is : Student
18. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.
Correct Answer is : table name
19. While the database instance is up and running, you receive an out-of-memory error due to the under-sizing of the shared pool. You checked the trace file and observed that the following error was always recorded during peak hours: ORA-04031: unable to allocate 4000 bytes of shared memory On investigation, you found that SGA_MAX_SIZE was larger than the sum of the sizes of all System Global Area (SGA) components and you do not have the scope to increase it further. Identify a solution to reduce the probability of getting this error in future.
Correct Answer is : table name
20. You created a new user on the database by executing the following command: SQL> CREATE USER user01 IDENTIFIED BY user01 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; Then you granted the following privileges to user01 by executing the following command: SQL> GRANT CREATE SESSION, CREATE TABLE TO user01; Which of the following is true in this scenario?
Correct Answer is : DIV
