InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
To create a table name Customer having fields Cust-name, Cust_address from the table Employee and Customer table should not be populated with any record from Employee table which of the following query will be correct? |
| Answer» | |
| 52. |
Data files are logically grouped together into an oracle logical structure called a |
| Answer» | |
| 53. |
Which of the following queries will correctly show the tables owned by the user? |
| Answer» | |
| 54. |
Exists clause is used for |
| Answer» | |
| 55. |
SQL ______performs a JOIN against equality or matching column(s) values of the associated tables. |
| Answer» | |
| 56. |
Which command will you use to delete entire table from database? |
| Answer» | |
| 57. |
To use the result of certain query repeatedly which clause will you use? |
| Answer» | |
| 58. |
____ column displays the location of row in a database. |
| Answer» | |
| 59. |
Pseudo-column LEVEL can be used in ____statement where ______ is used. |
| Answer» | |
| 60. |
Pseudo-column ________ returns a level of row in a tree-structured query. |
| Answer» | |
| 61. |
What is true about FLOOR(n) function? |
| Answer» | |
| 62. |
If the primary key is not included in the query result , duplicate rows can occur in result set then how you can eliminate the duplicate rows of query result. |
| Answer» | |
| 63. |
Select the non-scalar function from the following |
| Answer» | |
| 64. |
Select the non-aggregate function from the following |
| Answer» | |
| 65. |
To control access to the database which SQL statement/s used |
| Answer» | |
| 66. |
SQL select statement is used to |
| Answer» | |
| 67. |
Suppose your assistant, named Jene has not been previously authorized to add data about new customers into the database, which of the following statement can be used to give her that permission |
| Answer» | |
| 68. |
If you want to add new data in a database which command will you use |
| Answer» | |
| 69. |
Restrictions on Dropping Tablespace |
| Answer» | |
| 70. |
What is the difference between delete and truncate command of SQL? |
| Answer» | |
| 71. |
Which is the correct syntax to retrieve all rows from the table? |
| Answer» | |
| 72. |
SQL was designed with the purpose of managing data held in__ |
| Answer» | |
| 73. |
SQL was initially developed by |
| Answer» | |
| 74. |
SQL stands for |
| Answer» | |
| 75. |
Explain Database partitioning. What is its importance? |
| Answer» | |
| 76. |
What is Table Scan and Index Scan? |
| Answer» | |
| 77. |
What are B-trees? |
| Answer» | |
| 78. |
What do you mean by Cluster and Non cluster Index? |
| Answer» | |
| 79. |
What are the disadvantages of views in a database? |
| Answer» | |
| 80. |
What are the advantages of views in a database? |
| Answer» | |
| 81. |
What is a materialized view? |
| Answer» | |
| 82. |
What is a view? |
| Answer» | |
| 83. |
List the properties of a transaction. |
| Answer» | |
| 84. |
What happens when Shared and Exclusive locks are applied on data item? |
| Answer» | |
| 85. |
Explain the following frequently used terms in Database. |
| Answer» | |
| 86. |
Explain Phantom Deadlock. |
| Answer» | |
| 87. |
Explain a.) Partial key b.) Alternate key c.) Artificial key d.) Compound key e.) Natural key |
| Answer» | |
| 88. |
Explain a. Entity b. Entity Type c. Entity Set |
| Answer» | |
| 89. |
Explain Data Independence & its types. |
| Answer» | |
| 90. |
Differentiate between Extension & Intension. |
| Answer» | |
| 91. |
Differentiate between Delete and Truncate table. |
| Answer» | |
| 92. |
What is Denormalization? |
| Answer» | |
| 93. |
What are the advantages of normalizing a database. |
| Answer» | |
| 94. |
Explain the various types of normalization. |
| Answer» | |
| 95. |
List some advantages of DBMS. |
| Answer» | |
| 96. |
Explain - a.) Storage Manager b.) Buffer Manager c.) Transaction Manager d.) File Manager |
| Answer» | |
| 97. |
Video: Database Interview Questions for Freshers |
| Answer» | |
| 98. |
Define Trigger. |
| Answer» | |
| 99. |
Define stored procedure. |
| Answer» | |
| 100. |
What do you mean by database? |
| Answer» | |