MySQL interview questions part 29
MySQL interview questions part 29
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. There are two sessions currently connected to your database instance. In the first session, the following UPDATE statement is executed: SQL> UPDATE dept SET deptno=80 WHERE dname='SALES'; The UPDATE statement above waits to complete the execution. Investigations reveal the following facts: – The UPDATE statement is waiting to acquire a lock – There is referential integrity constraint between the DEPT and EMP table – Department number 30 represents the SALES department – The EMP table is updated in the second session as follows: SQL> UPDATE emp SET sal=sal*0.17 WHERE deptno=30; Which action would you perform to avoid waiting in the first session ?
Correct Answer is : TIME
2. The Oracle environment of database is called as ___________
Correct Answer is : LINESTRING
3. Which is the smallest unit of storage in an Oracle database?
Correct Answer is : 2
4. Collection of information stored in database at particular instance of time is called as ____________
Correct Answer is : TRUE
5. Oracle database’s design is also called as_____________
Correct Answer is : TRUE
6. What are the valid Oracle database schemas?
Correct Answer is : 32 bit
7. What do the schema objects comprise of?
Correct Answer is : 16 bit
8. Map entities, attributes and relations in Oracle is represented by___________
Correct Answer is : 3.4E+38
9. Modification schema of oracle database in one level without affecting the schema in high level is called as _______
Correct Answer is : ±1.7976931348623157E+308
10. A _______________ is used to logically group data together
Correct Answer is : 3
11. A _____________ is a set of tables physically stored together as one table that shares a common column
Correct Answer is : variable
12. DCL stands for :
Correct Answer is : DOUBLE
13. TCL stands for:
Correct Answer is : 64
14. _________commands in SQL allow controlling access to data within database.
Correct Answer is : 3
15. In an SQL statement, which of the following parts states the conditions for row selection?
Correct Answer is : 65535
16. A transaction completes its execution is said to be
Correct Answer is : TRUE
17. Which of the following keyword is used with Data Control Language (DCL) statements?
Correct Answer is : TRUE
18. DCL Provides Commands To Perform Actions Like _____________
Correct Answer is : .
19. The Database Language That Allows You To Access Or Maintain Data In A Database
Correct Answer is : TRUE
20. A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
Correct Answer is : backticks
