Welcome! Guest
New User? Register | Login

Home » Interview Questions » Oracle

Post your Article

Which four statements are true about profiles? (Choose four.)

By: Shailesh Singh Visen | 17 Mar 2008 4:33 am

Q. Which four statements are true about profiles? (Choose four.)

A. Profiles can control the use of passwords.

B. Profile assignments do not affect current sessions.

C. All limits of the DEFAULT profile are initially unlimited.

D. Profiles can be assigned to users and roles, but not other profiles.

E. Profiles can ensure that users log off the database when they have left their session idle for a period of time.

Answer: ABCE

OTN:
After a profile has been created, you can assign it to database users. Each user can be assigned only one profile at any given time. If a profile is assigned to a user who already has a profile, the new profile assignment overrides the previously assigned profile. Profile assignments do not affect current sessions. Profiles can be assigned only to users and not to roles or other profiles.
EXP:
Remember, profile cannot be assigned to roles. Thus D is incorrect.

Comments

No Comments Posted for this Article.

Leave a comment

You must be Loged in to post a comment.

Related

Tutorials
Forum
Books
Interview Questions

Notes on GL
۩ Fiscal Year A Fiscal year consists of several posting periods and if necessary, special periods that can be posted to after a temporary year-end closing. You define how your fiscal year is...
Oracle: Common misconceptions
Some widely accepted information about the Oracle database is shown not to be entirely correct upon closer examination. 1. The Oracle cost-based optimizer always selects the access with the...
Configuration of SQL Server 2000
Configuration of SQL Server 2000 sp_configure With the help of the Stored Procedure sp_configure, you can display and change the current, server-wide SQL server configuration. It is possible...
Can any body tell me how is future in CRM?
THE STATUS OF CRM TODAY WHAT IS CRM? Over time, customer relationship management has evolved from disconnected SFA software into strategic e-business solutions that deliver integrated...
ABAP REPORTING
ABAP REPORTING The main purpose of a list is to output data in a manner that can be easily understood by the user ; this output often takes on the form of a table. Lists in R/3 take into account...
Checking and Testing a Smart Form
Checks To activate a Smart Form, the individual nodes as well as the interactions between the nodes must be correct. To achieve this, the system offers a large variety of checks. Before you can use...
Displaying SAP error messages in a nice way.
One day I wanted to have my error messages displayed in a nice popup window (users just wanted it to be ��RED�� and shouting), but not with using the MESSAGE statement that either stops the...
Tax categories in customer master record
The button for the tax categories in the customer master maintenance cannot be hidden. In the Screen Painter the specification of modification group 1 is missing. Carry out the repair in the...
SAP has provided around 2000 user exits.
Locating User Exits Before you can add functionality to a SAP system, you need to be able to locate the appropriate user exits. SAP has provided around 2000 user exits. Searching from...
Screen Flow Logic
Screen Flow Logic Screen flow logic contains the procedural part of a screen. You create it in the flow logic editor in the Screen Painter, which is very similar to the ABAP Editor. The language...
Seasonal Planning
Purpose You can use this component to perform a flexible time-based aggregation of planning data based on season years. You can divide the time frame of a season year into as many seasons as you...
Define Business Area (at client level and not to be assigned to any co code)
T-code (OX03) A business area is an organizational unit within accounting that represents a separate area of operations or responsibilities in a business organization. When defining a business...
ABAP Certification Exam Format
Hi all, Here are the format of SAP ABAP Certification Exam Deeply Concentrate on following topics: Advance ABAP Enhancement and Modification Dialog programming List creation...
Customized Vendor code
We want the Vendor code as 'abc1234' where first 3 characters are alpha and the last four digits are digits serial numbers. What is the solution? Use an user exit. With this user exit, you can...
How do you assign an OK_CODE for a push button? How it is used in your ABAP?
In the field list ,name the element and give it the value that it will represent when pushed You must make sure that you clear the field that represents the pushbutton after every check. ...

Maximum session
Rightnow i can open 6 session, and i guess session prameter is rdisp/max_alt_mode, but where to define this session in which profile, we have three profiles default, instance and start. How can i...
How to remove empty page ...
I have problem in sap scripts its purcahse order form where it have two pages. in first page it have header ,addres,main ,footer which include the item details in main window in second page it...
Screen exit for profit center transaction (KE52).
Hi All, I have a requirement to add four custom fields in the table CEPC and for populating the value for those four custom fields i need to create a subcreen in the transaction KE52.So the users...
TRM - TJ05 quarterly assessment of BNDES
I'm having doubts about a quarterly assessment of BNDES ... upon TJ05, I get a message that there is no interest rate to be fixed, but I believe that this transaction has already been born wrong, and...
Which support pack i should install?
Hello, I have Netweaver 04 installed which has four components SAP_BASIS with release 640, level 0009 and highest supp pack SAPKB64009, SAP_ABA with release 640, level 0009. and highest supp...
Only Disply Authorizations to a single user ?
My company is working on ecc 5.0 , and in our developer server , in client 100 we have four users who can do cusomization , but i want to know can i create only one user who can have only display...
Problem with character substring
Hello, I am trying to pick up the third character of a three character variable. According to the on-line documentation, I should use the following syntax: 45 How do I retrieve a substring...
Is there any way to find out if any client does not have a Logical Name?
Hello, I am new to SAP and i am not sure if i am following the right path.I am sure this question will be easy for you guys. I was logging to a user (super user) with the client # XXX, in client#...
Client Maintenance SCC4 Options purpose - Reg.
Dear friends, In SCC4 client maintenanace screen, there are four options as below. 1. Changes without automatic recording 2. Automatic recording of changes 3. No changes allowed 4...
Different Account Codes For Credit Memo
Hello Guru's Please suggest me how we can define the seperate Reversal Account Code for the Sales Return Transaction (credit memo) in comparisson to original sales invoice acctg doc with the...
Derived Depreciation Area
Hi All, I am creating a derived depreciation area (tcode - oadb) by copying from a standard depreciation area 01 - book depreciation. Problem i am facing while creating it is, system is not...
How to Generate Single bill for each site in SAP SD
Hi, Can anyone proivde the soluiton for the below senirio, thanks in advance. We are providing test services to various sites of a corporate. Now, we want to bill as a single bill point i.e...

