Data Triggs Round 1
.
- 1.Who proposed the relational model?
- A.
Herman Hollerith
- B.
Raymond F Boyce
- C.
Charles Babbage
- D.
Edgar F Codd
- 2.Who proposed the relational model?
- A.
Herman Hollerith
- B.
Raymond F Boyce
- C.
Charles Babbage
- D.
Edgar F Codd
- 3.Who proposed the relational model?
- A.
Herman Hollerith
- B.
Raymond F Boyce
- C.
Charles Babbage
- D.
Edgar F Codd
- 4.With SQL, how do you select all the records from a table named "Persons" from the column "FirstName" starting with "a"?
- A.
SELECT * FROM Persons WHERE FirstName='a';
- B.
SELECT * FROM Persons WHERE FirstName LIKE 'a%';
- C.
SELECT * FROM Persons WHERE FirstName LIKE '%a';
- D.
SELECT * FROM Persons WHERE FirstName LIKE'%a'%;
- 5.Which of the following is true regarding NULL?
- A.
NULL=0
- B.
NULL
- C.
NULL>0
- D.
NULL0
- 6.____________ was adopted as a national standard by ANSI in 1992?
- A.
Oracle
- B.
SQL
- C.
DBase
- D.
Microsoft Access
- 7.Which of the following is a group of one or more attributes that uniquely identify a row?
- A.
Key
- B.
Determinant
- C.
Tuple
- D.
Relation
- 8.Which of the following is NOT a unary operation?
- A.
SELECT
- B.
UNION
- C.
RENAME
- D.
PROJECT
- 9.What output will the following query produce?SELECT NVL2(NULL, 'NOT NULL', NULL) FROM DUAL;
- A.
NULL
- B.
NOT NULL
- C.
Function NVL2 is not defined
- D.
None of the Above
- 10.What are ACID properties of transactions?
- A.
Atomicity, Consistency, Isolation, Database
- B.
Atomicity, Consistency, Isolation, Durability
- C.
Atomicity, Concurrency, Inconsistent, Durability
- D.
Atomicity, Concurrency, Isolation, Durability
- 11.The SQL -92 wildcards are __________ and __________.
- A.
Asterisk(*) ; percent sign(%)
- B.
Percent sign(%) ; underscore(_)
- C.
Underscore(_) ; question mark(?)
- D.
Question mark(?) ; asterisk(*)
- 12.Which of the following is considered as DBMS?
- A.
Access
- B.
Oracle
- C.
FoxPro
- D.
All of these
- 13.Which of the following locks the item from change but not from read?
- A.
Implicit Lock
- B.
Explicit Lock
- C.
Exclusive Lock
- D.
Shared Lock
- 14.What is the result of the following query?select case when null = null then 'Yup' else 'Nope' end as Result;
- A.
Yup
- B.
Nope
- C.
Null
- D.
Error
- 15.Which of the following is NOT a DDL statement?
- A.
UPDATE
- B.
ALTER
- C.
CREATE
- D.
RENAME
- 16.Which of the following is an example for network database?
- A.
Unify
- B.
Ingress
- C.
IDMS
- D.
None of the above
- 17.Which of the following query would display names of all the students whose email ids are not provided?
- A.
Select name from students where email = 0;
- B.
Select name from students where email = ' ';
- C.
Select name from students where email is null;
- D.
Select name from students where email = 'null';
- 18.Transactions are initiated by BEGIN TRANSACTION and terminated by:
- A.
COMMIT TRANSACTION
- B.
ROLLBACK TRANSACTION
- C.
Either by COMMIT TRANSACTION or by ROLLBACK TRANSACTION
- D.
NONE
- 19.Which SQL statement is used to extract data from a database?
- A.
FROM
- B.
GET
- C.
CHOOSE
- D.
SELECT
- 20.Mathematically row is referred to as ___________
- A.
Relation
- B.
Attribute
- C.
Tuple
- D.
Domain
- 21.Which statement allows conditional update or insertion of data into a table simultaneously?
- A.
INSERT
- B.
MERGE
- C.
UPDATE
- D.
None of the above
- 22.Which of the following is an SQL query to get third maximum salary of an employee from a table named employee_table?
- A.
SELECT TOP 1 SALARY FROM ( SELECT TOP 3 SALARY FROM employee_table ORDER BY SALARY ASC) AS EMP ORDER BY SALARY DESC;
- B.
SELECT TOP 1 SALARY FROM ( SELECT TOP 3 SALARY FROM employee_table ORDER BY SALARY DESC) AS EMP ORDER BY SALARY ASC;
- C.
SELECT TOP 3 SALARY FROM ( SELECT TOP 1 SALARY FROM employee_table ORDER BY SALARY DESC) AS EMP ORDER BY SALARY ASC;
- D.
SELECT TOP 3 SALARY FROM ( SELECT TOP 1 SALARY FROM employee_table ORDER BY SALARY ASC) AS EMP ORDER BY SALARY DESC;
Questions: 10 | Attempts: 5393 | Last updated: Nov 11, 2020
-
Sample QuestionWhich of the following is NOT a type of transmission media?
Questions: 25 | Attempts: 1658 | Last updated: Apr 8, 2020
-
Sample Question-------- is the most popular open-source Python library used for doing data analysis.
Questions: 20 | Attempts: 120 | Last updated: Dec 26, 2012
-
Sample QuestionThe transmitting station sends one message frame and then waits for an acknowledgment before sending the nextmessage frame.
Back to top