ORACLE MCQ Test – 2

Que.1. Setting of which parameter can affect the performance of the database?
A.    Initialization parameter
B.    SGA parameter
C.    Memory Parameter
D.    Both a and b

Right Answer: C

Que.2. All of the following can ONLY be used with numeric data types except:
A.    AVG
B.    COUNT
C.    CUM
D.    STDDEV

Right Answer: B

Que.3. What is the difference between Oracle Forms and App Forms?
A.    Oracle forms runs server – side PL/SQL while app forms run client side.
B.    App forms use uses exact positioning while Oracle forms don’t.
C.    Oracle forms run client – side PL/SQL while app forms run server side.
D.    Oracle forms Flash Charts as its integrated charting engine while app forms don’t.

Right Answer: C

Que.4. Which utility is used to find version of any file?
A.    ADIDENT UTILITY   
B.    ADID UTILITY
C.    ADIDENTVER UTILITY
D.    ADIDVER UTILITY

Right Answer: A

Que.5. The IMPORT IGNORE option tells import to ignore “already exists” errors.
A.    IMPORT
B.    IGNORE
C.    Both a and b
D.    Ignore_error

Right Answer: C

Que.6. PFILE is simply a text based file.
A.    False
B.    True

Right Answer: B

Que.7. In which of the files below are parameters stored?
A.    PFILE
B.    SPFILE
C.    PARFILE
D.    Both a and b

Right Answer: D

Que.8. What happens if a tablespace clause is left off of a primary key constraint clause?

A.    This results in the index that is automatically generated being placed in then users default tablespace.
B.    This can cause serious performance problems.
C.    Both a and b
D.    There is no effect.

Right Answer:  C

Que.9. What is iAS Patch used for?
A.    To fix bugs associated with IAS_ORACLE
B.    To fix bugs associated with IAS_ ORACLE_HOME.
C.    To fix bugs associated with ORACLE_HOME
D.    To fix bugs associated with IAS_ORACLE_PATCH

Right Answer: B

Que.10. A database is a collection of logical structures of data, or schema objects.
A.    True
B.    False

Right Answer: B

Que.11. An ALL_DICTIONARY view is used for
A.    Displays all the information accessible to the current user.
B.    Displays all relevant information in the entire database.
C.    Displays all the information from the schema of the current user.
D.    All of above

Right Answer: A

Que.12. Tables in recycle bin can be resolved back into database by using.
A.    Flashback
B.    Flashback Drop
C.    Revoke
D.    Revoke_Table

Right Answer: B

Que.13. Which of the following is the root directly for oracle?
A.    ORACLE_HOME
B.    ORACLE_ROOT
C.    ORACLE_BASE
D.    ORACLE_SERVER

Right Answer: C

Que.14. What do the schema objects comprise of?
A.    Table
B.    Index
C.    Cluster
D.    All choices are correct.

Right Answer: D

Que.15. DBA_DATA_FILES is used for?
A.    Look at all data files.
B.    Look at all the characters of a data file
C.    Both b and d
D.    Look at the size of a data file.

Right Answer: D

Que.16. Which process is an instance made of?
A.    Oracle background processes
B.    Memory processes
C.    Data processes
D.    All of the above.

Right Answer: A

Que.17. Privileges are assigned to users through ______________.
A.    DBA
B.    Role
C.    Table
D.    Dictionary

Right Answer: B

Que.18. What TRUNCATE and DELETE commands does
A.    To retrieve rows in a table
B.    To remove some part of a table
C.    To get rid of all rows in a table.
D.    To recover all the rows deleted in a table.

Right Answer: C

Que.19. When a user process fails, what background process clean up after it?
A.    PCLEAN
B.    PFAIL
C.    PMON
D.    Both a and c

Right Answer: C

Que.20. What is the System Global Area.
A.    Memory area that contains data shared between all database users.
B.    Memory area that contains data shared between selected database users.
C.    Remote Memory area that contains data shared between one database users.
D.    Remote Memory area that contains data shared between all users.

Right Answer: A

HTML MCQ Test – 2

Que.1. Which of the following term describes the art of making dynamic & interactive pages?
A.    DHTML
B.     HTML
C.    XHTML
D.    XML

Right Answer: A

Que.2. <output> element represent?
A.    Authenticate the user
B.     result of a calculation
C.    pre-defines value
D.    none of these

Right Answer: B

Que.3. Attributes consist of a name and a value separated by ________ sign ?
A.    “ ”
B.     ,
C.    =
D.    ;

Right Answer: C

Que.4. Target attribute is used for
A.    opening new document
B.     selecting previous document
C.    deleting frame
D.    none of above

Right Answer: A

Que.5. Which element provides a secure way to authenticate the user?
A.    <keygen>
B.     <datalist>
C.    <output>
D.    <input>

Right Answer: A

Que.6. For defining the possible link break which tag do we have to use HTML5?
A.    <video>
B.     <track>
C.    <summary>
D.    <wbr>

Right answer: D

Que.7. DHTML is the combination of
1)      HTML
2)      javascript
3)      HTML Dom
4)      CSS

A.    1 and 2
B.     3 and 4
C.    All choices are correct
D.    none of these

Right Answer: C

Que.8. <canvas> elements is only a _________ to the graphics.
A.    component
B.     container
C.    attribute
D.    method

Right Answer: B

Que.9. terminate() method in HTML5 is used for ____________.
A.    terminate everything
B.     terminate all method
C.    terminate a web worker
D.    terminate program

Right Answer: C

Que.10. ________ property returns the url of current audio/video.
A.    currentSrc
B.     controls
C.    ended
D.    mediaGroup

Right Answer: A

Que.11. The manifest file is __________.
A.    Text file
B.     HTML file
C.    XML file
D.    java file

Right Answer: A

Que.12. Which file is used by the browser to fetch the appropriate data ?
A.    Text file
B.     HTML file
C.    XML file
D.    manifest file

Right Answer: D

Que.13. Where does web worker(s) script run?
A.    in forground
B.     in background
C.    both a and b
D.    can’t determinte

Right Answer: B

Que.14. _________ Function displays the latitude or Longitude in geoLocation in HTML5.
A.    showLocation()
B.     showPosition()
C.    both a and b
D.    showStatus()

Right Answer: B

Que.15.  Canvas is able to draw the 2D graphics using----------------
A.    XML
B.     HTML
C.    Java script
D.    XHTML

Right Answer: C

Que.16 Which storage object is used for storing the data with no expiry date?
A.    Session storage
B.     local storage
C.    mass storage
D.    stack storage

Right Answer: B

Que.17. Application cache is used for ____________
1)      offline browsing
2)      Speed
3)      Reduced server load

A.    1 and 2
B.     2 and 3
C.    All choices are correct
D.    none of these

Right Answer: C

Que.18. Seamless is a __________ type of attribute.
A.    integer
B.     Char
C.    Boolean
D.    Float

Right Answer: C

Que.19. Height attribute specifies the height of which frame?
A.    iframe
B.     jframe
C.    inline frame
D.    outline frame

Right Answer: C

Que.20. Given statement is true or false: “Web worker script is depends on other script.”
A.    Yes
B.     No

Right Answer: A