CREST Olympiads - CCO PDF Sample Papers for Class 10
Class 10 sample paper & practice questions for CREST Cyber Olympiad (CCO) level 1 are given below. Syllabus for level 1 is also mentioned for these exams. You can refer these sample paper & quiz for preparing for the CCO exam.
Q.1 |
Which SQL statement is used to return only different values? |
| a) |
SELECT DISTINCT |
| b) | SELECT UNIQUE |
| c) | SELECT DIFFERENT |
| d) | SELECT UNLIKE |
Q.2 |
With SQL, how do you select all the records from a table named "Students" where the value of the column "FirstName" starts with an "a"? |
| a) |
SELECT * FROM Students WHERE FirstName LIKE '%a' |
| b) | SELECT * FROM Students WHERE FirstName='a' |
| c) | SELECT * FROM Students WHERE FirstName LIKE 'a%' |
| d) | SELECT * FROM Students WHERE FirstName='%a%' |
Q.3 |
1. Drift 2. Freckle 3. Depositor 4. File 5. Depreciate |
| a) |
Depreciate |
| b) | File |
| c) | Depositor |
| d) | Drift |
Q.4 |
Which command is used to undelete a bunch of files withextension .doc that you have just deleted? |
| a) |
Undelete .doc |
| b) | Undelete all .doc |
| c) | Undelete *.doc |
| d) | All of above |
Q.5 |
Choose a figure which would most closely resemble the unfolded form of Figure (Z).  |
| a) |
A |
| b) | B |
| c) | C |
| d) | D |
Q.6 |
Following image shows which device?  |
| a) |
IC |
| b) | Microprocessor |
| c) | Power Transistor |
| d) | System Board |
Q.7 |
What is a program that secretly takes over another Internet-attached computer and then uses that computer to launch attacks? |
| a) |
Worm |
| b) | Zombie |
| c) | Virus |
| d) | Trap doors |
Q.8 |
A portion of the Polymorphic virus, generally called a ___________, creates, a random encryption, key to encrypt the remainder of the virus. |
| a) |
mutual engine |
| b) | mutation engine |
| c) | multiple engine |
| d) | polymorphic engine |
Q.9 |
For which of the following values of n is 100+n/n not an integer? |
| a) |
0 |
| b) | 1 |
| c) | 2 |
| d) | 3 |
Q.10 |
With SQL, how can you return the number of records in the "Students" table? |
| a) |
SELECT NO(*) FROM Students |
| b) | SELECT COLUMNS(*) FROM Students |
| c) | SELECT COUNT(*) FROM Students |
| d) | SELECT LEN(*) FROM Students |
Your Score: 0/10
Sample PDF of CREST Olympiads - CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 10:
If your web browser doesn't have a PDF Plugin, you can Click here to download the PDF
Answers to Sample Questions from Olympiad Success:
Q.1 : a | Q.2 : c | Q.3 : b | Q.4 : c | Q.5 : d | Q.6 : c | Q.7 : b | Q.8 : b | Q.9 : d | Q.10 : c
Other Classes Sample Papers
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 1
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 2
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 3
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 4
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 5
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 6
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 7
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 8
- CREST Cyber Olympiad (CCO) PDF Sample Papers for Class 9