Starter tips trickes
Starter tips trickes Contents 1 SAP R/3.................................................... 2 1.1 Tables................................................. 2 1.2...
The SAP R/3 Guide to EDI, IDocs and Interfaces
The SAP R/3 Guide to EDI, IDocs and Interfaces Where Has the Money Gone? 1 1.1 Communication ...............................................................................................2 More...
EFFICIENT DATABASE PROGRAMMING WITH ABAP
ABAP152 The following four exercises fulfill the same task: They select all flights of carrier LH (Lufthansa) where the first class is fully booked (seatsmax_f = seatsocc_f). Then they retrieve...
Database Tuning with the Oracle Tuning Pack
Preface The Oracle Tuning Pack provides advanced tools that focus on tuning the highest impact database performance areas, such as: application SQL, indexing strategies, instance parameters...
ABAP/4 Reporting - User Enhancements
ENHANCEMENTS TO SAP OBJECTS SAP has developed its various modules with standards, which are broadly practiced all over. But yet the requirements of customers differ from place toplace. In this...
ABAP/4 Query
ABAP/4 Query is powerful tool to generate simple reports without the need for any coding. This is a very handy tool for the functional onsultants who don't have any prior programming experience...
SAP License (BC-CST-SL)
SAP Licensing Procedure Prerequisites To use your SAP software legally and in accordance with the contractual stipulations, SAP Systems can only be operated with a license key (license keycode)...

Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? (Choose four.)
Q. Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? (Choose four.) A. You cannot roll back this statement. B. All pending transactions are...
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)
Q. Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four) A. You cannot roll back this statement. B. All pending transactions are...
In which four clauses can a subquery be used?
Q. In which four clauses can a subquery be used? (Choose four.) A. in the INTO clause of an INSERT statement B. in the FROM clause of a SELECT statement C. in the GROUP BY clause of a...
Which four are attributes of single row functions? (Choose four.)
Q. Which four are attributes of single row functions? (Choose four.) A. cannot be nested B. manipulate data items C. act on each row returned D. return one result per row E...
Which four statements correctly describe functions that are available in SQL? (Choose four)
Q. Which four statements correctly describe functions that are available in SQL? (Choose four) A. INSTR returns the numeric position of a named character B. NVL 2 returns the first non-null...
Which four statements correctly describe functions that are available in SQL? (Choose four.)
Q. Which four statements correctly describe functions that are available in SQL? (Choose four.) A. INSTR returns the numeric position of a named character. B. NVL2 returns the first non-null...
Which four are valid Oracle constraint types?
Q. Which four are valid Oracle constraint types? (Choose four.) A. CASCADE B. UNIQUE C. NONUNIQUE D. CHECK E. PRIMARY KEY F. CONSTANT G. NOT NULL Answer: B,E,G,D
Oracle Certified Professional Exams IZ031 Questions Set 6
Q. Which option lists the correct hierarchy of storage structures, from largest to the smallest? A. segment, extent, tablespace, data block B. data block, extent, segment, tablespace C...
Oracle Certified Professional Exams IZ007 Questions Set 11
Q. What will happen if you call a SQL function with an argument of a datatype other than the datatype expected by a SQL function? A. the argument will need to be converted explicitly B. the...
Mark for review Which four are types of functions available in SQL? (Choose 4)
Q. Mark for review Which four are types of functions available in SQL? (Choose 4) A. string B. character C. integer D. calendar E. numeric F. translation G. date H. conversion ...
Exit Test â�� BASIS
1) Question: Which transactions is/are used for consistency check after installation? Answer: A. ST22 B. SICK C. SM28 D. ASAP 2) Question: Which R/3 dialog user is/are created...
Oracle Certified Professional Exams IZ007 Questions Set 10
Q. You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task? A. ALTER TABLE students ADD PRIMARY KEY...
Which four are correct guidelines for naming database tables? (Choose four)
Q. Which four are correct guidelines for naming database tables? (Choose four) A. Must begin with either a number or a letter B. must be 1-30 characters long C. should not be an Oracle Server...
Oracle Certified Professional Exams IZ007 Questions Set 20
Q. Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott...

Tutorials | Forum | Books | Interview Questions | Transaction Codes | Institutes | Jobs | Classifieds | News | Announcements
SAP ERP Support/Consulting | RSS/Syndication | Contact Us | Terms Of Use | Terms & Conditions

©2005-2011 SAP Techies. All rights reserved.