Current Affair Quiz Questions
|
|
| Q1- The stored procedure in database which automatically invoked whenever a special event in the database occurs known as ____________. |
| A) Preprocedure | B) Views |
| C) Trigger | D) Schema |
| Ans:- Trigger |
|
| Q2- An artificial key which aims to uniquely identify each record is called. |
| A) Surrogate key | B) Normal key |
| C) Composite key | D) Alternate key |
| Ans:- Surrogate key |
|
| Q3- Which entity set that does not contain sufficient attributes to form its primary key? |
| A) Strong entity set | B) Weak entity set |
| C) Both a and b | D) None of these |
| Ans:- Weak entity set |
|
| Q4- Periodically adding, changing and deleting file records is called file. |
| A) Updating | B) Formatting |
| C) Restructuring | D) Renewing |
| Ans:- Updating |
|
| Q5- Which of the following is not a logical data-base structure? |
| A) tree | B) relational |
| C) network | D) chain |
| Ans:- chain |
|
| Q6- In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction? |
| A) ZIP | B) SAVE |
| C) COMMIT | D) None of these |
| Ans:- COMMIT |
|
| Q7- Which type of database has key concept of the system is edge or relationship? |
| A) Distributed Database | B) NoSQL Database |
| C) Graph Database | D) Cloud Database |
| Ans:- Graph Database |
|
| Q8- Which SQL condition used to dispaly Names that starts with "a" and ends with "o"? |
| A) LIKE 'a%o' | B) LIKE 'o%a_' |
| C) LIKE 'ao%' | D) LIKE 'a_o%' |
| Ans:- LIKE 'a%o' |
|
| Q9- Which command used to copy one table into a new table in SQL ? |
| A) TRAVERSAL*INTO | B) COPY *INTO |
| C) SELECT *INTO | D) None of these |
| Ans:- SELECT *INTO |
|
| Q10- Which database software doesn't support comments? |
| A) Microsoft Access | B) Microsoft's SQL Server |
| C) Oracle | D) All of them |
| Ans:- Microsoft Access |
|
