SQL Test: Trivia Quiz Questions!

20 Questions | By Rajkumar_2011 | Last updated: Mar 20, 2022 | Total Attempts: 820

Questions

Settings

Create your own Quiz

Questions and Answers

1.

A pointer is
- A.
  
  A keyword used to create variables
- B.
  
  A variable that stores address of an instruction
- C.
  
  A variable that stores address of other variable
- D.
  
  All of the above
2.

A page fault occurs when:
- A.
  
  The page is corrupted by application software
- B.
  
  The page is in main memory
- C.
  
  The page is not in main memory
- D.
  
  One tries to divide a number by 0
3.

The keyword used to transfer control from a function back to the calling function is
- A.
  
  Switch
- B.
  
  Goto
- C.
  
  Go back
- D.
  
  Return
4.

Specify the 2 library functions to allocate memory dynamically?
- A.
  
  Malloc() and memalloc()
- B.
  
  Alloc() and memalloc()
- C.
  
  Malloc() and calloc()
- D.
  
  Memalloc() and faralloc()
5.

System calls are invoked by using:
- A.
  
  Software interrupts
- B.
  
  Polling
- C.
  
  Indirect jump
- D.
  
  A privileged instruction
6.

What is a shell?
- A.
  
  It is a hardware component
- B.
  
  It is a command interpreter
- C.
  
  It is a part in compiler
- D.
  
  It is a tool in CPU scheduling
7.

Unix Operating System is an __________.
- A.
  
  Time Sharing Operating System
- B.
  
  Multi-User Operating System
- C.
  
  Multi-tasking Operating System
- D.
  
  All the Above
8.

Which of the following cannot be checked in a switch-case statement?
- A.
  
  Character
- B.
  
  Integer
- C.
  
  Float
- D.
  
  Enum
9.

The primary job of the operating system of a computer is to ________.
- A.
  
  Command Resources
- B.
  
  Manage Resources
- C.
  
  Provide Utilities
- D.
  
  Be user friendly
10.

Does there any function exist to convert the int or float to a string?
- A.
  
  True
- B.
  
  False
11.

CPU performance is measured through ________.
- A.
  
  Throughput
- B.
  
  MHz
- C.
  
  Flaps
- D.
  
  None of the above
12.

How would you round off a value from 1.66 to 2.0?
- A.
  
  Ceil(1.66)
- B.
  
  Floor(1.66)
- C.
  
  Roundup(1.66)
- D.
  
  Roundto(1.66)
13.

Which one of the following is not a feature of c?
- A.
  
  Structures
- B.
  
  Pointers
- C.
  
  Unions
- D.
  
  Inheritance
14.

Which one among the following is not a storage class?
- A.
  
  Auto
- B.
  
  Extern
- C.
  
  Register
- D.
  
  Global
15.

You can add a row using SQL in a database with which of the following?
- A.
  
  ADD
- B.
  
  CREATE
- C.
  
  INSERT
- D.
  
  MAKE
16.

The command to remove rows from a table 'CUSTOMER' is:
- A.
  
  REMOVE FROM CUSTOMER ...
- B.
  
  DROP FROM CUSTOMER ...
- C.
  
  DELETE FROM CUSTOMER WHERE ...
- D.
  
  UPDATE FROM CUSTOMER ...
17.

The command to eliminate a table from a database is:
- A.
  
  REMOVE TABLE CUSTOMER;
- B.
  
  DROP TABLE CUSTOMER;
- C.
  
  DELETE TABLE CUSTOMER;
- D.
  
  UPDATE TABLE CUSTOMER;
18.

The DROP TABLE statement:
- A.
  
  Deletes the table structure only.
- B.
  
  Deletes the table structure along with the table data.
- C.
  
  Works whether or not referential integrity constraints would be violated.
- D.
  
  It is not an SQL statement.
19.

Which of the following is NOT a type of SQL constraint?
- A.
  
  PRIMARY KEY
- B.
  
  FOREIGN KEY
- C.
  
  ALTERNATE KEY
- D.
  
  UNIQUE
20.

Which one of the following sorts of rows in SQL?
- A.
  
  SORT BY
- B.
  
  ALIGN BY
- C.
  
  ORDER BY
- D.
  
  GROUP BY