Asp.Net And SQL Basic 2

25 Questions | By Anishjraveendran | Last updated: Mar 17, 2022 | Total Attempts: 89

Questions

Settings

Create your own Quiz

Those of you studying computer science might be scratching your heads when coming to grips with open source web frameworks like ASP. NET and database programming languages like SQL, but this basic quiz will help show you the ropes regarding the two topics. How much do you know so far?

Questions and Answers

1.

ASP.NET is a _________________________ ?
- A.
  
  Server Side Scripting Technology
- B.
  
  Client Side Scripting Technology
- C.
  
  Programming Language
- D.
  
  Database Programming Language same as SQL.
2.

What is ASP+ ?
- A.
  
  ASP+ is the same as ASP.NET.
- B.
  
  ASP+ is the Next version of ASP.NET
- C.
  
  ASP+ is just an early name used by Microsoft when they developed ASP.NET.
- D.
  
  ASP+ is a programming Language Specially developed for ASP.NET
- E.
  
  (1)&(2)
3.

ASP.NET provides increased performance by ____________________?
- A.
  
  Supporting active variables
- B.
  
  Running CLR
- C.
  
  Running compiled code
- D.
  
  Using IIS Server
4.

Can you allow class to be inherited, but prevent the method from being over-ridden?
- A.
  
  Yes
- B.
  
  No
5.

When do you absolutely have to declare a class as abstract?
- A.
  
  When at least one of the methods in the class is abstract
- B.
  
  When all of the other methods in the class is abstract.
6.

When will the garbage collector run?
- A.
  
  Every 15 minutes
- B.
  
  Once every day at a specific activated time
- C.
  
  When the application is low on memory
- D.
  
  Randomly based on the resource load on the system
7.

Which tool would you use, if you want to see all the methods of a particular class in your application?
- A.
  
  ObjectBrowser
- B.
  
  ObjectExplorer
- C.
  
  ClassBrowser
- D.
  
  ClassExplorer
8.

What tool is used to manage the assemblies in the Global Assembly Cache?
- A.
  
  Gacmgr.exe
- B.
  
  Gacutil.exe
- C.
  
  Gassy.exe
- D.
  
  Gaccahe.exe
9.

System.dll is ?
- A.
  
  Private assembly
- B.
  
  Shared Assembly
- C.
  
  Its Not an assembly
- D.
  
  None
10.

What is CLS?
- A.
  
  Compiler Language System
- B.
  
  Common Language System
- C.
  
  Common Language Specification
- D.
  
  None
11.

What is the Use of Debug and Trace commands?
- A.
  
  To help to monitor
- B.
  
  To detect Malfunctions
- C.
  
  To Provide Performance Measurement Information
- D.
  
  All of the Above
12.

How could you avoid to receive focus on a particular control while user presses tab key?
- A.
  
  Set TabStop Property to false
- B.
  
  Set TabIndex Property to 1
- C.
  
  Set AcceptTab Property to false
- D.
  
  Using Dock Property
13.

A project on which you are working calls for you to store small amount of frequently changing information about a page on the client.For this project, security is not a worry. Which is the best method to use?
- A.
  
  A cookie
- B.
  
  A query string
- C.
  
  A url
- D.
  
  A javascript function
- E.
  
  A hidden form field
14.

Do I need IIS to develop a Web application in ASP.NET 2.0?
- A.
  
  Yes
- B.
  
  No
15.

What the 1st method that is fired during the page load?
- A.
  
  PreRender()
- B.
  
  Init()
- C.
  
  Load()
- D.
  
  Unload()
16.

What data types do the RangeValidator control support?
- A.
  
  Integer, String, and Date
- B.
  
  Integer, String, and float
- C.
  
  Integer, ushort, and Date
- D.
  
  Decimal, String, and Date
- E.
  
  Integer, String, and bool
17.

How does ASP.NET store SessionIDs by default?
- A.
  
  In cache
- B.
  
  In cookies
- C.
  
  In a global variable
- D.
  
  In URL strings or in a database
18.

Security is very important on any web site. By default, a .Net web site is configured with which of the following authentication types?
- A.
  
  Anonymous
- B.
  
  Basic
- C.
  
  Digest
- D.
  
  Integrated Windows authentication
- E.
  
  Answer 1 & 4
19.

________ removes all rows from a table without logging the individual row deletions.
- A.
  
  Drop
- B.
  
  Delete
- C.
  
  Truncate
- D.
  
  Update
- E.
  
  Alter
20.

When using the SQL INSERT statement:
- A.
  
  Rows can be modified according to criteria only.
- B.
  
  Rows cannot be copied in mass from one table to another only.
- C.
  
  Rows can be inserted into a table only one at a time only.
- D.
  
  Rows can either be inserted into a table one at a time or in groups
21.

The primary key is selected from the
- A.
  
  Composite keys
- B.
  
  Determinants
- C.
  
  Candidate keys
- D.
  
  Foreign keys
22.

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 ...
23.

The SQL WHERE clause:
- A.
  
  Limits the column data that are returned.
- B.
  
  Limits the row data are returned.
- C.
  
  Both A and B are correct.
- D.
  
  Neither A nor B are correct.
24.

A view is which of the following?
- A.
  
  A virtual table that can be accessed via SQL commands
- B.
  
  A virtual table that cannot be accessed via SQL commands
- C.
  
  A base table that can be accessed via SQL commands
- D.
  
  A base table that cannot be accessed via SQL commands
25.

ON UPDATE CASCADE ensures which of the following?
- A.
  
  Normalization
- B.
  
  Data Integrity
- C.
  
  Materialized Views
- D.
  
  All of the above.